TFS Integration Service error (The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Login failed for user 'WORKGROUP\MACHINE_NAME$).

Question

Hi,

I am trying to migrate TFS projects from TFS 2010 hosted on server1 to TFS 2013 hosted on Azure VM (to a different team collection). I am using TFS integration tools to do this. After setting up the configuration and when I try to run the migration, I am getting error in the log file as below. Hope I need to mention the user info for source and target I on the config file. But I do not know on which element I need to provide those details. Help in this regard is much appreciated.

[2/14/2014 5:29:59 PM] TfsIntegrationService.exe Information: 0 : : StartSessionGroup: Enter with sessionGroupUniqueId: 175b5068-13e4-4758-af18-3ab89b83cf14
[2/14/2014 5:29:59 PM] TfsIntegrationService.exe Warning: 0 : : The underlying provider failed on Open.
[2/14/2014 5:29:59 PM] TfsIntegrationService.exe Information: 0 : : System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Login failed for user 'WORKGROUP\MY-WINVM-01$'.
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
[2/14/2014 5:29:59 PM]    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
[2/14/2014 5:29:59 PM]    at System.Data.SqlClient.SqlConnection.Open()
[2/14/2014 5:29:59 PM]    at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
[2/14/2014 5:29:59 PM]    --- End of inner exception stack trace ---
[2/14/2014 5:29:59 PM]    at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
[2/14/2014 5:29:59 PM]    at System.Data.EntityClient.EntityConnection.Open()
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ObjectContext.EnsureConnection()
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
[2/14/2014 5:29:59 PM]    at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__2[TResult](IEnumerable`1 sequence)
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
[2/14/2014 5:29:59 PM]    at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
[2/14/2014 5:29:59 PM]    at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
[2/14/2014 5:29:59 PM]    at Microsoft.TeamFoundation.Migration.Toolkit.WCFServices.MigrationService.IsSessionGroupObsoleteOrDeleted(Guid sessionGroupUniqueId)
[2/14/2014 5:29:59 PM]    at Microsoft.TeamFoundation.Migration.Toolkit.WCFServices.MigrationService.StartSessionGroup(Guid sessionGroupUniqueId)

Answer 1

Hi Caddy78.

Thanks for your post.

Which account you used to running the TFS Integration Tools?

On the source this account need enough rights to read the data, on the machine which you are running the TFS Integration Tools this account need admin rights, on the target this account need to be a member of the Project Collection Service Accounts group and have write access to the target team project. For the permissions to perform one-way migrate, please refer to the information in this blog: http://blogs.msdn.com/b/willy-peter_schaub/archive/2011/05/13/tfs-integration-tools-where-does-one-start-part-2-try-a-simple-migration.aspx.

I’m not sure which account(in Project Collection Service Accounts group) you use it connect to your TFS 2013 Server(hosted on Azure VM), if you cannot add that TFS 2013 Server account to your TFS 2010 Server, please refer to the useful information in this article: http://www.felinesoft.com/blog/index.php/2010/11/tfs-to-tfs-migration-between-two-domains/.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Hi,

Thanks for your response. I have tried the steps you have mentioned. The username at both the servers are same and it is added to the service account group of both the TFS machine. And it has write permissions on both the TFS servers. But still I get the same error as below.

TfsIntegrationService.exe Information: 0 : : System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Login failed for user 'WORKGROUP\SALEEM-WINVM-01$'.

I think it is a connectivity problem between TFS integration tool and SQL server 2012 hosted in the same machine of TFS 2013 and it is where I run the integration tool as well. Also is there a way of specifying the connection details between TFS integration tool and SQL server it is connecting.

Answer 3

Hi Caddy78, 

Thank for your reply.

Yes, it seems is a connectivity issue between TFS Integration Tool and SQL Server. According your description, your TFS 2013 installed in SQL Server 2012 on Azure VM, and the TFS Integration Tool install on the same machine with TFS 2013, right? So, in the detailed error log, TFS Integration Tool cannot connect to which SQL Server? Cannot connect to this SQL Server 2012 or cannot connect to TFS 2010’s SQL Server which on server1?    

You’re running TFS Integration Tool using WORKGROUP\SALEEM-WINVM-01 account?   

Which account you used to install the TFS Integration Tool on that TFS 2013 Server machine? Try to reinstall TFS Integration Tool using this WORKGROUP\SALEEM-WINVM-01 account, ensure it can be installed successfully.

If TFS Integration Tool cannot connect to TFS 2010’s SQL Server, on your TFS 2013 machine, try connect to TFS 2010’s SQL Server using WORKGROUP\SALEEM-WINVM-01 account manually, ensure this account can connect to TFS 2010’s SQL Server successfully from TFS 2013 machine.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 4

Hi,

Thanks for your response. I was running the integration tools under domain/machine account. I have uninstalled and reinstalled using proper credentials which is same on both the machines and that worked. Thanks.