Upgrade 2000 -> 2005 Timeout period elapsed...

So I was given a SQL 2000 server with a SQL 2000 DBMS installed and some wackjob installed the SQL2005 Management Studio/tools/components on it.

So lots of things were broken when trying to upgrade. The SKUUPGRADE=1 didn't help either.

So I removed all of the SQL2005 stuff I could from the server and Tried to Install SQL 2005 again.

So I get the point where it says Hey there is v8.0 already here, you can upgrade, select the default instance, Use either Integrated or SQL Authentication and hit next.

I always get the error
UpgradeAdvisor returned -1
Error Message: Timeout Expired. The timeout period has elapsed prior to the completion of the operation or the server is not responding. .Net SqlClient Data Provider

I can load up Query Analyzer and connect, I can Connect to the SQL 2000 DBMS from another SQL2005 Server.


What Gives?

Scott<-

.

Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Side by Side upgrade to CM2007
    ... As with any upgrade it is best to perform the upgrade within a lab thereby allow you to work through all the issues before you upgrade production. ... Created new Windows 2008 server, installed another instance of SQL on new ... > locally install SQL for SMS/CM ...
    (microsoft.public.sms.setup)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)