November 5, 2008 at 11:01 pm
hi all,
its audit time here and i am really getting screwed.
the sql service account (mssqlserver and sql server agent ) uses the domain account for startup.
this account has been given sa rights and has access to all the d/b.
now the auditor is saying that since the n/w administrator ahs this domain password he can just login directly to the m/c and conenct to the d/b and play with it. he wants me to restrict this access for n/w administrators.
i tried jsut on trial basis denying permission for this account (security-login tab. authentication -deny access). but then sql services do ot start. is there any way i can restrict this kind of access.
thanks for your help.
November 6, 2008 at 10:44 am
I think you would have to have the Network admin setup the account and allow you to change the password so only you have it. This is a common issue.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply