SQL Server Agent Did Not Auto-start

Nov 19, 2007

Hello everyone! We had an issue this week where SQL Server Agent did not restart automatically. Weekly maintenance runs on the server each Sunday in which a reboot of the server occurs. Both SQL Server and SQL Server Agent are set to auto-start when OS starts. SQL started fine, but SQL Server Agent didn't.

Anyone know of a reason why SQL Server Agent wouldn't have restarted? Also, does anyone know of a way to set something up that would alert me (through email) if this service hasn't restarted?

Thanks in advance,
Lance

View 7 Replies


ADVERTISEMENT

Auto Start Of SQL Server 7.0 Agent Not Occurring

Nov 16, 2000

I am not successful in getting SQL Server Agent to startup when SQL server starts up.

I believe the problem has to do with a lack of permissions or rights. I will list the steps
below which seem to me to be all that are needed to install SQL Server Agent. I used
Enterprise Manager to get this information.

If anyone can shoot any holes in the process, please do, that may be where my
problem lies.

a. Created NT accounts called MSSQLSERVER for the server and MSSQLSERVERAGENT
for SQL Agent.

b. Each of these accounts has the "right" to logon as a service.

c. Each of these accounts has "admin" rights.

d. Each of these accounts has been added to SQL SERVER under Security and Logins.

e. The properties assigned to each of the accounts are:
(1) on the general tab -- Windows NT authentication is in effect, database is master
and language is English (2) on the server roles tab -- System Administrators is checked
(3) on the database access tab -- the master database is checked

f. Under SQL Server Agent, properties, selecting the General Tab, in the frame
titled "service startup account":
(1) the circle labelled "this account" is clicked (2) the account is filled in using
domain namemssqlserveragent (3) the correct password is filled in taking case
into consideration

g. Under SQL Server Agent, properties, selecting the Connection Tab, in the frame
titled "sql server connection":
(1) the circle labelled "use windows NT authentication" is clicked


h. Right clicking the server and selecting properties show a multi-tab window
(1) the general tab shows that all three autostart boxes are checked
(2) the security tabs shows SQL Server and Windows authentication are in effect
(3) the startup service account shows "this account" selected and the account
is filled in with domain namemssqlserver and the password is filled in (taking
case into consideration)

In all cases above, the domain name is not the domain in which the server resides,
but is in a "trusted" domain.

Any help would be very much appreciated!!!!!

View 2 Replies View Related

Can't Auto-Start Agent

Jul 20, 2005

I have a SQL Server 2000 that failed to start after a Windows reboot.Agent properties are checked to auto start if stopped. Under the AgentError Log, I have the following data:Information:SQL Agent stopping because of Windows shutdown.SQL Agent terminated normally.Error:SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.Logon to server(local) failed.Help apprecaited. ThanksFrank*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 2 Replies View Related

Auto Start SQL Server By O/S.

Jun 28, 2002

Hello,
I'm working on some maintenance task. I need some O/S system to start my SQL Service when it found stopped due to error or els any reason. I mean, when due to error if they fail, they have to start automatically by O/S.

regard's,
vnk.

View 5 Replies View Related

SQL Server Agent - Auto Email Reminder

Jun 17, 2005

Hi Experts,
I have a table with fields:
remindWHO               remindWHEN        remindWHATsomeone@test.com    6/20/05                  do blah blah
I want SQL Server Agent automatically run every morning at 1:00 AM, check against "remindWHEN" date, if match with current date, send out email to "remindWHO" for what they need to do in "remindWHAT"
I was told this can be done by using the "Jobs" feature under SQL Server Agent to do this, but I don't know how to write Transact-SQL-Script under "Job Step".
Please help me. Or any better alternative?I appreciate for any help.

View 1 Replies View Related

Sql Server Agent Not Start

Jun 11, 2004

hi

when i try to start sql agent hang then mmc
i look the log and the problem is the mail profile

i try remove it from the property of sql agent but this hang the mmc too

can i remove this with tsql?

thanks

View 2 Replies View Related

SQL Server Agent Won't Start

Apr 18, 2008

We are having problems w/ our agent. When we try to start it in computer management, it will say the agent started then stopped because it has nothing to do. In surface area config, when we try to start it it times out. Does anyone have experience with this? We are desperate. Thanks!

View 3 Replies View Related

Start Sql Server Agent

May 12, 2008

hi
i have start sql server agent then dispaly following error message

(The system cannot find specified path) occured while performing this service operation on the sqlserveragent service

View 4 Replies View Related

SQl Server Agent Does Not Start

Jun 18, 2007

I cannot run SQl Server Agent service. Each time I try I get these 2 errors

Event Type:Error
Event Source:SQLAgent$MY_INSTANCE
Event Category:(2)
Event ID:17310
Date:18/06/2007
Time:09:27:49
User:N/A
Computer:MY SERVER
Description:
A user request from the session with SPID 53 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:



Event Type:Error
Event Source:SQLAgent$MY_INSTANCE
Event Category:Service Control
Event ID:103
Date:18/06/2007
Time:09:27:49
User:N/A
Computer:MY SERVER
Description:

SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is not set to a compatibility level of 70 or higher).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I am on SQL Server 2005. Do you have any ideas what might cause it and how to fix it?

Chris

View 3 Replies View Related

SQL Server Agent Does Not Start

Jun 18, 2007

I cannot run SQl Server Agent service. Each time I try I get these 2 errors

Event Type: Error
Event Source: SQLAgent$MY_INSTANCE
Event Category: (2)
Event ID: 17310
Date: 18/06/2007
Time: 09:27:49
User: N/A
Computer: MY SERVER
Description:
A user request from the session with SPID 53 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:



Event Type: Error
Event Source: SQLAgent$MY_INSTANCE
Event Category: Service Control
Event ID: 103
Date: 18/06/2007
Time: 09:27:49
User: N/A
Computer: MY SERVER
Description:

SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is not set to a compatibility level of 70 or higher).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I am on SQL Server 2005. Do you have any ideas what might cause it and how to fix it?

Chris

View 3 Replies View Related

Unable To Start SQL Server Agent

Oct 15, 1999

I need to start SQL Server Agent so that I can run scheduled jobs. I am running SQL Server 7.0 with windows NT 4.0 service pack 4. When I try to start the agent I get the following error

Error 22003: StartService() returned error 5,'Access is denied'

Does anyone have an idea as to why this is happening?
Any help with this problem would be appreciated.
Thanks

Phil

View 1 Replies View Related

Server Agent Doesnt Start.

Apr 7, 2005

hi guys i keep getting this error when trying to start the sql server agent service.

"The SQLSERVERAGENT service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service".

the SQL server service starts fine and i tryied starting the agent with the same user but it fails still.

Any ideas?

Thanks.

View 2 Replies View Related

Cannot Get SQL Server Agent To Start Using New Account... Why?

Feb 28, 2007

Well, this is very confusing.

I have 2 servers that are members of the same AD Domain.

I need an account that can login to either one, but needs to be able to start a service, which my network admin says a local domain administrator cannot do.

So, I just decided to create an account with the same name, properties and password on both machines.

This I did. The account is a member of local Windows Administrator group on each server. Additionally, it is an SQL account on the SQL Server local instance, and a member of the SysAdmin group.

I can assign this account to SQL Server as the startup account (Log in with this account). That works fine.
However, when I assign this account to SQL Server, then SQL Server Agent quits running. So I try to assign this same account to this service and I get an error that the account 'Unknown' cannot login and needs to be a member of the SysAdmin group!??

This is a completely confusing error message since the account is a Windows Admin, SQL Server SysAdmin account and can start SQL Server fine without a hitch.

Anyone else having this very annoying problem ?!

View 1 Replies View Related

SQL Server Agent - Start Up Account.

Aug 28, 2007

Hi all,

Please let me know what specific privileges an user account needs to be used as a LOG ON AS account for SQL Server Agent in SQL Server 2005.

Does the account needs to me in the domain administrator group?

Thanks,

DBLearner

View 2 Replies View Related

SQL Server Agent Fails To Start. Install ?

Sep 29, 2000

Two NT accounts have been created on the server.
MSSQLSERVER
MSSQLSERVERAGENT

These accounts have been given:
a. logon rights
b. unchangeable passwords
c. passwords which never expire
d. NT admin rights

Questions:

a. Do I have to create a login account within SQL Server 7 itself for these accounts?
b. Must the properties for "this account' box on the general tab include the domain name?
c. If the answer to (b) is yes, then can I use ".MSSQLSERVERAGENT" in the "this account"
box on the general tab?
d. Does the SQL Server Agent function require the "BUILTINadministrators" login in order
to work?

Any help in figuring out why I can't get my SQL Server Agent to startup will be appreciated!!

View 1 Replies View Related

SQL Server Agent - Can A Job Be Triggered To Start By Another Job Ending?

Jul 3, 2007

Hi,



I have a job in SQL Server agent with 199 SSIS steps and growing. In the job log only 99 steps are shown, which is a problem if a step higher than 99 fails to run. I need the steps to run in sequence and preferable would like to split the job into several jobs each containing no more than 99 steps. The only thing I don't know is if it is possible to have the next job in sequence start only when the previous job has finished.



Does anyone know if this is possible, and if so how it is done?



Many thanks,



Paul

View 4 Replies View Related

Snapshot Agent && Log Reader Agent Will Not Start.

Nov 30, 2006

Hi All,

I would appreciate any help here at all. I am pulling my hair out!

I am unable to start the snapshot agent or log reader agent from within SQL management studio. it fails on executing step 2 with unknown username or bad password.

I have checked all account details and they are correctly using my domain admin account. I can connect to SQL using teh same account and it also has sysadmin permissions.

If i copy the step 2 paramters and start from the cmd prompt (again logged in using the same domain account) they both start fine.



Any ideas would be gratefully received.

View 1 Replies View Related

Cannot Start Log Reader Agent And Snapshot Agent

May 18, 2007

I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.

For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).

This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"

Any ideas???





Also this domain account is a member of



SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER

SQLServer2005MSAgentUser$ServerName$MSSQLSERVER


View 3 Replies View Related

Unable To Start Service SQL Server Agent On ETC000211V

Apr 25, 2007

Hi,



When I click on SQL Server agent I get the "Unable to start service error".

It says serivce started and stopped.

Anybody having any clue on what's going wrong. Please let me know.



Regards,

HV

View 3 Replies View Related

Snapshot Agent Cannot Start Server Execution Failed

May 22, 2006

Hello, I've configured SQL Server 2000 for merge replication and am trying to start the snapshot agent for the publication and after about 20 minutes of it trying to start, it gives up with this error.



Server execution failed

There is no more information in the event viewer. I've tried it with a bunch of different subscriptions. SQL Server and SQL Agent are running under a local account which has access to the replcation data directory. SQL Agent is running.

I'm Running SQL 2000 SP3.

Thanks

Robert Brown

View 3 Replies View Related

SQL Server 2008 :: Unable To Start Agent Due To Blocked Access

Jun 28, 2015

Had some big problems with my SQL Server 2008 R2 SP1 during the last maintenance running on Windows Server 2008 R2 Enterprise ( upgraded from Standard). I'm getting the following error,

"SQL Server blocked access to procedure 'dbo.sp_sqlagent_has_server_access' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online."

I did a google search and found others with the problem but the resolution isn't working for me. I ran the following commands, heck I ran them multiple times. No errors come back running these commands. But the same error keeps happening, I even restart the service and then the server again.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

The msdb got too big for the disk it was on. I had maintenance plans to clear out the all of histories but I didn't think of the mail items. When I finally saw this problem I tried clearing them out using the stored procedures only with it finally failing because the transaction log got full. Since we didn't have a lot of jobs scheduled I decided to just recreate the msdb. So I scheduled a maintenance window, download SQL Server Service Pack 3.

my steps are as follows:
->diff backup of msdb
->stopped the service and started it again with: NET START MSSQLSERVER /T3608
->detached msdb with: SQLCMD -E -SP-SRVR-SQL-01 -dmaster -Q"EXEC sp_detach_db msdb"
->moved it off the drive
->restarted the service without any startup flags
->recreated msdb with: SQLCMD -E -SP-SRVR-SQL-01 -i"D:Microsoft SQL ->ServerMSSQL10_50.MSSQLSERVERMSSQLInstallinstmsdb.sql" -o"D:Microsoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLInstallinstmsdb62715.out"

I looked at the log file and there were no actual error messages so I applied service pack 3 and restarted server after it installed, was actually prompted to restart. In my tests I was never prompted to restart the server.Now I never started the agent service after recreating the msdb database since I knew it wasn't on the same version. I just went directly to the latest SP. Our applications are running fine but now I cant do scheduled backups.

View 1 Replies View Related

Making A Batch File That Will Start A Active Script In SQL Server Agent Through SQL Enterprise Manag

Jun 29, 2000

Hi again!
I would like to thank the 2 persons which I had an answer from my previous question first. Thanks a lot !

But, it didn't quite answer my question so I'll give a bit more info.
I would like to know if I can make a batch file, that excutes or starts an active script in SQL Server Agent (that is in SQL Enterprise Manager).
If I can, can you give me more info on how to do it (command line, parameters), a web site, anything that can help me to that.

If I cannot do that, let me know please.
Thanks a lot!

View 2 Replies View Related

How To Start The Snapshot Auto?

Jun 19, 2004

I have used the script file to make a transcation repliation. All the things goes well except a bug, when the script executed over, the snapshot does not start copy at once and need me go to the enterprise manager and right click it in the replication monitor to start it, I just want to start it auto when finish executing the script . How should I do ?

View 3 Replies View Related

Auto Start Mail Client

Nov 4, 1998

We currently have SQL Server 6.5 installed on 2 servers and did not
specify to automatically start the mail client. When I display the Server
Configuration/Options screen in Enterprise Manager, the Auto Start Mail
Client check box option is grayed out. How can I change these servers to
automatically start the mail client at startup?

Thanks in advance!

View 3 Replies View Related

SQL Agent Auto-restart Problems

May 31, 2001

Morning,

I set up SQL Agent to start up on a domain account with Administrator rights, and the
auto-restart option is on. However, the agent does not restart automatically when restarting
SQL Server. No problems restarting manually. The Event Viewer logs the following:
"SQLServerAgent security context does not have server-autorestart privileges."

Any ideas on how to diagnose this?
Thanks,

Sergio

View 4 Replies View Related

SQL Express FTS: No Agent, No Auto Updating?

Jun 7, 2007

If SQL Express has no SQL Agent then FT catalogs cannot be autoupdated, automatically reflect user data in catalogs?



I cannot solve problem with automatically indexing data in SQL Express FTS.







View 4 Replies View Related

Start A SQL Agent Job!!!!

Aug 21, 2001

Hello everyone,

Any ideas of how to start a SQL Agent job, from OTHER-THAN Enterprise Manager !!!

Does Microsoft provide any stored procs, extended procs or any SDK that can help me force-start a scheduled task ?

There has got to be a way, coz' Enterprise Manager is doing it !!!!..

Any help is greately appreciated.

Thanks..

View 3 Replies View Related

SQL Agent Does Not Start

Nov 16, 2007

I changed my server's service account to Domainsqladmin and the service started successfully.

I did the same for SQL Agent but the service starts and stops. In Event Viewer saw this error:

SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).

I checked Logins under under security in SSMS and the Domainsqladmin is a member of SysAdmin roles. What's wrong?

Canada DBA

View 6 Replies View Related

DB Engine :: Start Or Call System AUTO-SHRINK Process?

Jul 23, 2015

Is it possible to manually force/call/start the system AUTOSHRINK process? I have an issue that appears only when the engine shrinking process is running and I need this to reproduce my bug.

I know how to start a "regular" database shrink process with:DBCC SHRINKDATABASE(xxxx);, but this is not the same as one started from the database engine.

View 13 Replies View Related

SQL Agent Fails To Start

Apr 8, 2001

I'm trying to set up SQL 7 for replication, so I set SQLAgent to start automatically, same as SQL Server itself. SQL Server starts fine, but SQL Agent "fails to connect in a reasonable time" according to the Event log (3000 milliseconds).

Can you suggest how I go about fixing this? They both are using valid logins, so I don't know what else could be wrong.

Advice appreciated!

Arthur

View 3 Replies View Related

SQL Agent Does Start Automatically

Aug 23, 2001

I have a problem with a server where for some reason when it is rebooted the SQLAgent service does not start automatically. You have to go into control panel, services and start it, even the it is set to Automatic.

Thanking in advance for any ideas??

View 1 Replies View Related

Can't Start SQLServer Job Agent

May 4, 2002

In attempt to run the SQLServer Job Agent, the following error occurs:

An error 1068 (the dependency service or group failed to start) occured while performing this service opertion on the SQLServer Agent Service.

An user a/c with Administrator rights is assigned to the SQLServer Agent Service upon setup.

Any idea what is causing it?

Thanks in advance,
Ben

View 1 Replies View Related

Log Reader Agent Won't Start

Jun 22, 2004

We restored a database with replicated tables. Now, the Log Reader Agent will not run. This displays:
"The process could not execute 'sp_repldone/sp_replcounters' on 'ourservername'."
In Error Details for the agent:
"The process could not set the last distributed transaction."
And, from the logs:
"ForwardLogBlockReadAheadAsync: Operating system error 998(Invalid access to memory location.) encountered."

Does anyone know how we get the Distribution database and the Log Reader running again?
It is only affecting Transactional replication (not snapshot or merge).

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved