Cannot restore database: cannot start sqlserver agent

I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.This is a multi-part message in MIME format.
--000802080501040405060909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
--000802080501040405060909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</body>
</html>
--000802080501040405060909--|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I find out the SQLagent configuration of trust connection or =standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your =SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to =use a trusted connection or a standard SQL login?
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
00allen_iverson wrote: I cannot start the sqlserver agent neither manually or automatically and =I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server =
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

How can I find out the SQLagent =configuration of trust connection or standard SQL login? And how can I get help =from this. Thanks.
"Mike Hodgson" wrote in message news:u0rF7QZYFHA.4060=@.TK2MSFTNGP10.phx.gbl...Is your local SQL Server instance running? Can you connect =to your SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to use a =trusted connection or a standard SQL login?
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com 00allen_iverson wrote: I cannot start the sqlserver agent neither =manually or automatically and I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server ='(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.

--=_NextPart_000_000F_01C561D8.D5F683E0--|||This is a multi-part message in MIME format.
--010604090704090006030404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp)
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>>I cannot start the sqlserver agent neither manually or automatically and I
>>get this message in the event log:
>>SQLServerAgent could not be started (reason: Unable to connect to server
>>'(local)'; SQLServerAgent cannot start).
>>Can anyone please help? Thanks.
>>
>>
--010604090704090006030404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Open SQL Enterprise Manager. Expand the branches to expose your
local instance. Left-click on the local instance; this will establish
a client connection (SQLEM being the client) to your server. If that
is successful then your SQL server is running and accepting client
connections. 
 
Expand the + next to the server name. Expand the + next to
Management. Right-click on SQL Server Agent and select the property
menu option. This will bring up the configuration dialog box for SQL
Agent. 
 
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance. 
 
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance: 
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>) ">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>) 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
00allen_iverson wrote:
<blockquote cite="mideGEYJXZYFHA.2128@.TK2MSFTNGP14.phx.gbl" type="cite">
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
<style></style>
<div>How can I find out the SQLagent
configuration of trust connection or standard SQL login? And how can I
get help from this. Thanks.</div>
<div> </div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
dir="ltr">
<div>"Mike Hodgson" <<a
href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mike.hodgson@.mallesons.nospam.com</a>>
wrote in message <a href="http://links.10026.com/?link=news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl">news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl</a>...</div>
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt> 
<div class="moz-signature">
-- 
mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907 
E <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>

</div>
 
 
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl"
type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--010604090704090006030404--

Wednesday, March 7, 2012

cannot start sqlserver agent - urgent

No comments:

Post a Comment

Cannot restore database

Blog Archive

About Me