Just making sure I understand the first question, I did do a restart after I changed the service account to the domain account. If I create a batch file that...

It's currently using the domain account with domain admin rights that I mentioned earlier. I also just doubled checked to see if Domain Admins was setup in the local admin...

I've looked at that from all angles and it's almost like the accounts don't have rights, even...

Rudy Panigas (11/3/2009)

---

Wow! I was not expecting this article to generate so much discussion. I would like to thanks everyone for your comments and help

John, big thanks to you for...

john.vanda (11/3/2009)

---

This happens if you don't want your outsourced IT Dept. seeing accounting data, such as payroll. SQL Server single user mode must use a separate set of permissions that,...

This happens if you don't want your outsourced IT Dept. seeing accounting data, such as payroll. SQL Server single...

harriga.rabie-1008938 (11/3/2009)

---

this way is not good, because yoiu dont have the permission to connect just with sqlcmd -E, this way is not excat.

You must add your login to local group...