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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-12 : 08:51:55
|
| Geir writes "We have 2 servers, call them SQL1 and SQL2.SQL1 is a publisher and a distributor SQL2 is a subscriber to the publications on SQL1I'm using Transactional Replication with Immediate Updating Subscribers.To create the publisher I use this commando:sp_adddistributor 'distributor'And I got no error message, but when I try to create a publication (I use this commando: sp_adddistributiondb 'CUSTOMERORDERS') i got this error message:Server: Msg 14114, Level 16, State 1, Procedure sp_adddistributiondb, Line 157'(null)' is not configured as a Distributor.I have also tryed to do this in SQL enterprise manager, but i got the same error message. I'm using sql 2000 and windows 2000 server. What must I do to fiks this error?Best regardsGeir" |
|
|
|
|
|
Error when using replication