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

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

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: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)