Installing Team Foundation Server with a remote SQL Server database

I am evaluating TFS 2010. I am trying to install on our application server, which is located in a domain and is running Windows 2008 R2 Standard.

We already have SQL Server on a separate Windows 2008 window that I want to use - this is in the same domain.

After installing TFS, I use the advanced configuration wizard to try to complete the configuration. There are 3 bits that report errors: “Database” and “Reporting”.

When I enter SQL Server data, TFS gives me this error:

TF255049: A connection cannot be made to the server that is running SQL Server. Verify that you have entered the correct name for the server, including the instance name, that the server you attempting to connect to is online, and that you have required permissions to connect... (it goes on a bit more)

The server on which I installed TFS is a web server that runs several .Net websites that can connect to SQL Server without problems.

I tried the IP address, machine name, instance name - all report the same error.

Has anyone been in this situation before?

EDIT: It’s strange if I go to the Report Server page in the wizard and enter the name SQL Server, it connects correctly to get the report server URL and the report manager URL. So it looks like this is related to the user account?

+3
source share
1 answer

Two things spring:

You need to make sure that the TFS service accounts have permissions on the database server.

If Windows Firewall is included in the TFS field, disable it for a minute or two and try again.

If this is resolved, return it and open the SQL ports.

NTN

+1
source

All Articles