SQL instance with specific port number

Question

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.

Damian Andre · Accepted Answer

I believe these are the right steps to take:1. Disable SQL browser service2. 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-ver15From there the instance should be discoverable from the SQL agent

TD89 · Answer

@Damian AndreThank you Andre. I told the DBA about what you said, and we were able to get the back up running again.

SQL instance with specific port number

2 replies

Reply

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded