SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Problem connecting to SQL Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

greg99
Starting Member

2 Posts

Posted - 09/23/2008 :  11:26:01  Show Profile  Reply with Quote
I'm trying to set up replication and am running into a problem. I have the publisher/distributor running on a single server and have a publication set up fine. But when I try to set up a subscription and attempt to connect to the distributor machine, I cannot. I get stuck on the screen where it wants me to connect to the distributor machine. I understand you have to give it the actual server name along with the machine name. So for instance, I enter "10.200.233.31/ICTTCDEV". But when I enter this, I get the following error:

Failed to connect to server 10.200.233.31/ICTTCDEV. (Microsoft.SqlServer.ConnectionInfo)
An error has occured 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. (proivder: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 67)

Now, I can connect to this server just fine via SQL Server when not attempting to connect via this replication subscription wizard, so all my settings on my server are enabled. Named pipes enabled, remote connection enabled, etc. The only thing I can think that could be causing an issue is that the distributor server machine is on a domain while my subscriber machine is not.

Any help on this is greatly appreciated.

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/23/2008 :  11:28:27  Show Profile  Reply with Quote
You have to enable remote connections

http://support.microsoft.com/kb/914277
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/23/2008 :  11:30:26  Show Profile  Reply with Quote
Also see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110886
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 09/23/2008 :  11:33:47  Show Profile  Reply with Quote
quote:
Originally posted by greg99

I'm trying to set up replication and am running into a problem. I have the publisher/distributor running on a single server and have a publication set up fine. But when I try to set up a subscription and attempt to connect to the distributor machine, I cannot. I get stuck on the screen where it wants me to connect to the distributor machine. I understand you have to give it the actual server name along with the machine name. So for instance, I enter "10.200.233.31/ICTTCDEV". But when I enter this, I get the following error:

Failed to connect to server 10.200.233.31/ICTTCDEV. (Microsoft.SqlServer.ConnectionInfo)
An error has occured 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. (proivder: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 67)

Now, I can connect to this server just fine via SQL Server when not attempting to connect via this replication subscription wizard, so all my settings on my server are enabled. Named pipes enabled, remote connection enabled, etc. The only thing I can think that could be causing an issue is that the distributor server machine is on a domain while my subscriber machine is not.

Any help on this is greatly appreciated.




You should rather enable TCP/IP
Go to Top of Page

greg99
Starting Member

2 Posts

Posted - 09/24/2008 :  12:16:32  Show Profile  Reply with Quote
Hello,

Thanks for the responses. I already had remote connections enabled and both named pipes + TCP/IP enabled. I have Windows Firewall completely disabled, so this also would not be causing the issue. Is there anything else you can think of that would be causing this? Can you have the distributor and subscriber on different domains, or is this what is causing the problem?
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 09/24/2008 :  13:06:46  Show Profile  Reply with Quote
I thought it was IPaddress,portnumber ? rather than 10.200.233.31/ICTTCDEV
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000