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 |
|
shagnthings
Starting Member
4 Posts |
 Posted - 2004-04-02 : 14:27:41
|
| We have a wk23 server running sql 2000 sp3a (build 8.00.760) that is having replication problems. I've been trying to setup the distribution (replication database) on the server and got as far as doing so once. I thought I was home free until it gave me a null error "error 14114: '(null)' is not configured as a Distributor".After reading so much on these errors most were referring to the fact that my local sql server did not have the ID of 0 (very important). I ran some commands (sp_dropserver & sp_addserver) with success. Then it suggested rebuilding replication. So in doing so, I could no longer add my distribution database to the server???Currently, I'm running an nt account "ntaccount" with admin permissions and "log on as service" rights. It's starting the sqlserver & dep. Services. I've added this account into the sql accounts with admin server roles. Basically has all permissions for everything!I don't know why I keep getting blocked to create the distribution database? Currently I'm getting the "14117: 'distribution' is not configured as distribution database".Any help with this problem would be greatly appreciated....Shagnthings |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-02 : 14:55:41
|
| So in EM, when you right click on your server and go to properties, then to replication tab, you've clicked configure and set it all up in there? If you have I would click disable, then remove everything, then configure it again.Tara |
 |
|
|
shagnthings
Starting Member
4 Posts |
Posted - 2004-04-02 : 14:59:32
|
| Yes, I've done that many times. Could it be that the distribution database created initally was never completly deleted and this is confilting with it?BTW, I'm building replication via the "Configure dist, pub, & sub." wizzard, but I don't think that makes a difference does it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-02 : 15:06:22
|
| I would disable replication again. Then check if the distribution database remains. If it does, manually delete it as well as any left over replication jobs (not there should be any). Then try configuring it again. It does sound like replication was deleted at some point but it didn't completely do it.Tara |
|
|
|
shagnthings
Starting Member
4 Posts |
Posted - 2004-04-02 : 15:14:52
|
| That's the thing. The distribution database is never created. Under databases there is no distribution db.After looking in explorer admin has all permssions to create and delete this database. One thing that stands out though, and maybe this is the problem: There are 2 files in the data directory called distmdl.ldf and distmdl.mdf. Are these the distribution database files? Could I delete them and try again? |
|
|
|
shagnthings
Starting Member
4 Posts |
Posted - 2004-04-02 : 15:40:00
|
| Here is some added information after playing with this for while. Those two files I talked about were moved to another folder and it didn't change anything.When configuring replication, any publishers or subscribers I add to the distribution database will result in an error. If none are applied (ie. just the distribution database is created) then it gives a success prompt. But get this, if I try to configure rep. some more like add pub. or sub. then it gives the error "could not retrieve information about the distributor or distribution database". Under databases there is no distribution database (I think there is suppose to be one, right?), plus there are no more files re. distribution added anywhere in the mysql folders.Do you think there is something wrong with the master database? Should I consider rebuilding that database at this point? Or is there something else I should look into? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SQL 2000 Replication Problem