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.
3
-
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 KhanCommented Mar 1, 2015 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 MosesCommented Mar 1, 2015 at 14:06
-
Also see dba.stackexchange.com/a/49680– Aaron BertrandCommented Mar 1, 2015 at 14:38
Add a comment
|