Sign in
Microsoft.com
 
System Center Configuration Manager TechCenter
 
 
 
System Center Configuration Manager TechCenter > System Center Configuration Manager Forums > Configuration Manager Backup and Recovery > SCCM's SQL Database restore fails with "Could not connect or execute SQL query" error.
Ask a questionAsk a question
Search Forums:
 

General DiscussionSCCM's SQL Database restore fails with "Could not connect or execute SQL query" error.

  • Thursday, October 01, 2009 4:07 PMKenzono Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Greetings,

    I have SQL Server 2008 working in conjunction with SCCM. Recently, I have had to redo my DC and since then I have not been able to access the SQL Management Studio. Everything else is just fine and has been resolved, SCCM along with DNS, DHCP, IIS, etc. It comes up with an error of access denied no matter what I did or what username I typed in whether it was with SQl Authentication or Windows Authentication, "sa" account or AD account. I know we had an account specificly created for SCCM with all permissions and full control. That same account was added to the SQL DB and made part of sysadmin group. Even though I was not able to access the Management Studio, SQL services were starting by using the custom made account and SCCM was working fine with no errors or warning for SQL.

    Since we need to access Management Studio and just the fact that access is denied, scares me. I therefore ended up reloading just the SQL Server and leaving SCCM alone how it was originally. The DB was named the same as it was before. After reloading it, I wanted to restore it through SCCM, since that is how it was backed up in the first place. I choose to run the ConfigMgr setup -> Perform site maintenance or reset the Site -> Modify SQL Server Configuration -> Type in the SQL instance and the server where it resides SERVER\SQLDB and ConfigMgr Site Db, which is SMS_XXX. After this step, I get an error saying:

    "Could not connect or execute SQL query. If the Site's database has been restored, verify if this machine account and the user account have local administrator privileges on the selected SQL Server"

    I made sure that the account  that is trying to access the current database is in the database sysadmin group and part of the Domain admin group, who are also local admin on the server. Now, I am not sure if this error is coming from the old database that I am trying to recover and the since the SID is different in the DB from the SID in the AD, it does not allow access or is is trying to access the new database? Is there any other ways that I can restore my old SCCM database? As it is now, I cannot use SCCM since it is not connecting to its original DB? What can I do to get it working and get the DB in place for SCCM? Would I have to reload the SCCM completely?

    Thanks in advance,

    Kenzo
     

All Replies

  • Friday, October 02, 2009 7:30 AMTorsten [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I think you should solve the "access denied" issue (SQL) first before doing anything else. That sounds not ConfigMgr related to me so it might be better to post that question to a SQL forum.