Connection Problem with Production server

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Connection Problem with Production server

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-06 : 19:48:53

I have SQL server 2000 Prod server. We had a issue that SQL server showed error while connecting:DBNETLIB][ConnectionOpen(PreLoginHandshake()).]General network error. Check your network document . I thought it was a problem client network utility. Shared memory is turned off. Some clients can get connected and some cannot.

Can you explain why is this happening? or Should i enable Shared memory on for network utility.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-11-06 : 19:55:45

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92200

Give your post time to get seen. Hundreds of post here per day, and all volunteer help. If you want to rephrase what you wrote, use edit.

You may need to reinstall/configure SQL
http://www.eggheadcafe.com/aspnet_answers/SQLServerprogramming/Mar2006/post26535127.asp

or some components:
http://www.dbforums.com/showthread.php?t=814663

Google is your friend.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-06 : 22:57:36

Shared memory is for local connection. Tried with named pipes?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources