Solved

SQL instance with specific port number

Forum|Forum|2 years ago
August 31, 2023
2 replies
484 views

+6

TD89
Novice

Hi,

My client changed the port number of his SQL instance to a specific number. His reason was to hide the instance for security purposes. However, it caused Commvault failed to backup that SQL database. with the error “Failed to validate the credentials for instance...”

The client told me that everything that needs to point to that instance has to has the instance name like this SQLDB01,port-number\DB01

I wonder, what could I do in Commvault to back up this SQL database?

Thank you.

Best answer by Damian Andre

I believe these are the right steps to take:

1. Disable SQL browser service

2. Create an alias for SQL - which allows use of the non-default port: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?redirectedfrom=MSDN&view=sql-server-ver15

From there the instance should be discoverable from the SQL agent