PS2010: How do I cancel calls to old Project Server databases from instances that do not exist anymore? RRS feed

  • Question

  • Hi,

    I inherited the administration of a Project Server 2010 server running in one WFE, one App server and one cluster of SQL 2008 SP1 Server. I receive constantly in the Event Viewer and in SQL Server errors logs of login failure of the SharePoint and Project Server admin account and App Pool account trying to access ProjectServer_Publish databases of instances that do not exist anymore. There is not any search service access issue, because I removed them all.

    Probably the former administrator deleted the instance instead uninstalling them. The database of the former instances are off-line in the SQL Server.

    Is there a way to stop or cancel these phantom instances of Project Server app services?

    Thank you.

    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    Monday, October 21, 2013 6:51 PM

All replies

  • Hello Segwa,

    Did your engineer delete the project databases by any chance. If that is the case, web calls might still be looking for the databases.

    So, these entries must be removed. I would recommend running "SharePoint Configuration wizard". But, have a proper backup before running the wizard.

    If that does not help, I would recommend opening a ticket with Microsoft.

    Vikram Daruru - MSFT

    Thursday, November 7, 2013 9:11 AM
  • Hi Vikram,

    Thank you for your reply.

    On the contrary. the database still exists and it is offline.

    For instance someone deleted the instance of the "http://server:8080/pwa" and kept its database is ProjectWebAccess_8080. This instance does not exist anymore, but the service of this instance is still calling this database.

    On the same server I have other instances working normally such as "http://server/pwa" and "http://infra/pwa" (this with host header).

    So what I am looking for is how can I kill this service calls from the deceased instance to the old PWA database?

    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    • Edited by R.Segawa Friday, November 8, 2013 1:10 AM Clarity
    Friday, November 8, 2013 1:08 AM