在数据库“master"中创建表权限被拒绝 [英] create table permission denied in database 'master'
问题描述
我已经在我的电脑上安装了免费版的 sql server 2008(sql server management studio express edition).安装后出现以下错误
I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After installation I get the following error
create table permission denied in database 'master'
我尝试了多次重新安装,但始终出现相同的错误.当我检查
I tried reinstalling several times, but I keep getting the same error. When i checked
select user_account();
它显示我以访客身份登录.我该如何解决这个问题?因为我不允许创建新的登录名.
It showed that I was logged in as guest. How do I solve this? since I am not permitted to create a new login.
推荐答案
我读到错误可能是由 UAC 引起的(在旧版本的 SQL Server Express 上).尝试右键单击 SQL Studio 并以管理员身份运行.
I've read the error can be caused by UAC (on older versions of SQL Server Express). Try right-clicking on SQL Studio and running as administrator.
如果这不起作用,这里应该有针对同一问题的修复程序.可能值得一试.
If that doesn't work there's supposedly a fix here for the same issue. Probably worth a try.
将当前用户添加到 SQL Server 'sysadmin' 角色的脚本
这篇关于在数据库“master"中创建表权限被拒绝的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!