Re: Move or Setup of SQL Database toa Remote Server Fails

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


David,

Congrats on figuring this one out, and thanks for reporting back.


--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx


David Baur wrote:
Resolved: This only occurs in the Prerequisite Checker, in actual setup it is 100% Successful. (Reported to MS as Bug).

Cheers!
David Baur


"David Baur" <dbaur@xxxxxxxxxxx> wrote in message news:ORYA38SBIHA.4200@xxxxxxxxxxxxxxxxxxxxxxx
Anybody else tried this?


"David Baur" <dbaur@xxxxxxxxxxx> wrote in message news:O$hlrMKAIHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
Yes, both the SCCM Server name and the User Installing are members of the Local Administrators Group, as well as have SysAdmin privileges on the DB. Another person was having this issue, so I jsut did it to see if it was a valid problem, and it repro'd. No Idea what is causing it to fail or why. We cannot be the first to have seen the problem though.

Thanks
David Baur

"Kim Oppalfens [MVP]" <""Kim dot Oppalfens\"@google mail.com"> wrote in message news:uwreAPHAIHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
David Baur wrote:
When attempting to move the SCCM DB to another server, or when installing from scratch I get the following Errors in Setup.

In SCCM Setup I am Entering ServerName\Instance (Instance is already created on remote Server)

The ConfigMgrSetup.log shows the following:
IsValidNetBIOSName validation of '501ST' succeeded
Registered type 501ST MASTER for 501ST SCCM1DB\master
Registered type SMS Master for 501ST SCCM1DB\master
Registered type 501ST SCCM1DB\SMS_SCM for 501ST SCCM1DB\SMS_SCM
Registered type SMS ACCESS for 501ST SCCM1DB\SMS_SCM
Could not connect SQL Server 'master' db.
Could not verify SQL Server is clustered or not because the setup could not connect to the SQL Server 501ST or failed to run the query.

The SCCM Primary Site Computer Account and the User account I am using are both sysadmin on the Remote SQL Server, and have sysadmin on Master as well. Protocol is TCP/IP Only.

SETSPN has been used to register both the Netbios and FQDN SPN for use with the System Account.

Error is always: Could not connect SQL Server 'master' db.

SQL is SQL Server 2005 Sp2

Any Assistance or can this be done, states a Named Instance on a Remote Server DB is supported.

Thanks,
David Baur



Named instances are new to configmgr 2007 and should be supported.
You state that the computer account is sysadmin on the sql box, does this mean the account is in the local administrators group?

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx





.

Relevant Pages

  • Re: Does anyone know how to fix this??
    ... > Inside the Active Directory Users and Computers in the folder of SYSTEM I ... Give the site's SMS Service account full control rights to the ... MP encountered an error when connecting to SQL Server. ...
    (microsoft.public.sms.setup)
  • Http verification .sms_aut (port 80) failed
    ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: SMS Component errors after installing SP2
    ... MVP Windows Server System - SMS ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ... is used to publish fully qualified host names in Active Directory. ...
    (microsoft.public.sms.setup)
  • Re: Http verification .sms_aut (port 80) failed
    ... I noticed I couldn't get SMS reports to work.... ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ... SMS_SITE_COMPONENT_MANAGER service to immediately apply the new configuration. ...
    (microsoft.public.sms.admin)
  • RE: Management Point not available
    ... > configured the Default Web Site within IIS 6 to use port 8080. ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)