在数据库“master"中创建表权限被拒绝

本文介绍了在数据库“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' 角色的脚本