SQL Server 2008 – Administrator account denied access or locked out
I don’t know how many times my clients have given me administrator access to the SQL Server machine thinking I will automatically have access to administer the SQL Server. However, in SQL Server 2008 and above (i.e. SQL Server 2008 R2), there is a new security feature where the installer doesn’t automatically add the local server administrators group as SysAdmin on the server. The person doing the install has to remember to do this during setup. Most of the time,…