I've been having a very tough time trying to get the simplest of linked servers to work. I've managed to create similar linked servers on my home PC, but the Management Studios on my office PC are hanging whenever I try to do anything with a linked
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.
More specifically, just the portion of the Management Studio that I'm working with hangs... i.e. If it's a query, then that specific query window will be 'executing query...' for hou
View Complete Post