Problem with different version of SQL Server

30 May 2005 5:37 AM

Robert Lie

Dear All,

I have a server that is running SQL Server 6.5 and SQl Server 7.0.
Then I install an instance of SQL Server 2000 and run the SQL Server
Upgrade wizard. But the database selection screen, some of the SQL
Server 6.5 databases are not listed, so I canceled the SQL Server
upgrade wizard.

I need to make SQL Server 6.5 databases are listed in the wizard. So
What should I do?

Thanks

Robert Lie

30 May 2005 8:58 AM

Mike Epprecht (SQL MVP)

Hi

Does the user that is logged in have permissions to the databases?
What databases are missing? The upgrade wizard will not upgrade System
databases.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quoteHide quote

"Robert Lie" wrote:

> Dear All,
>
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
>
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
>
> Thanks
>
> Robert Lie
>
>

30 May 2005 11:54 AM

Wayne Snyder

I agree with Mike, it is probably a permsission problem... You will only see
the databases you have permissions for... Log in as a system admin and try
again.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

Show quoteHide quote

"Robert Lie" <robert.li***@gmail.com> wrote in message
news:1117431463.159386.73310@g49g2000cwa.googlegroups.com...
> Dear All,
>
> I have a server that is running SQL Server 6.5 and SQl Server 7.0.
> Then I install an instance of SQL Server 2000 and run the SQL Server
> Upgrade wizard. But the database selection screen, some of the SQL
> Server 6.5 databases are not listed, so I canceled the SQL Server
> upgrade wizard.
>
> I need to make SQL Server 6.5 databases are listed in the wizard. So
> What should I do?
>
> Thanks
>
> Robert Lie
>

30 May 2005 1:59 PM

robert lie

No, I have a full access since i'm the administrator.
Should I run MS Server-Switch application then rerun the SQL Server
upgrade wizard?

Pls some advice.

Thanks

Wayne Snyder wrote:
Show quoteHide quote

> I agree with Mike, it is probably a permsission problem... You will only see
> the databases you have permissions for... Log in as a system admin and try
> again.
>