SQL Server 2k Agent Service Stuck In Starting State

Mar 10, 2004

I have a Win 2003 server running 3 instances of SQL 2000 Enterprise.
The problem is I can only start 2 of the 3 Job Agents at a time, as the 3rd gets stuck in a starting state.
Has anyone struck this problem before?

Thanks.

View 8 Replies


ADVERTISEMENT

I Had Set My Windows Service's Startup Type As Automatic But It Is Not Starting Up Automatically When The System Is Starting.

May 18, 2007

Hello,



I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.

View 3 Replies View Related

SQL Server Agent Is Not Starting

Jul 27, 2001

Hi,
we have a SQL server 7.0 on windows 2000 m/c,from yesterday onwards suddenly sqlserver agent is not starting,till then it was working fine.
I tried to start SQL server agent manually and i got following message

"[241] Startup error: Unable to initialize error reporting system (reason: The specified module could not be found) "

Then i tried to start from services in controll panel,but i could't.

Then i checked event log ,found following error messages

Application log:

1) "The description for event ID(105) in soure(SQL Server Agent) can not be found.
The Localcomputer may not havethe nessary registry information or message DLL files to
display messagees from a remote computer.The following information is part of the event:
The handle is invalid."

Event ID: 105
Source : SQLServerAgent
Category: Disk


system log:


1)The Sql server agent service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.


can any one help me in this matter

Thanks in advance
Ananth

View 2 Replies View Related

Sql Server Agent Not Starting...

Nov 9, 2000

Hi Folks,
Can anyone amongst u solve my problem..When i try to start the Sql Server Agent..i'm given the following error meassage..
Could not start Sql Server Agent.Error 2140.An Internal Windows NT error.
Please help me if anybody can.

View 4 Replies View Related

Sql Server Agent Not Starting

Jun 15, 2005

Hi have you guys seen this error when trying to start the sql agent?

SQLServerAgent could not be started (reason: sqlserveragent must be able to connect to sqlserver as sysadmin, but '(unkown)' is not a member of the sysadmin rol.

What is this all about I can start the sql server service with the same account i'm trying to start the agent.

View 2 Replies View Related

Starting SQL Server Agent

Jun 21, 2001

When I am trying to start SQL Server Agent from Enterprise Manager I am getting:

" An Error 5 - (Access Denied) occured while performing this operation on SQLServerAgent. "

No sound explanation found in MSDN library.
How to resolve this matter, is there other than EM methods so start it?
Thanx.

Zaven

View 1 Replies View Related

Starting The SQL Server Agent

Feb 26, 2006

Hi

How can we start the SQL Server Agent without having physical acess to the server, I mean i have access to the EM which is installed on another server. How to start the SQL Server Agent , the login i use has sa rights ,

Please help

View 2 Replies View Related

SQL Server Agent Not Starting Properly

Aug 15, 2000

Hi,
Running SQL 7.0 on NT4.
When server boots the SQL Server Agent appears to start normally. NT Service starts, Event Viewer shows service is started, Service Control Manager shows service started.

However when I try to view a job or create a lob I get the following error:

Error 14258: Cannot perform this operation while SQLServerAgent is starting. Please try again later.

Has anyone seen this behaviour before??

Thanks in advance

Michael

View 2 Replies View Related

Sql Server Agent Errors Starting

Mar 24, 2005

Hi guys, I'm trying to figure out why i'm having issues with the SQL server agent trying to start.

the error i get is 14258 cannot perform this operation while sqlserveragent is starting. try again later. sql-dmo(odbc sqlstate:42000)

any ideas how to fix this. I start the service as a domain user that is an admin on the server. but when i run a job it gives me the above error.

thanks.

View 2 Replies View Related

Starting Sql Server Agent Sql 2005

May 4, 2007

I am running windows 2003 and sql server 2005. i am following the directions in books online:

On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.

In SQL Server Configuration Manager, expand Services, and then click SQL Agent.

In the results pane, right-click any instance, and then click Start.

A green arrow on the icon next to the SQL Server Agent and on the toolbar indicates that SQL Server Agent started successfully.

Click OK.

the problem is i have nothing in Services. there is nothing to expand.
is it installed wrong?? or is there another step before this that i have to do??

View 1 Replies View Related

SQL Agent Is In Starting Status - But Not Starting

Mar 6, 2002

We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .

MDDB database is accessable & in Log file its recovered fully

Thankx in Advance

Sha

View 1 Replies View Related

Stuck In Loading State While Restoring DB

Nov 8, 2007

Hi there,

I'm new to this forum but was wondering if you could advise me on getting the DB back to an accessible state. I tried restoring the DB but unfortunately I don't have enough disk space. The error message appeared instantly informing me of the lack of disk space. Now it says its in (Loading state) and I cannot access the DB. Is there anyway I can manually change it back??

View 3 Replies View Related

Log Shippee Stuck In State (Restoring...)

Oct 5, 2007

I'm testing log shipping locally and had it running between two boxes. I tried to remove log shipping so on the primary I unchecked "Enable this as a primary database in a log shipping configuration" as per another thread. The primary stopped after a bit but the secondary never came out of the (Restoring...) state.

I'm obviously missing a step that needs to be run on the secondary because what I did wouldn't work if site A exploded but I can't figure out what the last step is.

Thanks,
Jeff

View 4 Replies View Related

Access Denied Starting SQL Server Agent

Mar 5, 2007

I've been struggling to figure out how to set the "Log on as" login for a SQL Server agent that isn't a member of the Administrators group.

Is this even possible? No matter what policy settings I assign the the user, I get an access denied error when I try to start the SQL Server Agent service. If that user is part of the administrators group, there are no errors.

I have no problems with other services and "log on as" logins...

View 8 Replies View Related

Difference In Starting Rep Service Vs. Stopping And Starting The Rep Job?

Feb 1, 2007

When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?



Thanks!

View 1 Replies View Related

SQL 2012 :: Server Agent Shutting Down Minute After Starting

Aug 27, 2014

When I start SQL Server Agent it's shutting down minute after starting. I tried to set Alerts to send email. After I configured Database Mail ,I was able to send test email , however after that SQL Server Agent started to misbehave.

View 3 Replies View Related

User Account Per SQL Server Service && SQL Agent Service, Why?

Jul 30, 2007

Hi all,
 I do understand that it is highly recomended to have aserprate user (perfered a domain user account) for each of the SQL Server service and SQL Agent service.
What is the reason behind that? (Someone told me to not run the service with an account that has a powerul privilegs! - I don't undrstanmd this point can you explain it please?)
What is the diffrent between: 1- Local System account 2 -Network Service account
 
Thanks in advanced!
CS4Ever

View 4 Replies View Related

SQL 2012 :: Server Shuts Down After Starting Service

Oct 26, 2015

I'm running SQL 2012 on a Win 2012 VM and the SQL server shuts down automatically after starting the SQL Server & SQL Server Agent Jobs.

View 9 Replies View Related

Local SQL Service Not Starting But SQL Server Is Running?

Jul 23, 2005

Hello there,This is a bit of strange one.My local version of SQL Server fails to start when I boot yet if Istart Enterprise Manager its started and working fine. ISQL or QueryAnalyzer is also not working.If I try and register the server by another SQL Server is not there. Methinks that the named pipes might be a bit broken but would appreciateany advise from people.ThanksGinters

View 2 Replies View Related

Problem Starting MS SQL Server 2005 Service

Sep 25, 2006

Hi,

Anybody kindly help me.

We have windows server 2000 and sql server 2005 on the same machine with 15 clients. There was a power failure. The sql server is automatically stopped. When we tried to start the service we are getting the error as action failed please check application event log for errors.

This has happened for the 2 times, kindly tell me why this happens and what precaution we can take and is there any setting we are missing. Since I am newbie to sql server and windows server I am unable to solve this problem.

Thanks

View 13 Replies View Related

SQL Server Express Starting As NETWORK SERVICE!!

Apr 28, 2006

Hello All,

I am installing SQL Server Express from the command line using the following parameters

INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SAPWD=TEST

After the install is done I start the service form the command prompt using

start mssqlserver

I see that the SQL Server service has started under NETWORK SERVICE account!!! when the documentation i Read on MSDN says it starts in Local System account

Can any one explain me the possible reasons



Thanks

View 8 Replies View Related

Sql Agent Not Starting Can We Reinstall Just Agent ?

Feb 7, 2002

SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

Is any has the same problem ?

View 6 Replies View Related

SQL Server 6.0 Help - Service State Indeterminate

Aug 28, 2002

I don't know too much about 6.0 so I need your help. I can't get to this database with a 6.5 enterprise manager either. The SQLOLE65.SQL script hasn't been run against the master database.

Well, here's the problem the Service Manager shows the services in a SERVICE STATE INDETERMINATE. No green, yellow red showing. I can't get into the database using enterprise manager because it says it's unavailable. However, on the enterprise manager it shows the database in a green (running state). So I'm uncertain whether to stop and start the database.

Has anyone every ran this SQLOLE65.SQL script so they can manage a 6.0 db thru a 6.5 enterprise manager? If so, please provide step by step instructions or warnings to look out for....

thanks

View 1 Replies View Related

SQL Server 2005 Upgrade To SP2 - SQL Server Service Not Starting - SOLUTION

Mar 15, 2007

I upgraded my SQL 2005 Workgroup 2005 to SP2 and subsequently could not get the SQL Server service running. Turns out this was a problem because I had created separate folders for my data and log files. The distmdl.mdf and mssqlsystemresource.mdf files were in my data folder and distmdl.ldf and mssqlsystemresource.ldf were in my log folder. During SP2 upgrade a new distmdl.ldf and mssqlsystemresource.ldf were created in my data folder. I deleted the distmdl.ldf and mssqlsystemresource.ldf files in my log folder and then moved the newly created ones in my data folder into the log folder and all is well now.



Just a heads up!



--Greg

View 1 Replies View Related

SQL Agent Not Starting

Feb 12, 2002

The SQLAgent service was modified to login as a domain account. SQLAgent would not start. I made sure that the account was in the Admin group on the server, I setup the account as a System Administrator in SQL. I made sure that the network protocols in Client Network Utiliity and Server Network Utility where the same as other servers using the domain account. The message I'm getting is...

SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start).

I modified the properties for SQLAgent back to login as local account and I still get the same problem.

Any suggestions would be appreciated.

Sidney Ives
Database Administrator
Sentara Healthcare.

View 4 Replies View Related

SQL Agent Not Starting

Oct 27, 2000

For three months I have be starting the SQL Agent using the following bat file

EXEC XP_CMDSHELL 'NET START SQLSERVERAGENT'.

Starting this week the agent is not starting. This is the error message

10/26/00 6:25:36 PM - ! [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)

What could have changed on the Server?

View 1 Replies View Related

SQL Agent Not Starting

May 31, 2002

When attempting to start SQL Server agent I get the following error:

"Error 1753 No End points available from Endpoint Mapper"

How can I solve this problem?

Thanks in advance for your time.

View 3 Replies View Related

SQL Agent Not Starting At All

Mar 28, 2007

I am unable to get SQL Agent service to run under the same domain name that my SQL Server service is running under. It will start and continue to run when Server and Agent are both ran under the Local Account. But once the services are switched over to the domain account, the Server starts, but the Agent fails. The domain user has administrative rights on the server, along with admin rights to the SQL instance.

Here is the event log.

Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Service Control
Event ID: 103
Date: 3/28/2007
User: N/A
Computer: SQL2
Description: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to the SQL Server as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).

Any help would be greatly appreciated or links to threads with answers.

View 7 Replies View Related

SQL Agent Not Starting Properly

Sep 28, 1999

We have SQL Server 7.0 running on an NT 4.0 sp5 box. Whenever we stop the SQL Server Service, we get the message that SQL Agent will also be stopped. If we do this, all the services seem to stop fine, but when we try to start the SQL Server Agent Service back up, it won't let us. In order for it to restart, we have to reboot the server so that it starts 'automatically'. Does anyone have any ideas as to why this is?

View 1 Replies View Related

SQL 7 Cluster - Starting SQL Agent

Sep 18, 2002

How do you start SQL Agent? MS states not to start thru Service Manager as it may corrupt registry. There is no Resource for SQL Agent in 7.0 cluster. The service is down, need to start to get jobs to run. I've just checked (enabled) the properties so Agent will start on O/S reboot or start after Unexpected stop. How do I get it start in the meantime?
Thanks!

View 6 Replies View Related

Agent Starting Error

Jun 5, 2002

Hi ,

Whenever I restart the Server , SQL server service is starting properly, but the agent is showing the green sign in EM ,agent Log also its showing its started. But in EM the jobs are not showing the next run time its showing ( Date and time not available). When I double click the jobs its showing the following error message
Micorsoft SQL - DMO ( ODBC Sql state 42000)
Error 14258 : can not perform this operation while SQL server agent is starting)
FYI :This server contain the databases of SMS too .

Thank you ,
Shaji

View 3 Replies View Related

Stuck Up With Reporting Service Installation

Apr 18, 2008



Hi All,
I have downloaded evaluation sample of SSRS for 120 days.
But myproblem is that while creating setup the server components and Report server is not installed.
Dut to that i cant run my report.It gives me error ,No report server was found .
I dont know what i missed? Anybody help me?
Its urgent.

Waiting for the reply.

View 5 Replies View Related

Urgent: I Have Problem In Starting More Than 8 Jobs Using SQL Agent

Mar 22, 2002

I am not able to run more than 8 jobs in SQL Server using SQL Agent JOB.

Any ideas and suggestions.

Thanks in advance.

View 3 Replies View Related







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