| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-01-03 : 10:18:16
|
| Hi Experts,If we Block access to Procedures does it effect the SQL Agent to shutdown as in 1 of my servers the agent is getting shutdown automatically.im not able to find the RCA for the same.SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this serverThank you In Advance. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-03 : 10:20:22
|
| No, it does not.--Gail ShawSQL Server MVP |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 10:29:55
|
| Hi,As i can see this message before i started the Agent in error logs.Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.After this message i can see thisSQLServerAgent service successfully started.Thank you In Advance. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-03 : 10:48:53
|
| And?You've posted an informational message and a success notification. What's the question?--Gail ShawSQL Server MVP |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 11:41:09
|
| Hi,here in the above message my SQL Agent was shutdown so i started it from SQL Config tool.so, when i was looking for RC i found this message "Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required".so, i got a doubt whether the Agent is getting shut down due to the procedure 'sys.xp_cmdshell' is blocked. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-03 : 12:07:28
|
| Have a closer look at that message:Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is requiredIt doesn't say failed, or error, or even warning and it doesn't say anything about either SQLAgent or xp_cmdshell. It's just telling you that SQL is using a particular DLL to execute a particular procedure.--Gail ShawSQL Server MVP |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 13:10:04
|
| Hi,Thank you for responding to my message. so, is there any way to find the cause of the SQL Agent shutdown and there is another scenario in which my database was unavailable I took it to offline and again brought it to online and it worked but I couldn’t find the cause why it had happened. I tried to find in event logs and error logs but it was of no use.Thank You In Advance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 14:08:30
|
| Thank you Kizer. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
SQL Agent Down