Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Unable to access the Linked Server Expand / Collapse
Posted Tuesday, September 4, 2012 11:20 PM


Group: General Forum Members
Last Login: Thursday, March 3, 2016 11:43 AM
Points: 121, Visits: 1,409
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
Posted Wednesday, September 5, 2012 1:24 AM



Group: General Forum Members
Last Login: Wednesday, October 5, 2016 12:14 AM
Points: 5,281, Visits: 7,008
Duplicate post. Please refer to

Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1354350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse