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 LieHi
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.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
>|||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.
>