CODEWITHSUNDEEP
tfs
BattlFrog
BattlFrog

Reputation: 3397

TFS 2010 install - where to enter SQL Server credentials

I am installing TFS 2010 on a server, on which I am an admin. The database is on a different server that I am not an admin on, but the DBA gave me a temp login with the permissions needed to install and configure TFS. So I have two different logins, one for the tfs server, and one for the SQL Server.

During the TFS install I can enter the server name but when I click "List available databases" it errors out. Do I need to ask the DBA to give my TFS admin server login the permissions on SQL Server? Or do I just need a little more permissions in SQL Server so I can list the databases, then when I enter the SQL Server login to connect?

Upvotes: 1

Views: 109

Answers (1)

MrHinsh - Martin Hinshelwood
MrHinsh - Martin Hinshelwood

Reputation: 23444

TFS needs pregnant access to SQL server as SYS Admin.

The instance of SQL used by TFS is part of the TFS application and should not be used for anything else. This is why SQL server standard comes included with TFS for a single server config.

The TFS install account needs SYS Admin, as does the account that TFS runs under. In addition any attempt to modify the configuration of SQL from that setup and used by TFS will result in an unsupportable instance.

Upvotes: 2

Related Questions