When Failing Over to a SQL Mirrored Database, the Provisioning Server Shows as Offline and is Unable to Connect
Article ID: CTX128723
Updated On:
Description
When failing over to a SQL Mirrored Database, the Provisioning Server shows offline and is unable to connect.
Resolution
Install the SQL Server Native Client on all the Provisioning Services servers.
Problem Cause
If you are using Database Mirroring feature, then the SQL native client is required on the server. If this client does not already exist, the option to install SQLncx64 or SQLncx32 is presented when the product software is installed.
Complete the following to verify if you are missing SQL native client:- Open Administrative Tools > ODBC Data Source Administrator.
-
Click the Drivers tab. SQL Server Native Client should be listed, as displayed in the following screen shot.
Issue/Introduction
This article provides resolution when the Provisioning Server shows as offline and is unable to connect when failing over to a SQL mirrored database.
Was this article helpful?
Yes
No
Powered by
