Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Reload this Page SQL Server does not exist or access denied
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 9th, 2008, 02:27 AM
Friend of Wrox
  
Join Date: Jun 2003
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





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




Contact Us - Wrox - Privacy Statement - Top

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