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

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: The Microsoft Search service cannot be administered under the pres
    ... the BUILTIN\Administrator account as well as a member of the Sysadmin role? ... SQL Server Full-Text Search Does Not Populate Catalogs ... you or your server's sysadmin have removed the ... exec sp_defaultdb N'NT Authority\System', N'master' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Schedule a DTS package
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >> owned by a sysadmin then the job will fire as the Service account. ...
    (microsoft.public.sqlserver.dts)
  • Re: Security issue when running packages from SQL Agent.
    ... only sysadmin role members can execute CmdExec steps by ... You will then be prompted to specify a valid Windows account ... for the SQL Server Agent proxy. ...
    (microsoft.public.sqlserver.security)
  • Re: Move or Setup of SQL Database toa Remote Server Fails
    ... This only occurs in the Prerequisite Checker, in actual setup it ... Registered type 501ST MASTER for 501ST SCCM1DB\master ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
    (microsoft.public.sms.setup)
  • Re: remove guest user in msdb
    ... in your your opinion while is the best security choice? ... Assing the sysadmin role to an NT normal user account and use this to start the SQL_SERVER_AGENT. ... > Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)