The upgrade process using Microsoft "SQL Sever Upgrade Wizard" fails at the "Import and Export via Named Pipe" part.
With the following Error:
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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!