Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-26 : 07:22:46
|
| Mikhail Goncharov writes "I am using Desktop edition of SQL Server 200 on my workstation and yesterday start having connection problems to remote servers in the Enterprise manager.The Error message while connection was General Error (PreLoginHandShake()).I've tried all kind of things but nothing worked so I did 2 things: uninstall existing version, reinstalled it and then installed serveice pack 3a. After that I did not notice any changes. Then I used Client Network Utility and created aliases for all remote servers.I made a progress, now I can connect to the servers in the Enterprise Manager.There are still 2 issues remaining:1. Query Analyzer fails when trying to connect with General Error (TCP/IP sockets)2. SQL Server Agent fails to retieve the list of jobs from the remote server...Why ?Help !!!" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Connection Failure 