Problem with different version of SQL Server

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
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/
"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
>
|||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
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:1117431463.159386.73310@.g49g2000cwa.googlegro ups.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
>
|||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:
> 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.
>