RE: TestDbUpgrade problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is the SQL Instance name the same as the old server and did you restore the
master database before restoring the SMS database?

"AdSMS" wrote:

> I all,
>
> I'm about testing my SMS database with TestDBUpgrade. I mount fresh
> W2003 server and SQL Server 2000 with SP4 and SMS_C01 database restored
> on it. All is live and i can open tables and see data in it.
> The test crash and pop a message "SQL is not installed on your computer"
>
> In the SMSSETUP log:
>
> <01-20-2006 14:19:23>
> ********************************************************
> <01-20-2006 14:19:23> ******************* Begin SMS Setup
> *******************
> <01-20-2006 14:19:23>
> ********************************************************
> <01-20-2006 14:19:23> The command line options are /TESTDBUPGRADE SMS_C01
> <01-20-2006 14:19:26> Detected version 0
> <01-20-2006 14:19:26> Phase is 0
> <01-20-2006 14:19:26> SMS Build Number = 3174
> <01-20-2006 14:19:26> SMS Version = 2.5
> <01-20-2006 14:19:26> SMS Minimum Build Number = 800
> <01-20-2006 14:19:26> Testing database upgrade on SMS_C01 database, on
> the SLQC1SQL01 server.
> <01-20-2006 14:19:26> Registering connects for SLQC1SQL01, , master
> <01-20-2006 14:19:26> Registered the types
> <01-20-2006 14:19:26> SQLTestQuery, SQL Server is down.
> <01-20-2006 14:19:26> Cannot find the SQL service name.
> <01-20-2006 14:19:26> SQL Server is not installed on computer
> SLQC1SQL01. You must enter a correct SQL Server name.
>
> But SQL is live. Some idea ?
>
> Thank-you !
>
.

Relevant Pages

  • Re: Restoring SharePoint Portal 2003 & SQL
    ... running with two WFE servers, one index and one SQL Server. ... re-assign the server roles, restore the shared services portals, then ... please use the backup and restore tool that ships with SPS03. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Migration ?
    ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBS Sharepoint (CompanyWeb) DR restore process
    ... If your site does not contain any custom web parts (which have to be installed on the new server) the move should be straight forward. ... Copy the backup file from the old server to the new. ... the process to perform a backup and restore of the sharepoint component of SBS. ... However, most of the documentation I've found refers to scenario's involving MSDE ONLY, and specifically mention the process is not identical for scenario's where full SQL is installed. ...
    (microsoft.public.windows.server.sbs)
  • SPS 2003 Restore with SQL 2005
    ... Currently we are trying out the backup and restore procedure. ... "SQL Server restore failed. ... 00000E5C Connected to SQL Server ABCSPSDC ... 000131A3 UNK ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Cannot use file for clustered server
    ... My restore appears to be running nicely right now ... > Double click SQL Server resource and add G: ... >> on which the cluster resource of the server has a dependency can be used. ...
    (microsoft.public.sqlserver.clustering)