none
PWA Site Provisioning Issue RRS feed

  • Question

  • Hi

    I have restored all the databases from QA server and deployed in Dev Server and to the current web app i have removed all the existing db connections and attached the restored ones.

    When i am provisoining the PWA site it if failing below is the log

    04/10/2014 00:47:02.82  OWSTIMER.EXE (0x13D0)                    0x28D8 Project Server                 Provisioning                   eas7 Exception  System.Data.SqlClient.SqlException: Cannot open database "ProjectServer_Published_Test" requested by the login. The login failed.  Login failed for user xxxxx\xxxxxx.     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 ignoreSniOpenTimeou... fc901a20-a24f-41f6-ae49-48509bc47157
    04/10/2014 00:47:02.82* OWSTIMER.EXE (0x13D0)                    0x28D8 Project Server                 Provisioning                   eas7 Exception ...t, 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 options, Object poo... fc901a20-a24f-41f6-ae49-48509bc47157
    04/10/2014 00:47:02.82* OWSTIMER.EXE (0x13D0)                    0x28D8 Project Server                 Provisioning                   eas7 Exception ...lGroupProviderInfo, 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.Open()     at Micros... fc901a20-a24f-41f6-ae49-48509bc47157
    04/10/2014 00:47:02.82* OWSTIMER.EXE (0x13D0)                    0x28D8 Project Server                 Provisioning                   eas7 Exception ...oft.Office.Project.Server.Data.SqlSession.OpenConnection()     at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)     at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)     at Microsoft.Office.Project.Server.Administration.ProjectSite.GetInstalledLanguages()     at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.AdminSynchronize() Source: .Net SqlClient Data Provider Server: xxxxxxx LineNumber: 65536 fc901a20-a24f-41f6-ae49-48509bc47157

    Can any body throw some light on the issue and provide the solution for the same.

    Thanks


    Geeth If you feel that the answer which i gave you is Helpful please select it as Answer/helpful.

    Thursday, April 10, 2014 5:54 AM

All replies

  • Hi,

    Check if the user account which is used for provisioning PWA has permission on the databases in SQL server.

    Thursday, April 10, 2014 12:46 PM
  • It is somewhat of a quirk, I have noticed in the past as well. Try giving the service account you are using in Dev Server, permissions to the databases in QA Server, BEFORE you do the back-up. 

    Prasanna Adavi,PMP,MCTS,MCITP,MCT http://thinkepm.blogspot.com

    Thursday, April 10, 2014 12:58 PM
    Moderator