SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLSERVERAGENT


SQLSERVERAGENT

Author
Message
Sponge-592981
Sponge-592981
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 223
Fellow collegues,

I can not restart my sql server agent. I check the sql logs and nothing, however there are a series of application logs that suggest regesitry and .dll files are not there or can not be read. I will include all of the errors and informational messages I think is pertinent. I have checked online and checked and checked and can not find anything concrete. Please Please Please if you have seen this error provide as much as detalied information to resolve it.
FYI: I am starting this service with the same start up account id as for SQL Server Services. I tested the login and it logins in successfully through terminal services and is included ofcourse in the local administrator group.

Application logs indicate the following error:

Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Disk
Event ID: 102
Date: 3/3/2008
Time: 11:32:21 AM
User: N/A
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 102 ) in Source ( SQLSERVERAGENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..


Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Disk
Event ID: 103
Date: 3/3/2008
Time: 11:32:21 AM
User: N/A
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 103 ) in Source ( SQLSERVERAGENT ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Unable to connect to server '(local)'; SQLServerAgent cannot start.


Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1000
Date: 3/3/2008
Time: 10:49:51 AM
User: NT AUTHORITY\SYSTEM
Computer: LBMKT1QASUNWH
Description:
Windows cannot unload your registry file. If you have a roaming profile, your settings are not replicated. Contact your administrator.

DETAIL - Access is denied. , Build number ((2195)).


Event Type: Information
Event Source: MSSQLSERVER
Event Category: Disk
Event ID: 17055
Date: 3/3/2008
Time: 10:22:26 AM
User: SUNAMERICA-LA\rrahyab
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 8128, Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.
.
Data:
0000: c0 1f 00 00 0a 00 00 00 À.......
0008: 0e 00 00 00 4c 00 42 00 ....L.B.
0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.
0018: 51 00 41 00 53 00 55 00 Q.A.S.U.
0020: 4e 00 57 00 48 00 00 00 N.W.H...
0028: 07 00 00 00 6d 00 61 00 ....m.a.
0030: 73 00 74 00 65 00 72 00 s.t.e.r.
0038: 00 00 ..


Event Type: Information
Event Source: MSSQLSERVER
Event Category: Disk
Event ID: 17055
Date: 3/3/2008
Time: 10:17:00 AM
User: SUNAMERICA-LA\rrahyab
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 8128, Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'.
.
Data:
0000: c0 1f 00 00 0a 00 00 00 À.......
0008: 0e 00 00 00 4c 00 42 00 ....L.B.
0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.
0018: 51 00 41 00 53 00 55 00 Q.A.S.U.
0020: 4e 00 57 00 48 00 00 00 N.W.H...
0028: 07 00 00 00 6d 00 61 00 ....m.a.
0030: 73 00 74 00 65 00 72 00 s.t.e.r.
0038: 00 00 ..


Event Type: Information
Event Source: Horizon RCC
Event Category: None
Event ID: 1
Date: 3/3/2008
Time: 7:53:59 AM
User: N/A
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 1 ) in Source ( Horizon RCC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: MonoSphere Storage Horizon collection being performed from host WHPWMSPHERE1.


Event Type: Information
Event Source: MSSQLSERVER
Event Category: Disk
Event ID: 17177
Date: 3/3/2008
Time: 12:00:57 AM
User: N/A
Computer: LBMKT1QASUNWH
Description:
The description for Event ID ( 17177 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 1928, 2/29/2008 11:54:44 PM, 3/1/2008 7:54:44 AM.
Data:
0000: 19 43 00 00 0a 00 00 00 .C......
0008: 0e 00 00 00 4c 00 42 00 ....L.B.
0010: 4d 00 4b 00 54 00 31 00 M.K.T.1.
0018: 51 00 41 00 53 00 55 00 Q.A.S.U.
0020: 4e 00 57 00 48 00 00 00 N.W.H...
0028: 00 00 00 00 ....
w00t
SanjayAttray
SanjayAttray
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7257 Visits: 1619
check this.

http://www.sqlservercentral.com/Forums/Topic191440-9-1.aspx#bm191839

SQL DBA.
SQL ORACLE
SQL ORACLE
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12137 Visits: 1314
Based on your error message, I would like to say you may need to restore your registry or re-install your SQL Server.
thecosmictrickster@gmail.com
thecosmictrickster@gmail.com
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6308 Visits: 940
So when was it last running? Any ideas as to why it stopped running? Hint: what changed?

Presumably SQL Server is running. Can you connect to any of the databases?

I had a similar experience recently (dev server thank goodness). Someone came around and said they couldn't connect to a DB. I tried logging in and got a message that the default DB couldn't be opened - disturbing as 'master' was the default db for that login. Found out the data drive had ran out of space. Freed up some disk space, restarted SQL Server, all go.



Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Sponge-592981
Sponge-592981
Mr or Mrs. 500
Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)Mr or Mrs. 500 (503 reputation)

Group: General Forum Members
Points: 503 Visits: 223
Hey Guys,

Thanks alot for your feeback I really appreciate it. I talked to Info Sec regarding the roaming profile and they said it usually happens on unsuccessful logins. I said ok , so I go and try logging in under "What I thought was being used as the start up account" and I logged on successfully.

Finally! We noticed that the builtin\administrator group was removed because we had no control on who is local admin on the servers so the id was not being authenticated. We noticed that there has been obviously a change and we added the account back in and changed the start up account unders sql agent and it worked fine.

WAIT !! KEEP READING.....

SQL Agent is working fine now but why was sql server still running before then? It uses the same login ....Twlight Zone!

Another time another dollar...Smile Thanks again.
Sam77
Sam77
SSC Veteran
SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)

Group: General Forum Members
Points: 236 Visits: 330
THANKS FOR THIS ARTICLE. THIS FIXED MY ISSUE............
agstech
agstech
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 125
how did you fixed the issue?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search