Share via

Changing TFS repository port number

Lee Creel 1 Reputation point
2021-08-04T14:43:26.073+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 51,346 Reputation points
    2021-08-04T14:56:06.813+00:00

    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.

    0 comments
  2. Cris Zhan-MSFT 6,616 Reputation points
    2021-08-05T02:52:41.103+00:00

    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

    0 comments