locked
TFS cannot connect to BD and IIS is not working RRS feed

  • Question

  • Hi,

    The dba changes the Database and we need to connect to the new database instase "WSS_content", but I try to use the contect manage SharePoint Central Administration but my IIS is not runing and I'n not found why.

    When I try to use the tolls sned me this error:

    when I try to review why the IIS is not working I founn:

    When I try to start IIS on the services tool I found this issue, acces denied

    I review the log and I found:

    Windows SharePoint Services       Timer                             5utr    Medium      Queued timer job SPSiteWssSequence Upgrade Job, id {378C307E-0572-46C6-B3E0-CCEC0713EFA4}    
    04/08/2013 19:00:29.19     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       General                           0    Medium      Windows SharePoint Services log file                                                                                                                                                                                                                                                                                                                                                                       
    04/08/2013 19:00:29.19     OWSTIMER.EXE (0x0D34)                       0x0D68                                      435                               94vw    Medium      Primary Domain = MXaaasddd, Computer Name = TFS    
    04/08/2013 19:00:43.87     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880i    High        System.Data.SqlClient.SqlException: Cannot open database "WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec" requested by the login. The login failed.  Login failed for user 'MXaaasddd\WSS_service'.     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean i...    
    04/08/2013 19:00:43.87*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880i    High        ...gnoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions o...    
    04/08/2013 19:00:43.87*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880i    High        ...ptions, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.SqlClient.SqlConnection.Op...    
    04/08/2013 19:00:43.87*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880i    High        ...en()     at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()    
    04/08/2013 19:00:43.87     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880j    High        SqlError: 'Cannot open database "WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec" requested by the login. The login failed.'    Source: '.Net SqlClient Data Provider' Number: 4060 State: 1 Class: 11 Procedure: '' LineNumber: 65536 Server: 'MXaaasddd\SQLINSTANCE2'    
    04/08/2013 19:00:43.87     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880j    High        SqlError: 'Login failed for user 'CROSSHORIZONSMX\WSS_service'.'    Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 65536 Server: 'MXaaasddd\SQLINSTANCE2'    
    04/08/2013 19:00:43.88     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          6y63    Critical    SQL Database 'WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec' on SQL Server instance 'MXaaasddd\SQLINSTANCE2' not found. Additional error information from SQL Server is included below.  Cannot open database "WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec" requested by the login. The login failed.  Login failed for user 'CROSSHORIZONSMX\WSS_service'.    
    04/08/2013 19:00:43.91     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880k    High           at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)     at Microsoft.SharePoint.Administration.SPContentDatabase.GetWorkItems(SPWorkItemCollection workItems, UInt32& dwColCount, UInt32& dwRowCount, Object& varWorkItems)     at Microsoft.SharePoint.SPWorkItemCollection.FetchData()     at Microsoft.SharePoint.SPWorkItemCollection.get_Count()     at Microsoft.SharePoint.Administration.SPWorkItemJobDefinition.HandleOneContentDatabase(SPContentDatabase db)     at Microsoft.SharePoint.Administration.SPWorkItemJobDefinition.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)      
    04/08/2013 19:00:43.91     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          880l    High        ConnectionString: 'Data Source=MXaaasddd\SQLINSTANCE2;Initial Catalog=WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec;Integrated Security=True;Enlist=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15    
    04/08/2013 19:00:43.91     OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          888t    High        System.Data.SqlClient.SqlException: Cannot open database "WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec" requested by the login. The login failed.  Login failed for user 'CROSSHORIZONSMX\WSS_service'.     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean i...    
    04/08/2013 19:00:43.91*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          888t    High        ...gnoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions o...    
    04/08/2013 19:00:43.91*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          888t    High        ...ptions, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)     at System.Data.SqlClient.SqlConnection.Op...    
    04/08/2013 19:00:43.91*    OWSTIMER.EXE (0x0D34)                       0x0D68    Windows SharePoint Services       Database                          888t    High        ...en()     at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)     at Microsoft.SharePoint.Administration.SPContentDatabase.GetWorkItems(SPWorkItemCollection workItems, UInt32& dwColCount, UInt32& dwRowCount, Object& varWorkItems)    
    04/08/2013 19:00:49.92     OWSTIMER.EXE (0x0D34)                       0x0D64    Windows SharePoint Services       Topology                          8xqz    Medium      Updating SPPersistedObject SPUpgradeJobDefinition Name=job-upgrade Parent=SPTimerService Name=SPTimerV3. Version: 76093 Ensure: 0, HashCode: 35320229, Id: 378c307e-0572-46c6-b3e0-ccec0713efa4, Stack:    at Microsoft.SharePoint.Administration.SPPersistedObject.Update()     at Microsoft.SharePoint.Administration.SPJobDefinition.Update()     at Microsoft.SharePoint.Administration.SPUpgradeJobDefinition.Update()     at Microsoft.SharePoint.Administration.SPUpgradeJobDefinition.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)      
    04/08/2013 19:00:50.10     OWSTIMER.EXE (0x0D34)                       0x0D64    Windows SharePoint Services       Topology                          8xqz    Medium      Updating SPPersistedObject SPAdministrationWebApplication Parent=SPWebService Name=WSS_Administration. Version: 76095 Ensure: 0, HashCode: 17653682, Id: 4d3a6a8c-af06-4b2e-ba4a-005bdf2d6f09, Stack:    at Microsoft.SharePoint.Administration.SPPersistedObject.Update()     at Microsoft.SharePoint.Administration.SPWebApplication.Update()     at Microsoft.SharePoint.Administration.SPUpgradeJobDefinition.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)      
    04/08/2013 19:00:50.42     OWSTIMER.EXE (0x0D34)                       0x0D64    Windows SharePoint Services       Timer                             7psa    Critical    The Execute method of job definition Microsoft.SharePoint.Administration.SPUpgradeJobDefinition (ID 378c307e-0572-46c6-b3e0-ccec0713efa4) threw an exception. More information is included below.  A gradual upgrade timer job is being stopped, because an build-to-build in-place upgrade is detected. Running the gradual upgrade timer job will interfere with the in-place upgrade. Please try again later when the in-place upgrade is finished    
    04/08/2013 19:00:50.42     OWSTIMER.EXE (0x0D34)                       0x0D64    Windows SharePoint Services       Timer                             72ae    Unexpected    Exception stack trace:    at Microsoft.SharePoint.Administration.SPUpgradeJobDefinition.CheckForInconsistentUpgradeRegKeys()     at Microsoft.SharePoint.Administration.SPUpgradeJobDefinition.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)    
    04/08/2013 19:05:16.12     OWSTIMER.EXE (0x0D34)                       0x0D64    Windows SharePoint Services       Database                          6f8e    Critical    SQL Database 'WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec' on SQL Server instance 'URSA\SQLINSTANCE2' not found. Additional error information from SQL Server is included below.  Cannot open database "WSS_Content_cc3d31f422cf4fd5b95d0ee9ab75d2ec" requested by the login. The login failed.    
    04/08/2013 19:05:29.22     OWSTIMER.EXE (0x0D34)                       0x0DD4    Windows SharePoint Services       General                           0    Medium      Entering MRU trim routine.    
    04/08/2013 19:05:29.22     OWSTIMER.EXE (0x0D34)                       0x0DD4    Windows SharePoint Services       General                           0    Medium      Initial table size: 0 in 0 entries    
    04/08/2013 19:05:29.22     OWSTIMER.EXE (0x0D34)                       0x0DD4    Windows SharePoint Services       General                           0    Medium      Final table size: 0 in 0 entries    
    04/08/2013 19:05:29.22     OWSTIMER.EXE (0x0D34)                       0x0DD4    Windows SharePoint Services       General                           0    Medium      Exiting MRU trim routine.    
    04/08/2013 19:05:43.13     OWSTIMER.EXE (0x0D34)                       0x0D6

    And I don't know if is because the WSS not found the database is the cuause of this issue, I hope can help me

    • Moved by John Qiao Tuesday, April 9, 2013 10:39 AM
    Tuesday, April 9, 2013 1:16 AM

All replies

  • Are there any other changes in the environment like change of domain, change of user, change of TFS service account etc?

    MVP - Team System http://www.dotnetcurry.com/ShowArticles.aspx?CatID=60

    Tuesday, April 9, 2013 2:42 AM

  • not from our site, but The last admin maybe was change something, hoe I can review it, or how I can configure my new database with out the stsadm tool?
    Tuesday, April 9, 2013 2:50 AM
  • May be this post should be moved to SharePoint Admin forum

    MVP - Team System http://www.dotnetcurry.com/ShowArticles.aspx?CatID=60

    Tuesday, April 9, 2013 3:44 AM
  • Hi Josh,

    Thanks for your post.

    As this issue relate to SharePoint, I moved it to SharePoint forum for the better response.


    John Qiao [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, April 9, 2013 10:39 AM