My previous system administrator created a SQL Server 2008 instance on my local machine with his domain User. Now, I cannot create, delete, or view any databases or tables on that instance. Even with my domain User, or Windows local administrator. It says "CREATE DATABASE permission denied in master". The users section in Management studio shows only two users 'BUILTIN\Users' and 'sa' which is disabled. 'Builtin\Users' has only public role. It seems no user have permission to this instance. How can my Local Administrator get permission to it ? I cannot delete the instance as it has important databases.
Asked
Active
Viewed 38 times
0
-
No need to Delete the database instance. If any one database user have 'sysadmin' permission or 'sa' admin can change 'Buitin\Users' password. – Md Haidar Ali Khan Mar 01 '15 at 13:52
-
no user have sysadmin permission. SA is disabled, and I cannot enable it because of the permission issue. Even sa doesn't belong to sysadmin. – Yesudass Moses Mar 01 '15 at 14:06
-
Also see http://dba.stackexchange.com/a/49680 – Aaron Bertrand Mar 01 '15 at 14:38