Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2005-05-23 : 17:47:35
|
| Hi!I am making some testes doing replication, between a Server with SQL Server 2000 and my computer that have SQL Server 2000 too.I got the next error from my computer:SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'SQL_SMART' 5- (Acess is dennied)So I went to the server and checked the SQL Server Agent and it was Stop, I try to started it and the server send me the next message:SQL Server AgentError:The server did not start due to a logon failure.An error 1069- (The service did not start due to a logon failure) occured while performing this service operation on the SQLServerAgent service.We restore the server to see if the SQL Server Agent start and it didn't.I really don't have an idea about how can do to solve this.I didn't install this server.Thanks for you help! |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-23 : 17:54:53
|
| I hope you are running sql server on windows authentication mode. Check whether you have administration previlleges on your machine or not.If you have admin previlleges on your machine then you can start the service.If any queries, feel free to .....With RegardsSreenivas Reddy B |
 |
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2005-05-23 : 19:16:01
|
| Yes I am running sql server on windows authentication modeand Yes I have administration previlleges on my computer and on the server too, but I still can't do that SQL Server Agent runs.I don't know if this matters but they change the Administrator password of the Windows user on the server, I already read and do what said here, but with our successhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q282254Another strange thing is that the SQL Server is running |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-23 : 20:26:04
|
| Start the SQL Server Agent as a local service, then again with the windows account you have been trying to use. Is the SQL Server service running under the exact same account? Can you login to a server or PC using the username and password?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2005-05-23 : 20:31:12
|
| I got it!! I did what said on the link that I mention but instead of doing that on the MSSQLSERVER I do it for the SQLSERVERAGENT, and finally it work.What I was doing was to change the password of the SQL Server instead of the SQL Server Agent password.Thanks a lot!!! |
|
|
|
|
|
|
Can't start SQL Server Agent