Windows管理员没有SQL Server权限 [英] Windows Administrator doesn't have permission on SQL Server

问题描述

我以前的系统管理员在我的本地计算机上使用他的域User创建了一个SQL Server 2008实例。

现在，我无法创建，删除或查看该实例上的任何数据库或表。即使使用我的域用户或Windows本地管理员。

它说在master中拒绝CREATE DATABASE权限。

Management studio中的用户部分仅显示两个用户'BUILTIN \Users'和'sa'被禁用。 'builtin \Users'只有公共角色。

似乎没有用户拥有此实例的权限。我的本地管理员如何获得它的许可？

我无法删除实例，因为它有重要的数据库。

谢谢

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.
Thanks

推荐答案

为了能够创建新数据库，您需要在MS SQL Server上拥有适当的权限。请参阅：

在数据库'master'中拒绝CREATE DATABASE权限 - 我的修复 [ ^ ]

在SQL服务器上设置用户帐户 [ ^ ]

To be able to create new database you need to have proper permissions on MS SQL Server. Please, see:
CREATE DATABASE permission denied in database ‘master’ – My Fix[^]
Set up a user account on a SQL server[^]

将服务帐户登录更改为本地系统帐户并重新启动sql服务，它可以解决您的问题

Change the service Account logon to local system Account and restart the sql services, it may solve your problem

这篇关于Windows管理员没有SQL Server权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！