Friday, March 9, 2012

error when attempting to configure a local distributor

i'm getting the following error message when i attempt to configure my server as a local distributor:

TITLE: Connect to Server

Cannot connect to 9A6375C3046246B.

ADDITIONAL INFORMATION:

Failed to connect to server 9A6375C3046246B. (Microsoft.SqlServer.ConnectionInfo)

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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

this error is occuring despite the fact that i have the server configured to allow remote connections. can someone please help me troubleshoot this error? thanks.

Try after enabling named pipes by default it is only TCP/IP...

Is it default instance or named instance? if it is named instance try to use portnumber along with server name.

ex: servername\instancename,portnumber

|||

MohammedU wrote:

Try after enabling named pipes by default it is only TCP/IP...

Is it default instance or named instance? if it is named instance try to use portnumber along with server name.

ex: servername\instancename,portnumber

i enabled remote connections to be named pipes only and i'm still getting the same error. i'm using a default instance.|||

check whether the server is Firewall enabled. You need to create exception on port

refer

http://support.microsoft.com/kb/914277

Madhu

|||

Madhu K Nair wrote:

check whether the server is Firewall enabled. You need to create exception on port

refer

http://support.microsoft.com/kb/914277

Madhu

the windows firewall is already disabled. do i still need to create an exception?

|||does anyone from microsoft care to chime in? anyone else?|||

Please check if "select @.@.servername" is returning back you the right ServerName (Boxname)?

If not use

-- sp_dropserver 'incorrect servername','droplogins'--

and

-- sp_addserver 'correctservername','local'--

Even if the select @.@.servername is showing the right servername , Query select srvid from sysservers where srvname=’9A6375C3046246B’

If srvid is not = 0 use sp_dropserver and sp_addserver mentioned above (but this time the incorrect servername will be = correctservername )

Note you need to restart service once for changes to be in effect.

Regards

Rishi Maini

|||

Rishi Maini SQL DBA wrote:

Please check if "select @.@.servername" is returning back you the right ServerName (Boxname)?

If not use

-- sp_dropserver 'incorrect servername','droplogins'--

and

-- sp_addserver 'correctservername','local'--

Even if the select @.@.servername is showing the right servername , Query select srvid from sysservers where srvname=’9A6375C3046246B’

If srvid is not = 0 use sp_dropserver and sp_addserver mentioned above (but this time the incorrect servername will be = correctservername )

Note you need to restart service once for changes to be in effect.

Regards

Rishi Maini

thanks for replying. the correct query is the following:

use msdb

go

select srvid

from sys.sysservers

where srvname = '9A6375C3046246B'

the query result is: 0

any other ideas? anyone else care to chime in?

|||i still need help with this issue.

thanks in advance|||i'm going to keep bumping this thread until i get a response from someone with microsoft.|||

Duane Douglas wrote:

i'm going to keep bumping this thread until i get a response from someone with microsoft.

|||

Are you trying to setup through UI or sp?

Have you tried to use "sp_adddistributor"?

If this is an urgent matter, please contact customer support, this is a forum.


Gary

No comments:

Post a Comment