October 4, 2010 at 11:29 am
My company just dropped this project in my lap and I am a SQL n00b. They want me to migrate our sql setup from our old servers to a cloud solution. They have purchased one physcal machine to house the databases and 6 virtual machines to handle replication. 1/2 the machines are fail overs. I am trying to setup two servers, publisher and distributor. My publisher houses all my databases (about 80) and the distributor will have all the subscriptions. Does anyone have any good resources for setting this up? I have the distributor configured but when I go to my publisher to set it up I get to the part of the wizard that asks for the distributor password and it fails even though I am using the correct password. I will post the error shortly.
October 4, 2010 at 11:31 am
TITLE: Configure Distribution Wizard
------------------------------
SQL Server could not connect to the Distributor using the specified password.
------------------------------
ADDITIONAL INFORMATION:
Connection to server [189567-2] failed.
OLE DB provider "SQLNCLI10" for linked server "15D2EEC4-C764-4719-A224-B6C6289BA65C" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "15D2EEC4-C764-4719-A224-B6C6289BA65C" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". (Microsoft SQL Server, Error: 21670)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=21670&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
October 4, 2010 at 12:35 pm
Google will yield lots of results for documents outlining setting up replication.
Do you have a firewall between the publisher and subscriber?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
October 4, 2010 at 12:58 pm
I do but all firewall rules are set up. I can connect both direction using SQL management studio
October 4, 2010 at 1:11 pm
Did you already configure the distributor as a distributor?
I.e. connect to the server, right click Replication, and go to Configure Distribution?
October 4, 2010 at 1:16 pm
yes and listed my publisher and I set the publisher password. When I went to my publisher I get to the part in the wizard that has me list the distro and then it asks me for the password. That is were it comes back as bad password. I have gone through everything several times
October 4, 2010 at 1:25 pm
Is it the default instance? Using a static/default port (1433)?
If so, could try adding a hosts file entry for it, since you can't do replication via IP/FQDN/etc. I've had to do this with a few of my servers that replicate to others that aren't in the same domain.
October 4, 2010 at 1:40 pm
That worked!! I added the entry to the host file and it let me complete that wizard. Now I am off to figure what is next. I need to get the snapshots to the distributor so I can set up subscriptions on the the distributor.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply