SQL Server Storage Engine & Tools (SSQA.net) : Can't find linked server in management studio?

Recent Posts

SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies
SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose
SQL Server Upgrade issues - How to evaluate potential issues?
Adhoc solution to perform SQL Server database maintenance tasks - more features
Do you know how many Monitoring Tools and Resources available in SQL Server?

Tags

News

Technical & Business training in UK

Navigation

MSDN Blog

Archives

Can't find linked server in management studio?

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is:

You will find under Management studio open connection against that SQL instance and see under Server Objects --> Linked servers.

For further reading on creating linked server against Oracle or any other data source refer to in addition to the books online examples look at:
http://support.microsoft.com/kb/280106
http://www.sqlusa.com/bestpractices2005/linkedservertooracle/

Posted: Thursday, June 28, 2007 7:41 AM by SQL Master

Filed under: server, sql server, security, enterprise, ssms, linked, management, sql express, oracle

Comments

SSQA - SqlServer-QA.net said:

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under

# June 28, 2007 7:13 PM

Residential Property Investment said:

Looked at some places in ATL today. Not because I’ m a buyer, but because I am fascinated by it all. Ppl still asking crazy prices for homes (intown small 1920’ s 3/ 1 bungalows in good areas are over 450k), but whereas they used to sell in a few weeks,

# March 25, 2009 4:56 PM

Anonymous comments are disabled