Upgrading Databases from SQL6.5 TO SQL2000

Last Post 09 Nov 2004 06:54 AM by Develop2000. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Develop2000
New Member
New Member

--
08 Nov 2004 11:01 AM
I have a problem of upgrading an old databases MSSQL6.5 SP5a TO SQL2000 Server Standard Edition.
When Using the Upgrade Wizard of Microsoft, I have a problem of connection with the old server SQL6.5.
I have the following error message:
"SQL Server does not exist or access denied. ConnectionOpen(Connect())."
However, I don't have any problem to connect in local to the SQL6.5.

I've following the help of microsoft "How to Upgrade SQL6.5 to SQL2000" but It doesn't work or more probably I forgot something to do on the SQL6.5 server.
Could someone help me urgently?

Thank you for your help
Develop2000
New Member
New Member

--
09 Nov 2004 01:45 AM
They're not in the same domain but in the same workgroup.
The windows account used have local admin rights on both servers.
The default netlib in client network utility on sql2k server are:
- DBNMPNTW.dll version 8.0.341 for Named Pipes
- DNNETLIB.dll version 8.0.341 for TCP/IP

For the sql2k server, the startup service account is not the system account but an account who have local admin rights on this server.

Does the same domain is necessary ?

Thank you for your reply
Develop2000
New Member
New Member

--
09 Nov 2004 06:54 AM
I try to create a new user login (as the same of sql2k) on the SQL6.5 with the rights on all databases and I put it to the NT4 admin group.
But the problem of connection still the same.
Moreover, when I use the MSQuery of the SQL6.5 to connect to the local Databases, it works but if I use the MSQuery of the sql2k to connect to the distant SQL6.5 it doesn't work.
There's something to declare on the SQL6.5 server to connect to it but what ?
You are not authorized to post a reply.

Acceptable Use Policy