Unable to Install SMS 2003 R2

Hi, I'm trying to add the R2 features to my existing SMS 2003 SP3
server, but running into a wall when the Custom Updates Publishing
Tool installer is asking for the SQL server information.

The database is stored on a separate machine that we use for several
applications, each with their own databases. The server is located in
the same subnet as the SMS server, and the SMS server is functioning
normally.

The installer asks for the Remote SQL Server name and Instance name.
I enter the SQL Server's NETBIOS name, and leave the Instance blank
(the SQL Server is 2000, I believe). I immediately get a message
saying "Unable to verify the database connection with the provided
information." I know I am typing the machine name correctly. I've
tried entering it as \\SERVER instead of SERVER, and while it pauses
after I click Next, I eventually get the same error. I've tried
entering the database name in the Instance blank, but that doesn't
help either. I've gone and added SPN's for the database server to fix
a problem I had a long time ago. I don't have any idea what else to
try. I'd like to get this working so I could automate Office 2007
installs.

HELP!!!

.

Relevant Pages

  • Re: Move SMS Database to new SQL Server
    ... Because you aren't just backing up the database, you're doing a full SMS ... later and move database from a remote server back to the SMS site server.) ... >>> I have SMS running right now on its own SQL server. ...
    (microsoft.public.sms.setup)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Moving SMS SQL Database
    ... We have a customer running SMS 2003 in Advanced Security with a remote SMS SQL database. ... They need us to move the database to a different server. ...
    (microsoft.public.sms.admin)
  • Re: Move SMS Database to new SQL Server
    ... You should't start the services prior to the Site Reset! ... At that point stuff can get written to the old database. ... MVP SMS ... > restart the SMS services until after the sql server restore, ...
    (microsoft.public.sms.setup)
  • Re: Moving SMS Components to new server to offload CPU usage
    ... site reset will NOT move the database for you. ... Make sure you have a recent SMS backup ... Restore the SQL database to the new SQL Server computer ... Run a site reset and specify the new database name and server. ...
    (microsoft.public.sms.admin)