sql server agent logon failure

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sql server agent logon failure

Author

Topic

gongxia649
So Suave

344 Posts

Posted - 2007-04-26 : 11:24:56

[298] SQLServer Error: 18452, Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000]

i try to start SSA and this the msg comes up. the password is correct.
any inputs is appreciated.

Service control failure
A error 1069 (the service did not start due to logon failure)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-26 : 13:28:01

What's sql agent service account? Did you enter correct password for that account or anyone changed password?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 13:35:07

Did you supply the domain name when entering the userid in the service?

DomainName\UserId

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-26 : 14:08:14

nobody changed the password.
its not in a domanin..its in a workgroup

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 14:19:17

Log into the server using that account and password. Does it show any errors when logging in such as locked account, password expired, or incorrect password?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-26 : 15:20:49

i tried this on my laptop -- winxphome and sqlserver2005
-stopped sql server agent
-created a new profile called 'windows' password 'windows'
-sql server agent service / log on / enter username/password as windows/windows
-go back to sql server agent, press start
error: sql server agent 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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 16:58:28

What is meant by a new profile?

Are you receiving the original error on your laptop or on another machine?

For this new error, please post the corresponding error from Event Viewer.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

344 Posts

Posted - 2007-04-26 : 17:16:54

new profile= new user
on my laptop

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

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-26 : 17:20:53

Does the user have local admin?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-26 : 23:02:58

Sql agent service account has to be sql login with proper permission.

gongxia649
So Suave

344 Posts

Posted - 2007-04-26 : 23:41:27

Does the user have local admin?
yes, it's a computer administrator.