Can't create distribution database

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.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Can't create distribution database

Author

Topic

foolproof
Starting Member

4 Posts

Posted - 2005-09-02 : 15:02:58

I have a problem with replication of my sql server. We didn't set domain controller and server is running on win2k advanced server. When we create the distributor for one of my servers, it poped up the distributor_admin has not defined remote login. Then we us sp_dropserver and sp_addserver to rename my server to IP based name and used client network utility to set an alias(based on IP too) such as 192.168.2.10.
We use both windows and sqlserver login. It fixed.

When I used tools-->wizards-->replication-->configure publishing and distribution wizard to configure the distributor. It failed at the last step. with Error 14117: 'distribution' is not configured as a distribution database.

Any hint

Thank you

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-04 : 22:16:14

use:

tools--> replication--> configure publishing, subscribers, distribution

--------------------
keeping it simple...

foolproof
Starting Member

4 Posts

Posted - 2005-09-05 : 11:31:41

Same thing. It runs the same wizard without any different.
Any hint?

Thx

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-06 : 23:15:01

what exactly did you do? can you provide the steps?

--------------------
keeping it simple...

foolproof
Starting Member

4 Posts

Posted - 2005-09-07 : 11:22:08

sure.
pre-configure step:
1. use sp_dropserver to delete the old server name
2. use sp_addserver to add server's name to '192.168.2.10'
3. use client net work utility to give alias name '192.168.2.10' same with the server's new name.
4. set a share fold 'sharedata' to full control privillege to everyone

configure step:
1. tools->wizard->replication->configure publishing and distribution Wizard

2. into the Wizard: specify '192.168.2.10' or another server as 'distributor'
click "next"

3. Make '192.168.2.10' its own distributor SQL Server will create a distribution database and log.
click "next"

4. Specify snapshot fold "\\db2k\sharedata" click "next"

5. Let me set distribution database properties..... click "next"

6. using 'distribution' as databae name, using default locaiton
click "next"

7. pick one of server as publisher(which is not configured as publisher yet).
click "next" jump warning dialog and so on

8. at the final stage. click "finish"

9. error 14117 'distribution' is not configure as a distribute database .

Any comments??

Thx

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-09-08 : 01:25:08

i think you missed out restarting the sql services after #2 in pre-configure step

also, did you query if the sqlservername = machinename?
use @@servername to double check

--------------------
keeping it simple...

foolproof
Starting Member

4 Posts

Posted - 2005-09-08 : 18:37:10

thx.
no my sqlsrevername <> machinename
since I failed to create distributed database for distribute_admin having no network access privilledge.
After I change to IP base servername, this error was gone.

Now I reinstall the whole database server. Now I succeed to set distribution database. But I can't authneticate my publisher which is running on SQL server 7.0

quote:
Originally posted by jen

i think you missed out restarting the sql services after #2 in pre-configure step

also, did you query if the sqlservername = machinename?
use @@servername to double check

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources