none
Getting error message "Cannot connect to Configuration Database" when trying to open the SP 2010 Central Administration website

    Question

  • Hi,

    I am getting "Cannot connect to Configuration Database' message when I try to access SP 2010 administrator website. I started SP configuration wizard and it is also giving me the following error message 'Cannot open the configuration database due to login failed. The login is failing

    The SP 2010 Administrator web site was working when I installed SP 2010 for the first time. After that I was installing SQL Server 2008 R2 to setup Reporting Services. I am not sure what got changed. After that I haven;t been able to access the site.

    Please guide as what should I do so as to resolve the issue.

    Vidya

    Sunday, November 14, 2010 7:53 AM

Answers

  • do you remember you configuration database name and location (server/instance) ?

    if yes, use sql profiler trace to make sure Central admin tries to connect to the same db;make sure the login of the user running the config wizzard is in the local administrator group and is authorized in your sql server instance.

    otherwise, reinstall the farm.

     


    Serge Luca; MVP blog: http://sergeluca.spaces.live.com Devoteam Belgium. http://twitter.com/sergeluca
    Sunday, November 14, 2010 8:33 AM
  • Have you changed the password of you Farm Account? That is, the account used as Central Administration Web Application Pool identity and the service account of SPTimer.

    Also, for audit failed login, besides sql server user profiler(http://msdn.microsoft.com/en-us/library/ms191148.aspx) please also take a look at http://www.mssqltips.com/tip.asp?tip=1735

    Thursday, November 25, 2010 10:53 AM
    Moderator

All replies

  • do you remember you configuration database name and location (server/instance) ?

    if yes, use sql profiler trace to make sure Central admin tries to connect to the same db;make sure the login of the user running the config wizzard is in the local administrator group and is authorized in your sql server instance.

    otherwise, reinstall the farm.

     


    Serge Luca; MVP blog: http://sergeluca.spaces.live.com Devoteam Belgium. http://twitter.com/sergeluca
    Sunday, November 14, 2010 8:33 AM
  • Have you changed the password of you Farm Account? That is, the account used as Central Administration Web Application Pool identity and the service account of SPTimer.

    Also, for audit failed login, besides sql server user profiler(http://msdn.microsoft.com/en-us/library/ms191148.aspx) please also take a look at http://www.mssqltips.com/tip.asp?tip=1735

    Thursday, November 25, 2010 10:53 AM
    Moderator