Linked Server - server name same as instance name

I am trying to configure a linked server in SQL 2005 to point to a server that has the same name as the SQL 2005 instance name. In other words, my computer name and SQL Server 2005 instance name are both EMUNDORF. In the "New Linked Server" dialog, I set the following:

Linked Server: EMUNDORF

Provider: SQL Native Client

Product Name: EMUNDORF

Data Source: EMUNDORF\EMUNDORF

This does not work. If I configure a Linked Server to a server with a named instance that is different than the server name, it works. The following is the error I get:

OLE DB provider "SQLNCLI" for linked server "EMUNDORF" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "EMUNDORF" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Msg 50000, Level 16, State 2, Line 10

Unable to connect to server. This operation will be tried later!

Can someone tell me what I am doing wrong?

The error is the same as if I try to connect to a server that is no longer running. I double checked all my settings with a server that has a named instance, and can link to other servers, but I can see no differences. The other strange thing is that my server can link to other servers, but no one is able to connect to mine. I know it has to be a setting somewhere...but where?|||

Did you enable remote connections for the server instance (It is disabled by default). To do that -

Go to Configuration Tools -> SQL Server Surface Area Configuration

Select Surface Area Configuration for Services and Connections

You should be able to see your server instance in the available components, Select Database Engine -> Remote Connections and then click on Local and Remote Connections with the Appropriate protocol. You need to restart the service once you save the settings.

Hope that helps,

Kuntal

|||

I would expect your product name to be NULL since you are using SQL Server.

I have success with these:

sp_addlinkedserver @.server = N'yourLnkdSrvName', @.srvproduct=N'',@.provider='SQLNCLI', @.datasrc=N'yourserver/instance' ;