visual studio 2010 - TFS application tier, error adding user -


I am trying to add Admin console users from another user (from other domain ...) and the process fails When the master is trying to add the account to the database

is the relevant part of the log.

Start node: ADDSYSTEMDBACCOUNT

[info @ 07: 21: 43.223] NodePath: ADDCOLLACCOUNT / ADDSYSTEMDBACCOUNT

[info @ 07: 21: 43.223 ] Adding account to system database ...

[info @ 07: 21: 43.223] Adding account to master database ...

[info @ 07: 21: 43.223] ModifyExecRole: Add: Dev \ Helis

[Error @ 07: 21: 43.363] Dev failed to add \ Heli of guru

[error @ 07: 21: 43.363] System.Data.SqlClient.SqlException (0x80131904): The role 'TFSEXECROLE' can not be changed because it does not exist or you do not have the permission. On Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException (Exception exception) in Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException (SqlException ex, QueryExecutionState queryState) (ExecuteType on executeType , CommandBehavior behavior) Microsoft.TeamFoundation at Microsoft.TeamFoundation.Admin.ConfigureAddAccountToSystemDBs.AddToDatabase Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlSecurityComponent.ModifyExecRole (String account, string role, AccountsOperation operation) (ActivityContext reference, SqlConnectionStringBuilder Builder, string dbAccount) .Admin.ConfigureAddAccountToSystemDBs.Run (ActivityContext Reference) Cl IentConnectionId: 44abd1a3-fc86-4bf5-ac58-f5ef9a7a1d08

[info @ 07: 21: 43.363] returned node: error

[error @ 07: 21: 43.363]

[info @ 07: 21: 43.363] complete AddAccountToSystemDB S: error

[info @ 07: 21: 43.363] ---------------- --------------- ----------------------

[info @ 07: 21 : 43.363] Performance result:

[info @ 07: 21: 43.363] Overall result: failed

[info @ 07: 21: 43.363] nodes full: 2

[info @ 07: 21: 43.363] with errors Node: 1 < [Info @ 07: 21: 43.363] with warnings nodes: 0

[info @ 07: 21: 43.363] Number of error messages: 2

[info @ 07 : 21: 43.363] Number of messages of warning: 0 07: 21: 43.363] Number of messages: 0 [Error 07: 21: 43.363] The activity has failed.

[info @ 07: 21: 43.363] The activity has failed and there is no management such as rolling failure.

I am managing this server I am using a user with privileges, so I think this is a permission problem.

Edit: TFS is installed on a machine (DEV-LOCAL) which was not part of the domain (DEV). The machine is now part of the domain. To wit. Given the properties of the computer, this computer shows the full computer name as "DEV-LOCAL" and "DEV-LOCAL.DEV.local". Domain name: "DEV.local"

Any ideas?

You need a sysadmin role in SQL Server to change roles.

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -