on ‎2008 Oct 09 9:10 PM
Removing BUILTIN\Administrators login from SQL Server 2005 database instances is a security "best practice".
From an SAP perspective, are there any issues with doing this? Is this sanctioned by SAP?
before you remove it, make sure you have access as DB Admin without it. Otherwise, it's pretty embarassing.
after you remove it, make sure that sidadm has the correct access to the DB. The user should already be there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kevin,
Thank you for the quick response!
Any chance you can tell me what the server/database permissions shold be?
let's see, this is from my local install, the sidadm has:
DB Server Roles = Public and SysAdmin
No individual DB mappings.
Default DB = SID DB.
Excellent, thanks for your help Kevin!
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.