Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLSERVERAGENT Expand / Collapse
Author
Message
Posted Monday, March 3, 2008 1:18 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
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 ....


Post #463410
Posted Monday, March 3, 2008 2:31 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
check this.

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


SQL DBA.
Post #463440
Posted Monday, March 3, 2008 3:27 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
Based on your error message, I would like to say you may need to restore your registry or re-install your SQL Server.
Post #463463
Posted Monday, March 3, 2008 6:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:05 PM
Points: 2,644, Visits: 824
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
Post #463510
Posted Tuesday, March 4, 2008 1:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
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...:) Thanks again.
Post #464072
Posted Thursday, June 5, 2008 2:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 9:44 AM
Points: 20, Visits: 245
THANKS FOR THIS ARTICLE. THIS FIXED MY ISSUE............
Post #512497
Posted Saturday, May 12, 2012 9:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 28, 2012 1:42 AM
Points: 2, Visits: 119
how did you fixed the issue?
Post #1299204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse