Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 9th, 2008, 02:27 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL Server does not exist or access denied

Hi,

I recently see this error occur often at different times on SQL server Agent Log. Please see the log extract as given below.

1) there is no sign of the SQL server shutting down ( SQL server Error log is fine)
2) The SQL services run fine without any issues.
3) During this time any application connecting to the SQL server too fails stating SQL server does not exist or cannot connect to database.

Does any one have a solution to it?

2008-03-31 06:25:29 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID
2008-03-31 06:25:29 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 5684
2008-03-31 06:25:29 - ? [101] SQL Server <SERVER_NAME> version 8.00.760 (0 connection limit)
2008-03-31 06:25:29 - ? [102] SQL Server ODBC driver version 3.86.3959
2008-03-31 06:25:29 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is
2008-03-31 06:25:29 - ? [310] 4 processor(s) and 2046 MB RAM detected
2008-03-31 06:25:29 - ? [339] Local computer is <SERVER_NAME> running Windows NT 5.2 (3790) Service Pack 2
2008-03-31 06:25:29 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2008-03-31 06:25:29 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2008-03-31 06:25:29 - + [260] Unable to start mail session (reason: No mail profile defined)
2008-03-31 06:25:29 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2008-03-31 06:26:37 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:26:37 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:26:37 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:26:51 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:26:51 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:29:08 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:29:08 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:30:43 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:30:43 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:30:59 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:30:59 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:00 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:00 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:03 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:03 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:03 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:31:15 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:15 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:15 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:31:16 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:16 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:16 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:31:31 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:31:31 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:31:31 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:32:49 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:32:49 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:34:54 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:34:54 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:38:38 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:38:38 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:38:38 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:40:07 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:07 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:07 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:40:33 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:33 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:33 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:34 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:34 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:34 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:35 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:40:35 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:40:35 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:40:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2008-03-31 06:40:39 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:41:13 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:41:13 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:41:13 - ! [382] Logon to server '(local)' failed (JobManager)
2008-03-31 06:41:14 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:41:14 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:11 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:42:11 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:11 - ! [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
2008-03-31 06:42:43 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:42:43 - ! [298] SQLServer Error: 10048, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:42:43 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:45:57 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:45:57 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:45:57 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:46:06 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:46:06 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:47:56 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2008-03-31 06:48:12 - + [188] Scheduler engine timed out (after 15 seconds) waiting for 1 jobs(s) to stop
2008-03-31 06:48:14 - ! [298] SQLServer Error: 17, SQL Server does not exist or access denied. [SQLSTATE 08001]
2008-03-31 06:48:14 - ! [298] SQLServer Error: 2, ConnectionOpen (Connect()). [SQLSTATE 01000]
2008-03-31 06:48:14 - ! [382] Logon to server '<SERVER_NAME>' failed (ConnAttemptCachableOp)
2008-03-31 06:48:26 - ! [240] 1 engine thread(s) failed to stop after 30 seconds of waiting
2008-03-31 06:48:26 - ! [311] Thread 'JobInvocationEngine' (ID 4388) is still running
2008-03-31 06:48:27 - + [098] SQLServerAgent terminated (forcefully)

Thanks,

_________________________
- Vijay G
Strive for Perfection
__________________
- Vijay G
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server does not exist or access denied jennypretty Classic ASP Databases 3 May 18th, 2007 11:43 AM
SQL Server does not exist or access denied. jimbeam36 BOOK: ASP.NET Website Programming Problem-Design-Solution 3 November 3rd, 2004 08:51 AM
SQL Server does not exist or access denied rj1406 ASP.NET 1.0 and 1.1 Basics 1 September 16th, 2004 08:58 PM
SQL Server does not exist or access denied haidee_mccaffrey Classic ASP Databases 19 June 28th, 2004 09:38 PM
SQL Server does not exist or access denied. nitinmailbox All Other Wrox Books 1 June 25th, 2003 06:35 AM



All times are GMT -4. The time now is 09:22 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.