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.
12,894 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Michael Taylor 49,246 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 No comments

  2. Cris Zhan-MSFT 6,611 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 No comments