Yes, I am logged on as a local windows admin and sql admin as well.

And I am going to reinstall the tools, but by the way, I at this moment...

Nothing fancy related to sql server manager that I can find....

Nope, still no luck after restarting the Windows Management Instrumentation. Any other ideas?

More input regarding the same issue, if I try to create a test database on this X:\SQL\ folder, I get error message:

"CREATE FILE encountered operating system error 5(Access is denied.)...

Thanks for the heads-up,mate.

Now the problem is sovled and the...

Double checked, all sub-dirs inherited the full control privilege.

Always the configuration manager, any other thoughts?

Thanks very much Judy for helping learning some new stuff.

However I just realized that the server I want to trace is version 2000. Is there a similar feature like this...

Shouldn't this topic be taken off already? SP4 has been release quite a time ago.

Great thanks for your contribution.

But my question is that I want to see who and when tried to backup my databases by using T-SQL command "Backup database..." and failed. It...

Schadenfreude-Mei (1/27/2011)

---

sqlapprentice (1/27/2011)

---

sgodrich (1/27/2011)

---

I just solved the same problem on our servers by running (the now depreciated but still accepted) command:

netsh firewall set service RemoteAdmin enable

From a command prompt set...

Not an expert on windows, but the same account you connect through...

sgodrich (1/27/2011)

---

I just solved the same problem on our servers by running (the now depreciated but still accepted) command:

netsh firewall set service RemoteAdmin enable

From a command prompt set to run...

I agree that this is a region setting issue, because I've tested if I use my own account to run the sql server agent and execute this the SSIS job,...

Hopefully my solution can help people that would have the same issue and start searching on this site or google.