MS SQL Server - Problem with different version of SQL Server

Author

Problem with different version of SQL Server

Robert Lie

2005-05-30, 3:23 am

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

Mike Epprecht (SQL MVP)

2005-05-30, 7:23 am

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

Wayne Snyder

2005-05-30, 7:23 am

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
>

robert lie

2005-05-30, 9:23 am

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

Sponsored Links