谁能帮我。我是.net的新手。我收到此错误 - 在数据库'master'sql server 2005中创建数据库权限被拒绝 [英] can any one help me. I'm new to .net. i'm getting this Error - create database permission denied in database 'master' sql server 2005

问题描述

任何人都可以帮助我。我是.net的新手。我得到这个 - 在数据库'master'sql server 2005中创建数据库权限被拒绝

can any one help me. I'm new to .net. i'm getting this - create database permission denied in database 'master' sql server 2005

推荐答案

错误信息非常自我解释：创建数据库权限在数据库'master'中被拒绝

您已连接到SQL的用户无权创建数据库。您需要使用适当的权限创建或使用其他用户帐户。如果您不知道任何其他用户帐户，请与您的DBAdmin交谈，他会将您排除在外。

The error message is pretty self explanatory: "create database permission denied in database 'master'"
The user you have connected to SQL with does not have permission to create a database. You need to either create or use a different user account, with the appropriate permissions. If you don't know any other user accounts, then talk to your DBAdmin and he will sort you out.

如果您不这样做，请转到Microsoft Sql Server Management Studio（SSMS）如果您在 [下载部分]并安装相应的版本。

当您使用管理员帐户打开Sql Server Management Studio时，您将获得左侧服务器的名称和文件夹列表。

转到安全文件夹，然后转到Login文件夹。当您右键单击登录文件夹时，您可以选择在具有现有登录名的文件夹中创建新的登录。每次登录，您可以右键单击菜单中的属性选项，您将获得该特定登录的所有选项，并且您可以在该位置为该登录授予dbcreator（服务器范围安全性）权限。请注意，必须在用户映射中选择正确的数据库，并且所有其他设置必须正常，但为此，您必须查看左窗格中的所有页面都列出的不同页面。

Go to Microsoft Sql Server Management Studio(SSMS) , if you don't have this tool installed you can get it at the website of Microsoft when you do a search for it in the [downloads section]and install the appropriate version.
When you open the Sql Server Management Studio with your administrator account you get the name of your server on the left side and a list of folders.
Go to the security folder and inside that the Login folder. When you right click on the Login Folder you have the option to create a new Login, within the folder you have the existing Logins. Per Login you can go with right click to the properties option in the menu and you get all the options for that specific login and that's where you can grand the dbcreator (server wide security) privileges to that Login. Be aware that the right database must be selected in the user mappings also and all other settings must be ok but for that you have to look at the different pages in the left pane were all pages are listed.

这篇关于谁能帮我。我是.net的新手。我收到此错误 - 在数据库'master'sql server 2005中创建数据库权限被拒绝的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！