March 10, 2008 at 5:20 pm
Just add the app login in as a specific Widnows login. Then authorize it in SQL server for what it needs.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2008 at 5:28 pm
Thanks for your reply.
When you mean "add as a specific Windows login", do you mean just use another windows login as the app login to SQL 2005?
In this regard, I don't think I have a choice to change the app login used. I am forced to use this login and, unfortunately, it has to maintain its membership in the Windows local admin group.
March 10, 2008 at 6:16 pm
No, just add that Windows Account as a Login on your SQL server.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 10, 2008 at 6:23 pm
Yes, I think I've got it now...:)
Even if the "Builtin\Administrators" group is completely deleted from SQL 2005, I can still add this specific Windows login to SQL 2005 (even if it has local admin membership) --> I tried it and it seems to work.
With regard to using the Local System Account to run the SQL services, will there be any adverse effects if I remove the Builtin\Adminstrators group from SQL 2005 (with the idea being System accounts are also members of the Windows Administrators group by default)? By the way, "NT AUTHORITY\SYSTEM" has sysadmin access in the SQL 2005 database (installed by default).
Thanks for your help.
March 10, 2008 at 6:44 pm
Glad I could help.
(sorry, don't know about your other question)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply