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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-12-21 : 12:36:46
|
| Hi,When I am trying to configure distributor on my local computer I am getting following error. TITLE: Microsoft.SqlServer.ConnectionInfo------------------------------SQL Server could not configure '......\......' as a Distributor.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.Changed database context to 'master'.Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install. Creating distribution tables Creating table MSrepl_versionCreating table MSpublisher_databasesCreating clustered index ucMSpublisher_databasesCreating table MSpublications.............. Dropping all distribution stored procedures and functions that are now in resource or are obsolete Dropping all distribution stored procedures and functions that are created locally Creating 'fn_MSmask_agent_type'.Creating 'sp_MSset_syncstate'........... Adding user 'guest'. Adding role 'replmonitor'. Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install. (Microsoft SQL Server, Error: 22538)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=22538&LinkId=20476Any help?Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-22 : 11:58:48
|
| I solved this issue by deleting jobs releated to replication. After that I was able to configure distributor. Now replication is working perfectly. |
 |
|
|
|
|
|
cannot configure distributor