none
SQL Database 'SharePoint_ConfigurationDatabase' on SQL Server instance 'HPWSERVER\SHARPOINT' not found RRS feed

  • Question

  • I just setup a brand new SBS 2011 server and I keep getting the following CRITICAL error on Application Log:

    SQL Database 'SharePoint_ConfigurationDatabase' on SQL Server instance 'HPWSERVER\SHARPOINT' not found. Additional error information from SQL Server is included below.

    Cannot open database "SharePoint_CofigurationDatabase" requested by the login. The login failed.

    login failed for user 'HPW\spfarm'


    Saturday, January 19, 2013 10:32 AM

Answers

  • since you are using non-default instance for SQL Server, please start the SQL Server browser service on with SQL Server configuration manager;

    for setup account (the account you use to run installation and sharepoint product wizard), and farm account(the account you input into the sharepoint product wizard), i cannot say its incorrect if you use domain administrator account for both of them, its just not best practice. for best practice: http://technet.microsoft.com/en-us/library/ee662513.aspx

    • Marked as answer by Sam 2403 Wednesday, January 23, 2013 12:13 PM
    Wednesday, January 23, 2013 8:58 AM

All replies

  • Hi,

    1- make sure this user HPW\spfarm has Dbcreator and securityadmin roles in SQL Server

    2- make sure you can connect to SQL Server (check ping , firewall , enable TCP/IP )



    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 11:26 AM
  • I thank you for your reply. I checked in my SQL security, Logins and I have only two users: BUILTIN\Users & sa (which is down)  no spfarm !
    Saturday, January 19, 2013 11:41 AM
  • Hi,

    Create new login and add this account  HPW\spfarm with the following roles Dbcreator , public and securityadmin roles


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 11:44 AM
  • Do I create with Windows authentication OR SQL server authentication?

    What will be my Default database? my choices are:  Conf_HPWSEVER, Log_HPWSERVE, master, model, msdb, Report_HPWSERVER and tempdb

    Saturday, January 19, 2013 12:08 PM
  • try to Create Windows authentication user and leave other settings as default.

    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 12:59 PM
  • Saturday, January 19, 2013 1:32 PM
  • I Search in login name and it appears that the user HPW\spfarm already exists as you see above.

    and then when i tried to add the roles I get the exception error as above.

    Saturday, January 19, 2013 1:34 PM
  • Hi,

    1- last error because you don't have the admin privileges (like SA user or sysadmin user).

    2- Go to User Mapping and Check the box of SharePoint_ConfigurationDatabase database [Ignore securityadmin role if you don't have permission]

    then Check if the login error still exists


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/



    Saturday, January 19, 2013 3:37 PM
  • Saturday, January 19, 2013 4:16 PM
  • Saturday, January 19, 2013 4:17 PM
  • it gives me the warning about the blank password first then it gives me the exception error
    Saturday, January 19, 2013 4:18 PM
  • 1-Have you selected Windows Authentication User ?

    2- make sure to perform the above steps with SQL admin user


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 4:23 PM
  • Hi,

    I will summarize the steps again.

    1- Login to SQL Management Studio with Admin User (sa user or user with sysadmin role)

    2-go to Logins >> Right Click >> New Login...

    3-add your user name HPW\spfarm




    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/


    Saturday, January 19, 2013 4:41 PM
  • Yes I selected Windows Authentication. It seems sa account is down since it has a Red down arrow on it.

    I open the sa account and I tried to map the confi_HPWSERVER, first there was a warning that some database does not exist and then it gives me exception error.

    Saturday, January 19, 2013 4:42 PM
  •  4- go to Server roles

    5- go to user mapping

    Last click ok.


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 4:42 PM
  • Saturday, January 19, 2013 4:42 PM
  • Saturday, January 19, 2013 4:43 PM
  • I followed your steps; however; I do not have SHAREPOINT_config in my list:
    Saturday, January 19, 2013 4:48 PM
  • Hi,

    You opened the wrong instance name , you need to connect to HPWSERVER\SHARPOINT instead of HPWSERVER\SCANMAIL


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/



    Saturday, January 19, 2013 4:48 PM
  • Which instance name should I need to open? where?
    Saturday, January 19, 2013 4:50 PM
  • Apparently I do not have SHAREPOINT database instance; How do I create one? 
    Saturday, January 19, 2013 5:02 PM
  • Hi,

    please go to Connect button 

    and insert in server name : HPWSERVER\SHARPOINT  [ If failed to connect to this instance then you don't have permission or you don't have access from this network ]


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 5:11 PM
  • Great; I successfully connected to SHAREPOINT instance as you see below; and tried to create a login for HPW\spfarm and added the 3 roles but I DO NOT SEE SHAREPOINT_config  please see below:
    Saturday, January 19, 2013 5:23 PM
  • Hi,

    I think this database "SharePoint_ConfigurationDatabase" is deleted :).


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 5:29 PM
  • How can I create it?
    Saturday, January 19, 2013 5:46 PM
  • This is a brand new server I set it up four days ago.
    Saturday, January 19, 2013 5:47 PM
  • Hi,

    This is the most important database in SharePoint farm so to re-create it again you need to create new SharePoint farm from scratch again [By run configuration Wizard].


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 5:53 PM
  • OK. There was nothing in the database since it is a new one. Will you walk me through it?
    Saturday, January 19, 2013 6:20 PM
  • Hi,

    Go to SharePoint Configuration Wizard and run it 

    If ask you to disconnect from this farm click yes and let him finish and then run it again and choose create new Farm .


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 6:31 PM
  • I ran the Wizard and it failed. 
    Saturday, January 19, 2013 6:39 PM
  • Hi,

    Run the following power shell

    PSConfig -cmd configdb -disconnect


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 6:41 PM
  • Saturday, January 19, 2013 6:46 PM
  • I opened SQL and run powershell . Where do I open power Shell?

    Saturday, January 19, 2013 6:47 PM
  • Hi,

    don't run it from there , go to start >> Programs >> Microsoft SharePoint  2010 Products >> SharePoint 2010 Management Shel.


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 6:50 PM
  • Thanks, I ran it from program files: it tells me I do not have permission:
    Saturday, January 19, 2013 6:54 PM
  • Hi,

    1- make sure your user has the following permission :

    Belong to Local Admin Group

    DbCreator , public and SecurityAdmin Roles in SQL Server instance

    2- open regedit (from run command) delete the following keys ConfigDb and FarmAdmin from this path [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

    3- Run Configuration Wizard and Create new FARM


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 6:58 PM
  • Great, we are getting somewhere, I deleted the keys and ran the Wizard.

    What do I put for Database server? (HPWSERVER ?)

    There is already database name:  SharePoint_Config. Do I need to change that?

    what for username? (HPW\spfarm?) 

    Saturday, January 19, 2013 7:10 PM
  • Saturday, January 19, 2013 7:11 PM
  • Hi,

    Every thing is Ok except Database Server [Are you sure this is the name for instance name where you granted your user dbcreator , public and securityadmin roles]


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 7:16 PM
  • Not sure!  where can I find the Database Server name that has those roles?
    Saturday, January 19, 2013 7:18 PM
  • Can I reset the password for HPW\spfarm?  I never set that password. I put the same password for HPW\ExchAdmin.  do I use dsa.msc to set the password for spfarm?
    Saturday, January 19, 2013 7:19 PM
  • Hi,

    You can Reset it from Active directory , please read some articles about how to install and configure SharePoint 2010 before perform this steps

    Check this for example

    http://sharepointgeorge.com/2010/installing-sharepoint-2010-privilege-service-accounts/


    Regards,
    Fadi Abdulwahab, SharePoint Consultant
    http://blogs.msdn.com/b/fabdulwahab
    http://sqlgoogler.blogspot.com/

    Saturday, January 19, 2013 7:24 PM
  • Should Username be:   HPW\ExchAdmin   or  HPW\spfarm ?
    Saturday, January 19, 2013 7:26 PM
  • since you are using non-default instance for SQL Server, please start the SQL Server browser service on with SQL Server configuration manager;

    for setup account (the account you use to run installation and sharepoint product wizard), and farm account(the account you input into the sharepoint product wizard), i cannot say its incorrect if you use domain administrator account for both of them, its just not best practice. for best practice: http://technet.microsoft.com/en-us/library/ee662513.aspx

    • Marked as answer by Sam 2403 Wednesday, January 23, 2013 12:13 PM
    Wednesday, January 23, 2013 8:58 AM