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+...
------------------------------
BUTTONS:
OK
------------------------------
Any Idea, where i could search the Problem?
br
Hermann
several things to check
several things to check here:
http://www.eventid.net/display.asp?eventid=103&eve...
Tony Sterling
bluesource
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?
SQL running?
Is the SQL server itself running?
Can you open the sql-manager and connect?
Looks like an Microsoft call to me
Thank you, Gertjan
MCSE, MCITP, MCTS Exchange 2007 SCS2007, SCS8.0
Company: www.t2.nl
Good site: www.enterprisevaultfaq.com
Good site: www.evdiscuss.net
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 :(
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/sqld...
thanks for posting!
Thanks for posting the solution.
Thank you, Gertjan
MCSE, MCITP, MCTS Exchange 2007 SCS2007, SCS8.0
Company: www.t2.nl
Good site: www.enterprisevaultfaq.com
Good site: www.evdiscuss.net
Would you like to reply?
Login or Register to post your comment.