General discussion

Locked

Upsizing Wizard / SQL Server Version

By mytypo ·
I am attempting to use the Upsizing Wizard to convert an Access 2003 database to SQL on my desktop. The SQL server version on my desktop is:
"Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.0 (Build 2195:Service Pack 4)"
But when I run it, I get:
"Upsizing Wizard works only with Microsoft SQL Server (Version 6.50 SP5 or higher). Please log in to a SQL Server data source." Why doesn't the wizard recognize the correct server version?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by jc2it In reply to Upsizing Wizard / SQL Ser ...

The simple answer is that Microsoft wrote all of those programs so why would you assume they should work correctly. Ok I digres, but I run into stupid MS errors like this all day long.

Some things to check:
Is the File and printer services port allowed through the SP2 firewall?
Can you log into SQL Server by other means?
Have you done all of the SQL Server updates?

One thing to note:
The Upsizing Wizard is an iffy proposition at best. You will not like the results, although they may be usable. It will be clunky, cluttered, and slow. You would be better off rebuilding the database in SQL by hand. It will make it much easier to modify in the future. You have been Warned.

This probably isn't your problem:
http://support.microsoft.com/?id=838594

Here is a HowTo:
http://support.microsoft.com/kb/330468/

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproasp/html/upsizingtosqlserver.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrconvertingaccessdatabasewithupsizingwizard.asp


Check these out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

http://support.microsoft.com/default.aspx?scid=kb;en-us;888228

http://support.microsoft.com/default.aspx?scid=kb;en-us;275118

http://support.microsoft.com/default.aspx?scid=kb;en-us;884012

Here is a Trouble Shooting Guide:
http://office.microsoft.com/en-us/assistance/HP030894261033.aspx


Hope this helps.

Collapse -

by jc2it In reply to

Hey,
Before you mess around to much try reinstalling the MS SQL 2000 Server. It probably is having a problem.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums