Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
polynomial
Starting Member
4 Posts |
 Posted - 2003-11-28 : 06:16:55
|
I have been asked to setup replication between two SQL Server 7 services, and have stumbled into an error I can find no information about.I am following this guide: http://www.intagsystems.com/Xfactory%20Replication.htmIt is having a problem on the first step when creating the distributor, the error message I am getting is:SQL Server Enterprise Manager could not enable 'server1' as a Publisher.Error 14117: 'distribution' is not configured as a distribution database.The error is occuring during the stage where this dialog is onscreen: I could be missing something incredible obvious here as SQL Server administration is not my strong point, so any help would be gratefully received :)Also, not sure if its important, but I had to use sp_dropserver/sp_addserver to change the name of the SQL server aswell, as neither of the machines were matching the names of the machine they were installed on. I have been told that the servers may have been setup by copying all the data files from an old installation of SQL server (including master etc) and then starting the service? As I say I know little of SQL server, and even less about these particular servers so any help would be very good.Thanks in advance |
|
|
polynomial
Starting Member
4 Posts |
Posted - 2003-12-04 : 07:11:53
|
| Nobody have any ideas at all as to what might be causing this? Like I said before, I may be missing something really obvious so don't be afraid to suggest something very simple.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-04 : 12:27:08
|
| Can you walk us through the steps that you did to configure the distributor? I can then do these steps on my machine and see what happens.Tara |
|
|
|
polynomial
Starting Member
4 Posts |
Posted - 2003-12-05 : 04:27:31
|
| Certainly, I've pretty much followed the guide to the letter:Two servers, server1 and server2. server1 is running a bunch of websites, some of which use SQL databases. server2 is on the same local network and is meant to be a redundant server, essentially mirroring what is on server1 at all times. A custom program runs several times a day which takes care of all of the files, but the data from the SQL server isn't taken care of. The only way we could copy the data files is with the SQLServer service stopped, which we would rather avoid.This led me to replication, which from what I can see will suit the needs nicely, allowing server2 to always be synchronised with the data on server1.The steps I am going through are:1) In enterprise manager, select server2 and goto Tools->Replication->Configure Publishing and Subscribers2) Click next on the splash screen for the wizard.3) Select the option "Yes, use 'server2' as the Distributer." and click next.4) Select "Yes, let me set the distribution..." and click next.5) Accept the default options for the distribution database (in my case, db name is 'distribution' and files are stored in D:\MSSQL7\data)6) Unselect 'server2' from the list and check 'server1' on the list of enabled publishers. Click the '...' button and set the SQL Authentication (we have no NT authentication between the two servers because of the location). Set the checkbox saying it requires a login as it isnt a trusted server. (I have tried a multitude of options on this screen to make sure it wasn't something simple, but I get the same error message at the end of the process every time). Accept the Properties screen, and select next.7) On the wizard summary page the text says:Use 'server2' as the Distributor.Store the distribution database 'distribution' in 'D:\MSSQL7\data'.Enable the following servers to use 'server2' as their Distributor when they are later configured as Publishers: server18) Click Finish.9) Dialog appears with three items on it and checkboxes appear next to them as the process completes. The first one definitely completes ok, and either on the second or third item (its hard to tell which) the error appears as I described in my first post:SQL Server Enterprise Manager could not enable 'server1' as a Publisher.Error 14117: 'distribution' is not configured as a distribution database.Thank you for your interest, look forward to hearing any suggestions you may have. |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-12-05 : 05:47:29
|
| I'd like to suggest a few things:First of all, could you run the following commands on the distribution server and show us the output?SELECT @@VERSIONGOSELECT @@SERVERNAMEGOAlso, do one thing at a time. Do not enable publishers to start with. Just create a distributor, without any publishers. If that succeeds, enable one publisher at a time.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
polynomial
Starting Member
4 Posts |
Posted - 2003-12-05 : 05:57:01
|
| Microsoft SQL Server 7.00 - 7.00.1094 (Intel X86) May 29 2003 15:21:25 Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)Servername is correct and matches the WINS name of the machine its on.Will test doing it in stages shortly, thanks for the help VyasKN. |
|
|
|
|
|
|
|
|
Replication error