Upgrade from MS SQL Server 6.5 to SQL 2000 Fails

Tags:
Administration
Backup & recovery
Implementation
Installation/Upgrade
Migration
SQL Server
Standard Edition 2000
Tech support
Version 7 and earlier
The upgrade process using Microsoft "SQL Sever Upgrade Wizard" fails at the "Import and Export via Named Pipe" part. With the following Error: Starting MSSQLServer............................... Waiting for recovery. Sysmessages # 4002 [Microsoft][ODBC SQL Server Dirver][SQL Server] Login failed I am using a Network connection between a Windows 2000 Server PC running SQL Server 2000 and a Windows NT PC running SQL Server v6.5. There is an Error logged on the v6.5 PC indicating that the sa login failed! EventID 17055 Mesg 1845 from MSSQLServer. However, to get through all the earlier steps (e.g. copying across the Tables Design), it must have been able to login to the v6.5 PC via sa???? Note my 2 PCs are in different Domains, but with Trusts between them and I am logging onto both as Administrator and have set Security Permissions, for anything I think might be relevant on the v6.5 PC for the v2000 PCs Domain Administrator (and Domain Admins). MS Article 302850 does not help. Can anyone help with any ideas or suggestions? - This is holding me up!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Does each of the servers have the other set up within the Client Configuration utility? If not, create a namped pipes alias for server1 on server2, and vice versa. This may not be the cause of your problem, but I’ve seen similar issues and this is a good starting point.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Howard2nd
    Previous answer should help - SQL2k does NOT enable 'Named Pipes' by default, instead TCP/IP is the preferred transport. In the deprecation of NetBUI / NetBIOS (i.e. WINS, local 'Computer Browser') moving away from 'Names' is a good thing. But requires and understanding of DNS and active directory. All my ODBC setups use IP addresses versus 'names' to avoid the lookup delay.
    30 pointsBadges:
    report
  • Pedwards17
    This is true, but SQL2K still wants to talk to itself over named pipes. This comes into play when you're doing an upgrade (as is the case here) or installing a SQL service pack. Disabling named pipes in these situations will likely cause problems. It may make sense to enable named pipes for the duration of the maintenance, and then disable it after.
    0 pointsBadges:
    report
  • HenryKafeman
    Thanks for your suggestions. None helped, BUT I have now found MS KB Article 818550 which says this is a bug! Note I get "Export Exit Code: 259" Error on SQL 2000 PC a few seconds before the sa Login failure on the SQL v6.5 PC! Also note, that when I did a Web search for "Export Exit Code: 259" I only found the Japanese version of KB Article 818550! Anyway, I think I have found my own workaround! Having got to the ppoint of failure, I tried the standard DTS Import and Export Data on the SQL 2000 PC. This works fine with default settings and selecting All Tables - I now have my Data in SQL 2000! Thanks
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following