在数据库主sql server 2008中创建权限被拒绝,错误:262 [英] create permission denied in database master sql server 2008 , Error:262
本文介绍了在数据库主sql server 2008中创建权限被拒绝,错误:262的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,
我的系统中安装了SQL Server,是使用Windows身份验证登录。
但是当我尝试创建数据库或者尝试运行脚本它给出错误为:在数据库主sql server 2008中创建权限被拒绝,错误:262
请提出任何建议。
Hello,
I a have SQL Server installed in my system , is am using windows authentication to login in .
But when ever my trying to create a database or try runing script it gives Error as: create permission denied in database master sql server 2008 , Error:262
Any suggestions please.
推荐答案
你需要为你的用户(或所有用户)提供创建权限 - 看起来你现在还没有这样做。
麻烦的是你可能需要以系统管理员身份登录,以便为自己提供所需的权限!
打开SSMS,并以管理员身份登录:您可能已经保留了默认管理员,因此'用户'sa ,密码为空。
打开树的安全分支,然后双击您的PC /用户组合。更改角色以包括sysadmin并保存。
当你在这里时,将sa密码更改为更安全的东西!
你现在应该能够从您通常的登录中创建一个数据库。
You need to give create permissions your user (or all users) - it looks like at present you haven''t done that.
The trouble is that you probably need to log in as a sysadmin in order to give yourself the required authority!
Open SSMS, and login as an administrator: you have probably left the default admin in place, so that''s user "sa", password blank.
Open the "Security" branch of the tree, and double click your PC/User combination. Change the Roles to include sysadmin and save.
While you are here, change the sa password to something a little more secure!
You should now be able to create a DB from your usual log in.
这篇关于在数据库主sql server 2008中创建权限被拒绝,错误:262的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文