Changing TFS repository port number

Question

Our DBA is planning to change the port number for the SQL database used for the TFS repository. We are using an on-premises model on a singe server. I need to know what I need to change to support this port number change. Any ideas?

Answer 1

You can look in the TFS Admin Console to see if it is editable there but I don't remember it being editable in TFS. Not sure about the Azure DevOps rebrand version. The alternative is to use TfsConfig. Note that you'll need to remap the warehouse and reporting DBs as well if you're using that.

For the connection string you need to include the port number. For this the syntax is a little different <server>,<port> (e.g. myserver,1234). Also note that when you stop using the default port then SQL instances are no longer relevant. Each SQL instance requires its own port and therefore by specifying the port explicitly you don't need to include a SQL instance name anymore, if you were using them to begin with.

Answer 2

Hi,

Welcome to Microsoft Q&A!

The TFS(Azure DevOps Server) is not currently supported here on Q&A. You could try asking in the dedicated Azure DevOps forum below, the experts there may know more:
https://developercommunity.visualstudio.com/report?space=21&entry=problem