Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
Changing the name of your SQL Server causes database related errors
KB1859 | Last review: Jan 22, 2014 | Netwrix Auditor | All Versions
|Symptoms||After changing the name of the server which hosts the SQL Instance for Netwrix Auditor databases you receive the following in Change Summary emails:
Error saving AD history to database: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
|Cause||The server name is not correct in the product configuration anymore as well as in the SQL server configuration.|
|Resolution||1) Open the Netwrix Auditor console
2) Navigate to Settings -> Reports
3) Click on Configure and change the SQL Server Instance name to match the new SQL Server name.
4) Verify the Report Server URLs are still accurate and change them also if necessary and then hit OK.
5) Modify the SQL Configuration by following the following technet article: http://msdn.microsoft.com/en-us/library/ms143799.aspx
Was this information helpful?