Search

SQL Agent 2008 (RTM) suddenly start failing to start (...Unable to connect to server ...) by Vlad Dombrovski

Closed
as Not Reproducible Help for as Not Reproducible

0
0
Sign in
 to vote
Type: Bug
ID: 364234
Opened: 8/28/2008 7:34:41 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
SQL Agent is not able to connect to SQL instance after reboot:

2008-08-28 08:22:57 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-28 08:22:57 - ! [000] Unable to connect to server 'TSTWIN2K8\SQL2008'; SQLServerAgent cannot start
2008-08-28 08:22:57 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-28 08:22:57 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (DisableAgentXPs)
2008-08-28 08:22:58 - ? [098] SQLServerAgent terminated (normally)

Following have been found in app.event log:

Log Name:     Application
Source:        SQLNCLI10.1
Date:         8/28/2008 8:22:57 AM
Event ID:     1
Task Category: None
Level:         Error
Keywords:     Classic
User:         N/A
Computer:     TSTWIN2K8.domain.ca
Description:
The description for Event ID 1 from source SQLNCLI10.1 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:


Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="SQLNCLI10.1" />
    <EventID Qualifiers="49152">1</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-08-28T12:22:57.000Z" />
    <EventRecordID>1518</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TSTWIN2K8.domain</Computer>
    <Security />
</System>
<EventData>
</EventData>
</Event>
"
The description for Event ID 1 from source SQLNCLI10.1 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: "

Log Name:     Application
Source:        SQLAgent$SQL2008
Date:         8/28/2008 8:22:57 AM
Event ID:     103
Task Category: Service Control
Level:         Error
Keywords:     Classic
User:         N/A
Computer:     TSTWIN2K8.domain.ca
Description:
SQLServerAgent could not be started (reason: Unable to connect to server 'TSTWIN2K8\SQL2008'; SQLServerAgent cannot start).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="SQLAgent$SQL2008" />
    <EventID Qualifiers="16384">103</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-08-28T12:22:57.000Z" />
    <EventRecordID>1519</EventRecordID>
    <Channel>Application</Channel>
    <Computer>TSTWIN2K8.domain.ca</Computer>
    <Security />
</System>
<EventData>
    <Data>Unable to connect to server 'TSTWIN2K8\SQL2008'; SQLServerAgent cannot start</Data>
</EventData>
</Event>


Running "repair" option for "Microsoft SQL Server 2008 Native Client" in "Control Panel\Program and Features" seemed to resolve the issue.
Details (expand)
Product Language
English

Version

SQL Server 2008 - Enterprise Edition

Category

SNAC

Operating System

Windows Server 2008
Operating System Language
US English
Steps to Reproduce
not aware
Actual Results
failed to start
Expected Results
able to start

Platform

X64
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 9/9/2008 at 11:33 AM
Thanks for the feedback and the information.
From the logs provided we could not reproduce the error. However we would continue to investigate more on the issue and see if we can find some repro. Please feel free to provide a repro if you encounter the same issue again. For now we are resolving the issue as "not repro"
Posted by Vlad Dombrovski on 8/28/2008 at 11:56 AM
Hi, I'm not sure what kind of information you're looking for... Here are some pieces: it's a brand-new installation of named stand-alone instance of SQL Server 2008 Enterprise x64 (RTM) with BIN2 collation on a brand-new installation of Windows Server 2008 Enterprise x64 (SP1, HP BL680c G5). Shared by SQL Engine and SQL Agent service account has "lock pages in memory" privilege. I could provide installation screenshots if they could be kept private.
Yes, SQL Agent was working initially (see corresponding log entries below).
Clean install of SQL2008 on clean install of Windows2008.
I'm not able to reproduce the error - I have neither resources (currently, it's our only installation of both Windows 2008 and SQL2008 and I'm on tight schedule to make it work) nor desire.
I'm not sure I'm following "any possibility" question. A possibility always exists (domain policies, sabotage and etc.). What I can tell is that I'm not aware of any SNAC uninstall on purpose. All I did was SQL2008 installation and database copy from SQL2005. SAP folks ran (successfully) SAPinst.exe tool to prep instance for SAP ECC6 (yes, we are one of those guiney pigs to have production SAP running in 2008/2008 environment - crossing fingers). Besides, SNAC 2008 was still present in the list of installed programs. So, "corrupted" would describe its (SNAC) condition better.
As per log file, I can provide them if you could keep them private since they must contain some information about domain/accounts I'd like to keep confidential.

Thanks.

2008-08-26 15:43:08 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 4472
2008-08-26 15:43:08 - ? [101] SQL Server TSTWIN2K8\SQL2008 version 10.00.1600 (0 connection limit)
2008-08-26 15:43:08 - ? [102] SQL Server ODBC driver version 10.00.1600
2008-08-26 15:43:08 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is TSTWIN2K8\SQL2008
2008-08-26 15:43:08 - ? [310] 8 processor(s) and 24572 MB RAM detected
2008-08-26 15:43:08 - ? [339] Local computer is TSTWIN2K8 running Windows NT 6.0 (6001) Service Pack 1
2008-08-26 15:43:08 - ? [432] There are 7 subsystems in the subsystems cache
2008-08-26 15:43:09 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2008-08-26 15:43:09 - ? [129] SQLAgent$SQL2008 starting under Windows NT service control
2008-08-26 15:43:09 - + [260] Unable to start mail session (reason: No mail profile defined)
2008-08-26 15:43:09 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2008-08-26 15:57:51 - ? [131] SQLAgent$SQL2008 service stopping due to a stop request from a user, process, or the OS...
2008-08-26 15:57:54 - ? [098] SQLServerAgent terminated (normally)

2008-08-26 15:58:02 - ? [393] Waiting for SQL Server to recover databases...
2008-08-26 15:58:05 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 4476
2008-08-26 15:58:05 - ? [101] SQL Server TSTWIN2K8\SQL2008 version 10.00.1600 (0 connection limit)
2008-08-26 15:58:05 - ? [102] SQL Server ODBC driver version 10.00.1600
2008-08-26 15:58:05 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is TSTWIN2K8\SQL2008
2008-08-26 15:58:05 - ? [310] 8 processor(s) and 24572 MB RAM detected
2008-08-26 15:58:05 - ? [339] Local computer is TSTWIN2K8 running Windows NT 6.0 (6001) Service Pack 1
2008-08-26 15:58:05 - ? [432] There are 7 subsystems in the subsystems cache
2008-08-26 15:58:05 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2008-08-26 15:58:05 - ? [129] SQLAgent$SQL2008 starting under Windows NT service control
2008-08-26 15:58:05 - + [260] Unable to start mail session (reason: No mail profile defined)
2008-08-26 15:58:05 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2008-08-27 12:17:33 - ? [130] SQLAgent$SQL2008 stopping because of Windows shutdown...
2008-08-27 12:17:35 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 12:17:35 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (SaveAllSchedules)
2008-08-27 12:17:35 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 12:17:35 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (DisableAgentXPs)
2008-08-27 12:17:35 - ? [098] SQLServerAgent terminated (normally)

2008-08-27 12:21:43 - ? [393] Waiting for SQL Server to recover databases...
2008-08-27 12:21:49 - ? [100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 3628
2008-08-27 12:21:49 - ? [101] SQL Server TSTWIN2K8\SQL2008 version 10.00.1600 (0 connection limit)
2008-08-27 12:21:49 - ? [102] SQL Server ODBC driver version 10.00.1600
2008-08-27 12:21:49 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is TSTWIN2K8\SQL2008
2008-08-27 12:21:49 - ? [310] 8 processor(s) and 24572 MB RAM detected
2008-08-27 12:21:49 - ? [339] Local computer is TSTWIN2K8 running Windows NT 6.0 (6001) Service Pack 1
2008-08-27 12:21:49 - ? [432] There are 7 subsystems in the subsystems cache
2008-08-27 12:21:52 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2008-08-27 12:21:52 - ? [129] SQLAgent$SQL2008 starting under Windows NT service control
2008-08-27 12:21:52 - + [260] Unable to start mail session (reason: No mail profile defined)
2008-08-27 12:21:52 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2008-08-27 15:54:58 - ? [130] SQLAgent$SQL2008 stopping because of Windows shutdown...
2008-08-27 15:55:00 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 15:55:00 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (SaveAllSchedules)
2008-08-27 15:55:00 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 15:55:00 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (DisableAgentXPs)
2008-08-27 15:55:00 - ? [098] SQLServerAgent terminated (normally)

2008-08-27 15:58:46 - ? [393] Waiting for SQL Server to recover databases...
2008-08-27 15:58:52 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 15:58:52 - ! [000] Unable to connect to server 'TSTWIN2K8\SQL2008'; SQLServerAgent cannot start
2008-08-27 15:58:52 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
2008-08-27 15:58:52 - ! [382] Logon to server 'TSTWIN2K8\SQL2008' failed (DisableAgentXPs)
2008-08-27 15:58:53 - ? [098] SQLServerAgent terminated (normally)


Posted by Microsoft on 8/28/2008 at 10:27 AM
Thank you for sending this feedback.

SQL Server Native Client should be installed as part of SQL Server setup. Could you provide more information about you configuration and installation process please? Did SQL Agent work initially and then stop working or did it never work? Was this a clean install or an upgrade? Are you able to reproduce the setup process and subsequent failure? Is there any possibility that SQL Native Client was uninstalled after SQL Server was installed? Could you attach the setup logs please? The logs will be in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

We will continue our investigation weh n we have this additional information. Thank you once again for sending this feedback.
Sign in to post a workaround.
© 2012 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement