tag:blogger.com,1999:blog-7656888.post6672200604755606423..comments2023-10-11T04:24:22.301-06:00Comments on Aggregated Intelligence: Unable to rename machine running TFS 2008 (single server deployment).Raj Raohttp://www.blogger.com/profile/02773005045522319448noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7656888.post-31229880490170452602009-04-20T01:52:00.000-06:002009-04-20T01:52:00.000-06:00The call stack of running RenameDT indicates that ...The call stack of running RenameDT indicates that the issue happens when invoking the reporting service web services to change the data source connection strings. It reminds me a similar case at http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/543f9fc2-590f-4667-843b-d2dc14ec9d27. <br /><br />As Robert suggested, I would run TfsAdminUtil ConfigureConnections to verify the reporting service url.<br /><br />Before you run TfsAdminUtil ConfigureConnections, please update the connection string in the web.config to point to the NEW data tier name. <br /><br />Before you run TfsAdminUtil RenameDT, please update the connection string in the web.config to point to the OLD data tier name.Bill Wanghttps://www.blogger.com/profile/03863120660319844632noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-84369235450487872242009-04-17T13:37:00.000-06:002009-04-17T13:37:00.000-06:00Ah - I think that the step you skipped:
Skip - (I...Ah - I think that the step you skipped:<br /><br />Skip - (Install Team Foundation Server on the New Hardware)<br /><br />Would have updated the web.config file as I am suggesting.<br /><br />Let me know how it goes.<br /><br />You can contact me at robert.horvick AT microsoft.com if you find yourself blocked. Depending on the severity of the issue I may need to redirect you to customer support but I can certainly try and help you out.Roberthttps://www.blogger.com/profile/03666605936051296166noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-90394912750405557762009-04-16T21:10:00.000-06:002009-04-16T21:10:00.000-06:00Robert - I will try that tomorrow morning.
Just s...Robert - I will try that tomorrow morning.<br /><br />Just so that you know, when I first started I was following the instructions in http://msdn.microsoft.com/en-us/library/ms253106.aspx<br /><br />What I have is a single tier TFS 2008 server (AT&DT). Now that I am ready to move it to production all I want to do is rename the server to the standards we use for our production machine.<br /><br />Based on that scenario, I am following only the these steps from the document you referenced.<br /><br />1. Prepare For a Restoration-Based Move<br />2. Skip - (Install Team Foundation Server on the New Hardware)<br />3. Skip - (Back up the WSS_Config Database on the New Server)<br />4. Skip - (Restore the Databases)<br />5. Restore Web Sites for Team Projects<br />6. Restore and Test SQL Report Server, Reporting Services, and Default Reports<br />7. Rename the Data-Tier Server and Activate the Application-Tier Server<br /><br />(This where I ran in to problems last time).<br /><br />Thanks again for your help.Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-48379103389868464472009-04-16T19:59:00.000-06:002009-04-16T19:59:00.000-06:00Further on in the documented I referenced earlier ...Further on in the documented I referenced earlier it explains how to update the DB connection string in the web.config file. Doing that might help with the configureconnections command.<br /><br />Robert.Roberthttps://www.blogger.com/profile/03666605936051296166noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-40120035513172936722009-04-16T17:48:00.000-06:002009-04-16T17:48:00.000-06:00running ConfigureConnections /view fails with the ...running ConfigureConnections /view fails with the following error message<br /><br />TfsAdminUtil - Team Foundation Admin Utility<br />Copyright (c) Microsoft Corporation. All rights reserved.<br /><br />ERROR: Microsoft.TeamFoundation.Server.TfsAdminException: TF55020: Could not access database. ---> Microsoft.TeamFoundation.Server.D<br />atabaseConnectionException: TF30041: Team Foundation Server could not connect to the database. Contact your Team Foundation Server<br />administrator. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a c<br />onnection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Serve<br />r is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)<br /><br /> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br /> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<br /> at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTime<br />out, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpe<br />nTimeout, Int64 timerExpire, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance<br />, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptio<br />ns, String newPassword, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions,<br /> Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConne<br />ctionPool pool, DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbCo<br />nnectionOptions options)<br /> at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory<br />)<br /> at System.Data.SqlClient.SqlConnection.Open()<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)<br /> --- End of inner exception stack trace ---<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.MapException(SqlException ex)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.HandleException(SqlException ex)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.ExecuteReader()<br /> at Microsoft.TeamFoundation.Server.BisResourceComponent.GetServiceInterface(String entryType, String interfaceName)<br /> --- End of inner exception stack trace ---<br /> at Microsoft.TeamFoundation.Server.BisResourceComponent.GetServiceInterface(String entryType, String interfaceName)<br /> at Microsoft.TeamFoundation.Server.TfsAdmin.GetCurrentConnections(TfsAdminContext context)<br /> at Microsoft.TeamFoundation.Server.TfsAdmin.ShowCurrentConnections(TfsAdminContext context)<br /> at Microsoft.TeamFoundation.Server.TfsAdminUtil.RunConfigureConnectionsUtil(List`1 parameters, List`1 commandSwitches, String[] r<br />awArgs)<br /> at Microsoft.TeamFoundation.Server.TfsAdminUtil.Run(String[] args)<br />> Inner Exception:<br />Microsoft.TeamFoundation.Server.DatabaseConnectionException: TF30041: Team Foundation Server could not connect to the database. Con<br />tact your Team Foundation Server administrator. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific erro<br />r occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance n<br />ame is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not<br /> open a connection to SQL Server)<br /> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br /> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<br /> at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTime<br />out, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpe<br />nTimeout, Int64 timerExpire, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance<br />, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptio<br />ns, String newPassword, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions,<br /> Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConne<br />ctionPool pool, DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbCo<br />nnectionOptions options)<br /> at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory<br />)<br /> at System.Data.SqlClient.SqlConnection.Open()<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)<br /> --- End of inner exception stack trace ---<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.MapException(SqlException ex)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.HandleException(SqlException ex)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.ExecuteReader()<br /> at Microsoft.TeamFoundation.Server.BisResourceComponent.GetServiceInterface(String entryType, String interfaceName)<br />>> Inner Exception:<br />SQL Error #1<br />SQL Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not<br /> found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections<br />. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)<br />SQL LineNumber: 0<br />SQL Source: .Net SqlClient Data Provider<br />SQL Procedure:<br /><br />System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Ser<br />ver. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to a<br />llow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)<br /> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br /> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<br /> at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTime<br />out, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpe<br />nTimeout, Int64 timerExpire, SqlConnection owningObject)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance<br />, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)<br /> at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptio<br />ns, String newPassword, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions,<br /> Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br /> at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConne<br />ctionPool pool, DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbCo<br />nnectionOptions options)<br /> at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br /> at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br /> at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory<br />)<br /> at System.Data.SqlClient.SqlConnection.Open()<br /> at Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)<br />Exception Data:<br />Key: HelpLink.ProdName, Value: Microsoft SQL Server<br />Key: HelpLink.EvtSrc, Value: MSSQLServer<br />Key: HelpLink.EvtID, Value: 53<br />Key: HelpLink.BaseHelpUrl, Value: http://go.microsoft.com/fwlink<br />Key: HelpLink.LinkId, Value: 20476Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-87775172364281999532009-04-16T14:37:00.000-06:002009-04-16T14:37:00.000-06:00If you are following this document:
http://msdn.m...If you are following this document:<br /><br />http://msdn.microsoft.com/en-us/library/ms404869.aspx<br /><br />It sounds like you may have missed the step where you repoint your RS server Uris using "tfsadminutil configureconnections"<br /><br />(see section: http://msdn.microsoft.com/en-us/library/ms404869.aspx#Rename )<br /><br />If you aren't following those instructions I would encourage you to do so.<br /><br />Regards,<br /><br />Robert HorvickRoberthttps://www.blogger.com/profile/03666605936051296166noreply@blogger.com