i haven't installed it yet, mine is working for now. seems to be a sporadic problem. anyone else installed it?

read this thread:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12804&FORUM_ID=5&CAT_ID=1&Forum_Title=Administration&Topic_Title=SQL+Server+Service+Pack+3

It mentions about that being fixed in SP3a. I had SP3 installed when this problem was happening. I would try to either upgrade MDAC or SQL...

read this topic

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12804&FORUM_ID=5&CAT_ID=1&Forum_Title=Administration&Topic_Title=SQL+Server+Service+Pack+3

It may well be causing the problem. i managed to get mine working by creating a new alias in CLIENT NETWORK UTILITY, connecting using TCP/IP.

When I get the error, it...

i didn't re-install anything for it to get working when it happened for me. have you tried reconfiguring the client network utility?

Stalker's Communigate Pro is excellent. http://www.stalker.com/cpro/features.html

I have been using it for 3 years now and haven't had a problem apart from initially not understanding what an open relay was :-(...

I have had this before and I fixed it by going into the SQL "Client Network Utility" (under MS SQL Server in your START menu). Setup an alias for your...