SQL security is different, is the builtin Admin denied some rights in SQL Management Studio?
Sent from my Blackberry, which may be an antique but delivers email RELIABLY -----Original Message----- From: Graeme Carstairs <[email protected]> Date: Thu, 25 Apr 2013 11:03:13 To: NT System Admin Issues<[email protected]> Reply-To: "NT System Admin Issues" <[email protected]>Subject: When is a domain admin not a domain admin Hi, I hvae inherited a site, that was once SBS 2003 and is now SBS 2008. The *domain\*administrator account appears to have full access ot all servers, pc's etc as expected But If I set-up another user account with the exact same group membership as the *domain\* administrator account it doesn't Whilst you can install software etc, there are somethings you cant do, like running SQL scripts ont here SQL server. Install certain software that makes unusual changes to the registry, like there is one type of permission or group memebership blocked. e.g. Sage 200 Client installing as *domain\*administrator then no problem, but installing as a copied account *domain*\admin2 it fails and the Sage support shows that it is being denied access to the registry. Also WSUS, detaching the database to copy to another drive and reattach, using admin2 detach works and you can move it but it wont attach as permissions failure,* *domain*\administrator * it works fine. I have looked htrough the GPOS etc and made sure they were members of the same groups but cannot see anyreason why. This is across all client PC's and Servers.. -- Good news everyone, you have just received an e-mail from me! ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
