Showing posts with label sqlserveragent. Show all posts
Showing posts with label sqlserveragent. Show all posts

Monday, March 19, 2012

can't (re)start SQLServerAgent after changing its logon credentials

Since Copy Databas Wizard failed to copy anything from remote SS20005 (both are with SP2 3054) in any combination,
I changed SQLServerAgent(myinstance_name) to run under Network from Local System with the help of SQL Server Configuration Manager

For this change it was restarted, failed to start again and continues to be stopped giving
"SQLServerAgent could not be started (reason: Unable to connect to server '<mymachine_name>\<myinstance_name>'; SQLServerAgent cannot start)."

I changed SQL Server Agent (myinstance_name) back to Local Service, then to Local System and still can't start it.

So, my questions:
1)
What has happened and how can I start SQLServerAgent?

2)
Why cannot I start it under Network Service? since it apparently should access remote resources for CDW to copy from remote SS2005

This is on MS Windows XP SP2

PS
After few trials I amnaged to restart it again under Local System but still cannot change to any different one

If you change the account under which SQL Agent starts you need to make sure that the account has permissions within SQL server or else each tim eit tries to access SQL Server it will fail. Have a look at these:

http://support.microsoft.com/kb/283811

http://support.microsoft.com/kb/907557

|||

You can verify the permissions, windows group membership required, etc for the service accounts in the following books online topic:

Setting Up Windows Service Accounts

http://msdn2.microsoft.com/en-us/library/ms143504.aspx

The NT Rights and Privleges section has the local windows group membership requirements - that one often gets overlooked for some reason. The help topic is pretty thorough and does a good job of covering the requirements.

Also note that as the article states, using Network Service isn't recommended. A domain account can provide the same network access but in a more secure manner. Otherwise you open some holes - network service means you give permissions needed for the CDW to the machine account. And then other apps, services running under network service get the permissions as well as they would be operating under the machine account.

-Sue

Wednesday, March 7, 2012

cannot start sqlserver agent - urgent

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><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
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.<br>
<br>
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.<br>
<br>
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.<br>
<br>
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:<br>
<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>)<br>">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>)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
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><font face="Arial" size="2">How can I find out the SQLagent
configuration of trust connection or standard SQL login? And how can I
get help from this. Thanks.</font></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><br>
<div class="moz-signature">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2">database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3668 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">F</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3885 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">M</font></b><font
face="Tahoma" size="2"> +61 (408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=http://www.mallesons.com</a></font></span>">http://www.mallesons.com">http://www.mallesons.com</a></font></span>
</p>
</div>
<br>
<br>
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--

Saturday, February 25, 2012

Cannot start agent...

Hi there.
I am getting the following error when trying to start the Sqlserver agent
(on a version 7 db):
SQLServerAgent could not be started (reason: Unable to connect to server;
SQLServerAgent cannot start).
I have connect to the server using the NT windows authentication (which is
what is used to start the agent) and I connect 100%.
Does anyone have any ideas?
Any help will be appreciated.
Thanks
ClintThe SQL Server MUST be running and a domain controller must be available...
SQL Agent MUST also connect to SQL with a SQL login which has ADMINISTRATIVE
SQL privelege..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>|||Clint,
Here is a link to an article by Richard Waymire on 7.0 security
http://tinyurl.com/j24t . It discusses security issues related to SQL Agent
The following Troubleshooting guide for SS2000 may also be of interest:
http://tinyurl.com/j249
Russell Fields
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>

Sunday, February 12, 2012

Cannot run SQLServerAgent jobs after changing SA password

I am new to SQL Server 2000. When I set a password for SA all the SQLServerAgent jobs fail with a login error and will not start. I have tried to change the SQLAgent service login via the Control Panel/Services, but it will not accept SA as a valid login, when I browse logins, only the NT logins seem to appear. The jobs are owned by my normal login and not by SA.

This is probably a simple change, but I am going round in circles trying to locate the 'how to' documentation.SQLServerAgent service needs to run under a Windows account...|||Check your SQL Server connection settings in SQL Server Agent properties (Windows Auth. or SQL server Auth.).|||Thanks. I did not see the SQL agent connection properties with a login and password. All is now well.