Highlighted

Unable to connect to server '(local)'; SQLServerAgent cannot start

Dear all,
as prework for the eVault 8 SP3 installation i changed the local admin pw and installed the SP3 Deployment Scanner, following a reboot.
Now the "SQL Server Agent" is unable to start, after start the service stops immediately.

OS: Windows 2008 Single Server, SQL 2005

In the Eventlog i got the following error:

++++++++++++++++++++++++++++++++++++
Log Name:      Application
Source:        SQLSERVERAGENT
Date:          05.11.2009 16:19:28
Event ID:      103
Task Category: Service Control
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      vie-eu-arc-02.xxx.yyy
Description:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SQLSERVERAGENT" />
    <EventID Qualifiers="16384">103</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-05T15:19:28.000Z" />
    <EventRecordID>8166</EventRecordID>
    <Channel>Application</Channel>
    <Computer>vie-eu-arc-02.xxx.yyy</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Unable to connect to server '(local)'; SQLServerAgent cannot start</Data>
  </EventData>
</Event>
++++++++++++++++++++++++++++++++++++


in the SQL Agent Log:

++++++++++++++++++++++++++++++++++++
2009-11-05 16:55:03 - ! [298] SQLServer Error: 233, Shared Memory Provider: No process is on the other end of the pipe. [SQLSTATE 08001]
2009-11-05 16:55:03 - ! [298] SQLServer Error: 233, Client unable to establish connection [SQLSTATE 08001]
2009-11-05 16:55:03 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2009-11-05 16:55:03 - ! [298] SQLServer Error: 233, Shared Memory Provider: No process is on the other end of the pipe. [SQLSTATE 08001]
2009-11-05 16:55:03 - ! [298] SQLServer Error: 233, Client unable to establish connection [SQLSTATE 08001]
2009-11-05 16:55:03 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)
2009-11-05 16:55:03 - ? [098] SQLServerAgent terminated (normally)
++++++++++++++++++++++++++++++++++++


i changed the User (local Admin, Domain Admin, other service Account)
on the SQL Server & SQL Agent same result.

I'am unable to start the SQL Server Management Studio, the Error:

TITLE: Connect to Server
------------------------------
Cannot connect to vie-eu-arc-02.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------


Any Idea, where i could search the Problem?
br
Hermann

1 Solution

Accepted Solutions
Accepted Solution!

SQL running?

Is the SQL server itself running?
Can you open the sql-manager and connect?
Looks like an Microsoft call to me
Regards. Gertjan

View solution in original post

6 Replies

several things to check

several things to check here:

http://www.eventid.net/display.asp?eventid=103&eventno=2845&source=SQLSERVERAGENT&phase=1


For the best O365 Reporting Solution click here Radar-Reporting

The driver regkey is OK, all

The driver regkey is OK,
all other stuff is for Cluster, my installation is a single server!

Other ideas?
Accepted Solution!

SQL running?

Is the SQL server itself running?
Can you open the sql-manager and connect?
Looks like an Microsoft call to me
Regards. Gertjan

View solution in original post

SQL Server Agent

SQL Server Agent Service...

Is the SQL server itself running?

Yes of course, the SQL Server Service works fine.
The Log:
-------------------------------------------------------------------------------------------------------------------
2009-11-05 18:16:48.67 Server      Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
    Nov 24 2008 16:17:31
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)

2009-11-05 18:16:48.67 Server      (c) 2005 Microsoft Corporation.
2009-11-05 18:16:48.67 Server      All rights reserved.
2009-11-05 18:16:48.67 Server      Server process ID is 4424.
2009-11-05 18:16:48.67 Server      Authentication mode is WINDOWS-ONLY.
2009-11-05 18:16:48.67 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-05 18:16:48.67 Server      This instance of SQL Server last reported using a process ID of 4784 at 11/5/2009 6:16:27 PM (local) 11/5/2009 5:16:27 PM (UTC). This is an informational message only; no user action is required.
2009-11-05 18:16:48.68 Server      Registry startup parameters:
2009-11-05 18:16:48.68 Server           -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-05 18:16:48.68 Server           -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-05 18:16:48.68 Server           -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-11-05 18:16:48.68 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-11-05 18:16:48.68 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2009-11-05 18:16:48.77 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2009-11-05 18:16:48.80 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-11-05 18:16:50.82 Server      Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-11-05 18:16:50.82 Server      Database mirroring has been enabled on this instance of SQL Server.
2009-11-05 18:16:50.82 spid4s      Starting up database 'master'.
2009-11-05 18:16:50.91 spid4s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2009-11-05 18:16:51.01 spid4s      SQL Trace ID 1 was started by login "sa".
2009-11-05 18:16:51.04 spid4s      Starting up database 'mssqlsystemresource'.
2009-11-05 18:16:51.05 spid4s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2009-11-05 18:16:51.74 spid9s      Starting up database 'model'.
2009-11-05 18:16:51.74 spid4s      Server name is 'VIE-EU-ARC-02'. This is an informational message only. No user action is required.
2009-11-05 18:16:51.77 Server      The certificate was successfully loaded for encryption.
2009-11-05 18:16:51.77 Server      Server is listening on [ 'any' <ipv6> 1433].
2009-11-05 18:16:51.77 Server      Server is listening on [ 'any' <ipv4> 1433].
2009-11-05 18:16:51.77 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2009-11-05 18:16:51.77 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2009-11-05 18:16:51.77 Server      Server is listening on [ ::1 <ipv6> 1434].
2009-11-05 18:16:51.77 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434].
2009-11-05 18:16:51.77 Server      Dedicated admin connection support was established for listening locally on port 1434.
2009-11-05 18:16:51.79 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2009-11-05 18:16:51.80 spid15s     Starting up database 'Test'.
2009-11-05 18:16:51.80 spid13s     Starting up database 'AdventureWorksDW'.
2009-11-05 18:16:51.80 spid16s     Starting up database 'EnterpriseVaultDirectory'.
2009-11-05 18:16:51.80 spid12s     Starting up database 'msdb'.
2009-11-05 18:16:51.81 spid14s     Starting up database 'AdventureWorks'.
2009-11-05 18:16:51.81 spid17s     Starting up database 'EnterpriseVaultMonitoring'.
2009-11-05 18:16:51.81 spid19s     Starting up database 'EVVSVIEIT_1'.
2009-11-05 18:16:51.81 spid20s     Starting up database 'ReportServer'.
2009-11-05 18:16:51.81 spid21s     Starting up database 'ReportServerTempDB'.
2009-11-05 18:16:51.81 spid24s     Starting up database 'EVVSJournalVaultStore_3'.
2009-11-05 18:16:51.81 spid23s     Starting up database 'EVVSExchangeVaultStore_2'.
2009-11-05 18:16:51.82 spid18s     Starting up database 'EVVSGVIEIT_1_1'.
2009-11-05 18:16:51.83 spid22s     Starting up database 'EVVSGVIE_2_2'.
2009-11-05 18:16:51.97 spid24s     CHECKDB for database 'EVVSJournalVaultStore_3' finished without errors on 2009-11-04 18:05:51.793 (local time). This is an informational message only; no user action is required.
2009-11-05 18:16:52.00 spid16s     CHECKDB for database 'EnterpriseVaultDirectory' finished without errors on 2009-11-04 18:06:38.103 (local time). This is an informational message only; no user action is required.
2009-11-05 18:16:52.04 spid19s     CHECKDB for database 'EVVSVIEIT_1' finished without errors on 2009-10-28 18:06:14.107 (local time). This is an informational message only; no user action is required.
2009-11-05 18:16:52.05 spid23s     CHECKDB for database 'EVVSExchangeVaultStore_2' finished without errors on 2009-11-04 18:05:33.960 (local time). This is an informational message only; no user action is required.
2009-11-05 18:16:52.11 spid17s     CHECKDB for database 'EnterpriseVaultMonitoring' finished without errors on 2009-11-04 18:06:18.570 (local time). This is an informational message only; no user action is required.
2009-11-05 18:16:52.13 spid9s      Clearing tempdb database.
2009-11-05 18:16:52.37 spid4s      Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2009-11-05 18:16:53.01 spid9s      Starting up database 'tempdb'.
2009-11-05 18:16:53.17 spid4s      Recovery is complete. This is an informational message only. No user action is required.
2009-11-05 18:16:53.17 spid12s     The Service Broker protocol transport is disabled or not configured.
2009-11-05 18:16:53.17 spid12s     The Database Mirroring protocol transport is disabled or not configured.
2009-11-05 18:16:53.21 spid12s     Service Broker manager has started.
2009-11-06 00:00:45.95 spid18s     This instance of SQL Server has been using a process ID of 4424 since 11/5/2009 6:16:53 PM (local) 11/5/2009 5:16:53 PM (UTC). This is an informational message only; no user action is required.

--------------------------------------------------------------------------------------------------------

Can you open the sql-manager and connect?

No

---------------------------------------------
Cannot connect to vie-eu-arc-02.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

---------------------------------------------

Looks like an Microsoft call?

i will take a look into the MS SQL Forum Smiley Sad


solution

The problem was the changed certificate on the webpage.
The certificate was stored by the system additional as file in the  profile,
because the file was different from the actice certificate the sql encryption doesn't work
and the SQL Agent start failed.

more details see the MS SQL Forum:

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/fb00d4b3-6947-4c61-9760-44f02fd45d8d/#015d6f3c-61ca-406d-9003-2dd94d3d283c


thanks for posting!

Thanks for posting the solution.
Regards. Gertjan