<div>
<div class="content wysiwyg-content">
I have a SCCM test environment with a CAS and a Primary. Recently migrated the databases from SQL2012 to SQL2014 and now replication is broken.<br />
<br />
When running the Replication Link Analyzer 'isServiceBrokerRouteConfi<wbr />gCorrect' comes back False for the Broker on the CAS database. Looks like the broker routes are expecting the old SQL server address but I don't know where it is getting this info from when the migration appeared to go successfully. Can anyone help?<br />
<br />
Under the details column there are a number of messages like the following:<br />
<br />
<b>Service broker route [ConfigMgrDRSRoute_SitePRI<wbr />] is missing or has incorrect address [TCP://NewSQLServer.abc.co<wbr />m:4023] for service [ConfigMgrDRS_SitePRI]. Expected address [TCP://OldSQLServer.abc.co<wbr />m:4023].</b>
</div>
</div>


I have a SCCM test environment with a CAS and a Primary. Recently migrated the databases from SQL2012 to SQL2014 and now replication is broken.

When running the Replication Link Analyzer 'isServiceBrokerRouteConfigCorrect' comes back False for the Broker on the CAS database. Looks like the broker routes are expecting the old SQL server address but I don't know where it is getting this info from when the migration appeared to go successfully. Can anyone help?

Under the details column there are a number of messages like the following:

Service broker route [ConfigMgrDRSRoute_SitePRI] is missing or has incorrect address [TCP://NewSQLServer.abc.com:4023] for service [ConfigMgrDRS_SitePRI]. Expected address [TCP://OldSQLServer.abc.com:4023].

SCCM database replication not working after SQL database move

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.

SCCM

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.