This has to be fairly common request but I can not find and answer.

I have sql server and tfs installed on the same machine and I want to change the port that sql server uses but I cant until i can find out how to tell TFS and Sharepoint to use look for sql server on a different port.

Whats involved in such a change.

Denton

The connection strings are stored in web.config and a database table.

Configuration file

InstallDirectory\Web Services\Services\Web.config Connection string used to access database by the Services web application. This web application is contacted by the other web apps (Version Control, Team Build, ....) when those applications obtain their individual connection strings.

Database

The TFSIntegration database table tbl_Database contains the raw elements of the connection string for the other web apps. The name column indicates which application; connection contains the template for the application and the dbname and dbserver values are added to the template. The constructed connection string is then used by the web appplication.

Except for Services, the Team Foundation web applications access the connection strings through the application's registration data (there's a section with database information in the registration data).

Jeff's correct, but officially we only support the default instance (port 1433) in our V1 product, but several customers have "gotten it to work".

One of the critical things to keep in mind is that switching to this unsupported configuration not only causes problems with support by Microsoft's Support teams (of course), but also may cause problems with servicing (applying future service packs, upgrades to a later version, etc.). Because of that, I'd caution against doing this unless it's really needed.