March 5, 2024 at 8:01 pm
Selected the default options on the wizard.. to create the distributor..
It finishes with
Configure the distributor --> Error
==================================
SQL Server could not configure 'xxxxx\YYYYY' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationServer.InstallDistributor(String password, DistributionDatabase distributionDB)
at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.InstallDistributor(WizardInputs inputs, Boolean bScripting)
at Microsoft.SqlServer.Management.UI.ConfigureDistributionWizard.InstallDistributor(Boolean& anyExceptions, Boolean bScripting, ApplicationException& outerEx, StringBuilder command)
===================================
The server '(null)' is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard.
Changed database context to 'master'. (Framework Microsoft SqlClient Data Provider)
------------------------------
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-14099-database-engine-error
------------------------------
Server Name: xxxxxx\yyyyy
Error Number: 14099
Severity: 16
State: 1
Procedure: sp_adddistributor
Line Number: 120
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType, Boolean retry)
sp_helpdistributor
output..
distributor distribution database directory account min distrib retention max distrib retention history retention history cleanup agent distribution cleanup agent rpc server name rpc login name publisher type delete batch size xact delete batch size cmd distribution_listener
NULL NULL NULL NULL NULL NULL NULL NULL NULL REPL_DISTRIBUTOR NULL NULL NULL NULL NULL
March 6, 2024 at 7:59 am
Error states its already a distributor.
So someone / something has already tried to set it up and didn't finish the configuration.
Remove distribution as per the error message and try reconfiguring it again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply