I've been having a very tough time trying to get the simplest of linked server to work. I've managed to create similar linked servers on my home PC, but the Management Studios on my office PC is hanging whenever I try to do anything with a linked server.
I have both SQL Server 2005 and 2008 express editions installed on my work PC. I also have a number of ODBC DSNs to a variety of data sources (ACCESS DBs, another MS SQL server (2005), an Oracle server, EXCEL files, .gdb databases, etc.). These DSNs
all work properly to create connections, all have been tested outside of the Management Studio without any problem.
I can create the Linked Servers in both 2005 and 2008 Servers, but any time I try to interact with them, the Management Studio hangs.
For example, if I:
- Test Connection in 2008
- Expand the Linked Server catalog in 2008
- Run any form of query against the Linked server (This includes both direct queries and OpenQuery() queries)
- Alter any of the Linked Server Properties.
Pretty much the only thing that I can do is create the linked server. Any other action on the linked server causes the Management Studio the hang, regardless of any timeout that I specify.
This has m
View Complete Post