Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 2nd, 2004, 04:48 AM
Authorized User
 
Join Date: Jun 2004
Location: Aurangabad, Maharashtra, India.
Posts: 54
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL Server Agent

hi,

I am using MSDE as backend for my software, I want to schedule the backup, but it requires SQL Server Agent has to be running.

But I don't know why my SQL Server Agent process does not start even if I am starting it explicitly.

This problem persisting even after re-installation of MSDE.

Can anybody tell me the reason why this is happening and how to get rid of it.



Vinod Pawar
Software Developer
Videocon International Ltd.
India
__________________
Vinod Pawar
United States
 
Old July 2nd, 2004, 04:06 PM
Friend of Wrox
 
Join Date: Oct 2003
Location: Cairo, , Egypt.
Posts: 336
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alyeng2000
Default

make sure that you check the service to start with window start up

Ahmed Ali
Software Developer
 
Old July 2nd, 2004, 10:51 PM
Authorized User
 
Join Date: Jun 2004
Location: Aurangabad, Maharashtra, India.
Posts: 54
Thanks: 0
Thanked 1 Time in 1 Post
Default

ya, other services are starting with windows startup except Sql server agent even after specifying "Auto-Start service when os starts". When I had installed MSDE that time it was working fine, but after some days I don't know what happened, this problem occurred and still persisting even after re-installing all.

Vinod Pawar
Software Developer
India
 
Old July 3rd, 2004, 07:01 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Vinod,

It should be logging something on its status when you attempt to start that. Check your event logs to see what error it generates there. It would be better you post the error that you could see when you attempt to start SQL server Agent, as there are many reasons for it to not start.

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old July 14th, 2004, 06:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Based on your log entries, it looks like SA itself has failed to login. Anything recently done to that system Like changing password or so?

I suspect there was a change in SA password done recently that is the cause for it. By any chance did you forget to mention about change in SA password in your post or did someone else changed that without your knowledge?

Check this page for work around.

SQL Server Agent Fails to Start on Windows 9x When You Change the sa Password

_________________________
- Vijay G
Strive for Perfection
 
Old July 14th, 2004, 07:04 AM
Authorized User
 
Join Date: Jun 2004
Location: Aurangabad, Maharashtra, India.
Posts: 54
Thanks: 0
Thanked 1 Time in 1 Post
Default

thanx Vijay,

I think this will solve my problem.

If you can please do suggest something for other problem also
http://p2p.wrox.com/topic.asp?TOPIC_ID=16000

thanx again.


Vinod Pawar
Software Developer
India
 
Old July 14th, 2004, 07:15 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Just curious to know, if the SA password was changed after which you are facing this problem. Did that happen?

_________________________
- Vijay G
Strive for Perfection
 
Old July 14th, 2004, 10:52 PM
Authorized User
 
Join Date: Jun 2004
Location: Aurangabad, Maharashtra, India.
Posts: 54
Thanks: 0
Thanked 1 Time in 1 Post
Default

hello vijay,

you are right, that was happening just because of change of password.
but, isn't it strange thing, if you change password of 'sa' user, that has also to be changed in SqlServerAgent. It's non microsoft kind thing.

thanx


Vinod Pawar
Software Developer
India
 
Old July 15th, 2004, 04:50 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

This is the case with Win9x, not with other higher versions of Windows. You can go through the content under CAUSE heading in the micrisoft support link, that reads ...

The information needed for SQL Server Agent to start is obtained from the registry; however, the information does not exist in the registry until after the sa password is changed by the SQL Server Enterprise Manager (SEM). This method is used on Microsoft Windows 9x computers, because they do not support trusted-connections, which is the default for Microsoft SQL Server 7.0 on both Microsoft Windows NT 4.0-based computers and Microsoft Windows 2000-based computers.

Hope that explains.
Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old July 15th, 2004, 10:52 PM
Authorized User
 
Join Date: Jun 2004
Location: Aurangabad, Maharashtra, India.
Posts: 54
Thanks: 0
Thanked 1 Time in 1 Post
Default

thank you very much Vijay

Vinod Pawar
Software Developer
India




Similar Threads
Thread Thread Starter Forum Replies Last Post
sql server agent ahmedzakey1983 SQL Server 2005 1 February 11th, 2008 08:16 AM
server agent has timed out when exporting to pdf deepthiv Crystal Reports 0 May 17th, 2007 11:43 AM
TSQL to change SQL Server Agent Properties happygv SQL Server 2000 1 May 2nd, 2007 01:56 PM
SQL Server Agent - jobs AristotleYu SQL Server 2005 1 October 23rd, 2006 11:12 AM
SQL Server Agent for Unix akar_anand SQL Server 2000 0 March 10th, 2004 11:27 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.