I'm looking for suggestions, tips, problem areas to look
for when upgrading from SQL Server 6.5 to SQL Server 2000.
Mark Allison, SQL Server MVP
: You may have to upgrade to SQL Server 7 first, then to SQL Server 2000.
: > I'm looking for suggestions, tips, problem areas to look
: > for when upgrading from SQL Server 6.5 to SQL Server 2000.
: > Thanks.
Please refer to the SQL 2000 online books about the topic 'Upgrading
Databases from SQL Server 6.5' for more information.
In addition, the following are some known issues about upgrade process. I
hope they could be of some help to you.
321456.KB.EN-US PRB: SQL 6.5 Upgrade Results in Errors 4850 and 4851
302850.KB.EN-US PRB: Upgrade from SQL Server 6.5 Fails During "Import and
291587.KB.EN-US BUG: SQL Server 6.5 Upgrade to SQL Server 2000 May Fail
Related web link:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
Eric Yang [MS]
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
I get an error stating on an NT server box:
"Neither DSN nor SERVER keyword supplied. Invalid connection string
And this msg comes up next:
Please make sure this value is not NULL."
computer is identical.
The error seems to come up after providing the 'sa' passwords and
selecting the export server. The status box says "Restarting
MSSQLserver service" when the error occurs.
I have tried to reinstall 2000.
I cannot figure this out or find any information on it.
3. OAS 4.X