InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:46:34 GMT20http://www.sqlservercentral.com/Forums/Topic1354321-391-1.aspxDuplicate post. Please refer to [url]http://www.sqlservercentral.com/Forums/Topic1354322-391-1.aspx[/url]Wed, 05 Sep 2012 01:24:01 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1354321-391-1.aspx[font="Tahoma"]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. [code="sql"]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='******'[/code]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..[/font]Tue, 04 Sep 2012 23:20:15 GMTMuraliKrishnan1980