473,325 Members | 2,792 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

SQL Server does not exist or access denied

I'm getting occasional instances of the error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied

I get the error both in application code and from Enterprise Manager.
The database is LOCAL.

Microsoft SQL Server 2000 Developer Edition SP4
Windows XP Professional SP2

My application essentially reads one row from one table, reads some
additional rows from the another table in the same local database, and
then writes one row into another table in another local database (and
commits the transaction). The application process approximately 3932
input records, then the read for the additional rows fails with the
error above. With identical input data sometimes it will fail after
3931 rows, sometimes 3932, sometimes 3933. Once it fails, it will fail
for the next 5-6 input rows, and then start working for a few thousand
rows more, then error again.

Note that the application should not actually connect to the database
when I get this error, it's just opening a dataset on an already-open
connection.

During the time the application is getting errors (about 3 minutes
duration at a stretch), attempting to access the same local server with
Enterprise Manager gives the same "SQL Server does not exist or access
denied" error.

While things are failing, I observe that SQL Server processes are not
using any CPU (in task manager).

Things I have tried:
Disabling Norton Antivirus and Internet Worm Detection
Configuring SQL Server to use only one processor (it's a 2-Xeon
processor machine)

The only thing that seems to work is to set the connection timeout and
command timeout to 6 minutes.

Jan 25 '06 #1
6 9087
Nothing in KB 328306 applies to my situation.

Jan 25 '06 #3
kwdavids (ke***@davnet.org) writes:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied

I get the error both in application code and from Enterprise Manager.
The database is LOCAL.

Microsoft SQL Server 2000 Developer Edition SP4
Windows XP Professional SP2

My application essentially reads one row from one table, reads some
additional rows from the another table in the same local database, and
then writes one row into another table in another local database (and
commits the transaction). The application process approximately 3932
input records, then the read for the additional rows fails with the
error above. With identical input data sometimes it will fail after
3931 rows, sometimes 3932, sometimes 3933. Once it fails, it will fail
for the next 5-6 input rows, and then start working for a few thousand
rows more, then error again.

Note that the application should not actually connect to the database
when I get this error, it's just opening a dataset on an already-open
connection.


Or at least so you like to think.

What I have seen is that there are some ways to get shared memory to become
sour. And shared memory is usually what you use for connection on a local
server.

One way is to open QA, stop SQL Server and restart. You can now notice
that opening new windows or starting OSQL takes a long time.

The other way I have encountered this was when I ran a script that for
test purposes connected and disconnected in a tight loop - and I had
turned off conncetion pooling for the test.

Connection Pooling is usually on in ADO .Net, but if you are not handling
your connections correctly, then the pool will dry out. But that usually
leads to an error message from ADO .Net before you wreck shared memory.

You would try opening the SQL Server Client Utility and an uncheck
shared memory, to see what effect this gives.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 25 '06 #4
Thanks Erland,

Disabling shared memory had no effect.

An argument against the memory corruption theory is that the problem
straightens itself out after 30 seconds to a couple of minutes.

This is really a very simple application (only 3 datasets total), and
nothing else of any significance is running at the same time.

It's as if SQL Server just stops responding from time to time (both to
Enterprise Manager and my application). I can't find any locks, nor is
the workstation using any CPU cycles.

Jan 27 '06 #5
kwdavids (ke***@davnet.org) writes:
An argument against the memory corruption theory is that the problem
straightens itself out after 30 seconds to a couple of minutes.

This is really a very simple application (only 3 datasets total), and
nothing else of any significance is running at the same time.

It's as if SQL Server just stops responding from time to time (both to
Enterprise Manager and my application). I can't find any locks, nor is
the workstation using any CPU cycles.


Autogrow is a faint possibility, but an autogrow that takes that long
would extend the database with a couple of GB, and it does sound like
we are talking that size of the database.

One place to check is the SQL Server error log, to see if there are
any messages. Also look at the starting time of the log, so that it's
not the case that SQL Server stops and restarts.

Also check for things outside SQL Server. Do you run any disk defragmenter
or anti-virus?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 27 '06 #6
Not auto-grow (too small), nothing in the SQL Server logs. No de-frag.
I run Norton Anti-Virus, but disabling it had no effect.

What I did find through server tracing, is that for some reason (which
I haven't been able to discover yet), each time the secondary DataSet
is being opened, there is another connection to the database. So the
problem might be "every few thousand connections". I'm building a test
bed application to try to simulate what's going on in the larger
program.

Jan 30 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
2
by: george r smith | last post by:
Gentlemen, I know that this problem has happened before and I searched and tried all solutions but problem is not solved. I install asp.net community starter kit with some help from this...
6
by: Bob | last post by:
Having trouble getting started. I created an instance of MSDE called VSDOTNET on a computer with the name of sysdev. Using MS SQL Web Adminstrator I created a database called temp with a...
3
by: Matthew Louden | last post by:
I attempt to connect ASP.NET application with SQL Server using ADO.NET. I just open a connection, and it had run-time error in line 34: cn.open(): SQL Server does not exist or access denied....
3
by: Olivogt | last post by:
Hello, I was just puting an application on the web server but it did not work as usual... - I do develop on my notebook and move released applications to the Web server - both have Sql Server...
9
by: Steven Ung | last post by:
Hello all, I'm having the following error dump from an ASP.net application. The program is to calculate MRP and it involves complex queries looping thru hundreds of records in an few SQL 2000...
1
by: ssp | last post by:
G'Day All, I have a web application sitting on my laptop and a Sql Server 2000 database on our INTRANET server running Windows 2003. Up until recently I was able to access the database using my...
2
by: Johan Johansson (Sweden) | last post by:
I can't connect to our database (seperate database server) from within my webservice. I cannot understand why.!!! * I have configured IIS not to allow anonymous access and to use "windows...
1
by: Atia Amin | last post by:
Hi, I am a new member. Hello to every one. I am new in ASP.NET area. I wrote an ASP.NET web application which was running ok with my old laptop. Currently I have given a new laptop. Now I copied...
1
by: vamshika | last post by:
hi, I got a serious Problem. I get "Server does not exist or access denied" with 80004005 as the error code. the win2003 server uses all the latest components(like iis6,jet..etc) and is upto date....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.