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 - 2007-03-05 : 10:46:45
|
| Ryan J. Boyle writes "I'm trying to set up repliction on my SQL 2005 instance. When I run through the "Configure Distribution Wizard" the wizard errors out, here is the following error message that I'm reciving. I can not find any information based on that SQL Server Error number (there is none in the help file go figure) ERROR MESSAGE: SQL Server could not configure <servername> as a DistributorAdditional Information: An exception occurred while executing a Transact-SQL statement or batch Microsoft.SqlServer.ConnectionInfoOnly replication jobs or job schedules can be added, modiifed, dropped or viewed through replication stored procedures. Changed database context to 'master'(Microsoft SQL Server Error 22538)Any help in troubleshooting what this issue could be that would be great. Thanks in advance. Ryan J. Boyle" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-08 : 17:05:17
|
| is your distributor the same as the publisher? it appears to be a connection error, verify if the distributor is accessible by the publisher, you will need to configure it first to become a distributor if the wizard doesn't handle this...i haven't done any replication yet on 2005, will try tomorrow hmmm...--------------------keeping it simple... |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-17 : 01:54:43
|
| Do you have sufficient access to create replication?Is subscriber and distribut is on the same machine??Did you try configuring the distributor with procedures...sp_adddistributor @@servername go sp_adddistributiondb 'distribution' MohammedU |
|
|
|
|
|
|
Configure Distribution Database Wizard Fails