Unable to access the Linked Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to access the Linked Server

Unable to access the Linked Server

Rate Topic

Display Mode

Topic Options

Author

Message

MuraliKrishnan1980

Posted Tuesday, September 04, 2012 11:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:23 AM
Points: 112, Visits: 1,342

Hi Friends,
I have been trying to create a Linked Server from my machine for the last few days and I am not able to do so successfully. My Machine is having SQL Server 2008 R2 Dev Edition and the machine that i am trying to connect is SQL Server 2008 Express Edition.

I have enabled the Named Pipes and TCP/IP in the Express Edition Machine. Please find below the code that I am using to create the linked server.

EXEC master.dbo.sp_addlinkedserver @server = N'PC068751\SQLEXPRESS', @srvproduct=N'',@datasrc = N'PC068751\SQLEXPRESS',@provider='SQLNCLI'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'PC068751\SQLEXPRESS',@useself=N'False',@rmtuser='****',@rmtpassword='******'

I have masked the username and password for security purpose.

However I am getting an error while trying to test the connection or access the server using OPENROWSET. I have read numerous articles. However I am unable to resolve the issue. Your help would be appreciated..

Post #1354321

Stewart "Arturius" Campbell

Posted Wednesday, September 05, 2012 1:24 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164, Visits: 4,344

Duplicate post. Please refer to http://www.sqlservercentral.com/Forums/Topic1354322-391-1.aspx

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1354350

« Prev Topic | Next Topic »

Permissions