?
Solved

SQL PRELOGINHANDSHAKE

Posted on 2006-10-31
3
Medium Priority
?
1,446 Views
Last Modified: 2012-05-05
When we tryto connect to SQL server via ASP we get this error!
[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.
What can cause this? I wonder.

0
Comment
Question by:MSAIT
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
btutt earned 500 total points
ID: 17842841
This is a sockets error indicating that the SQL Server was not found on the network. I would ensure that you can connect from that machine via another utility (ODBC, OSQL) or even query analyzer for that matter if you have a SQL client installed on that machine.

Bryce
0
 
LVL 2

Author Comment

by:MSAIT
ID: 17847916
OK thanks but how do you check the cause of the problem? When I checked the SQL Server was running.
0
 
LVL 6

Expert Comment

by:btutt
ID: 17849404
Like I just said, check initially to see if you can connect to it from any tool. Make sure you can ping the machine at least to see if there is a network layer existent.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question