如何在Windows身份验证模式下创建数据库 [英] how to create database in windows authentication mode

问题描述

frens，我打算在Windows身份验证模式下创建一个名为KECDb的数据库，但是当我要创建数据库时，我命名该数据库并使用sql Windows身份验证，但是它说在数据库主数据库中拒绝了create database权限.
在这种情况下该怎么办，请帮助您采取适当的步骤.
关于bishnu

frens, i was about to create a database called KECDb in windows authentication mode but while i was about to create it , i named the database and using sql windows authentication but it says create database permission denied in database master
what to do in such situation please help with proper steps.
with regards bishnu

推荐答案

您正在使用Windows身份验证连接到数据库.如果您以常规方式启动Management Studio Express，则该程序将不会具有创建新数据库所需的任何管理员特权.

您只需要以管理员身份运行Management Studio Express.为此:

*关闭Management Studio Express
*在开始菜单中，右键单击Management Studio Express的快捷方式，然后选择以管理员身份运行"
*如果Windows询问您是否要以管理员模式允许该程序，请说是"
*重试创建数据库

如果不起作用，还请检查以下内容:

*在安全性下，登录到SQL Server或Express->登录信息以查看是否列出了NT Authority \ Network服务
*如果未列出，请添加并确保正确
*确保在要安装到的数据库中启用用户.

祝你好运.

You are connecting to the database using Windows Authentication. If you start Management Studio Express the regular way, the program won''t have any Administrator privileges which are required to be able to create a new database.

You simply have to run Management Studio Express as administrator. To do this:

*Close Management Studio Express
*In the start menu, right-click the shortcut of Management Studio Express and select "Run As Administrator"
*If Windows asks if you want to allow the program in admin mode, say "Yes"
*Retry creating your database

if doesnt work also check this:

*Login into SQL server or Express, under Security -> Logins check to see if NT Authority\Network Service is listed
*If not listed add this and be sure to it
*Make sure you enable the User in the database you are installing to.

Good luck.

你好，

我认为最好的方法是重新安装SQL Server并确保选择Windows身份验证.



希望有帮助.
问候，
C#jnrDeveloper

Hi there,

I think the best way is to re-install SQL server and make sure you select windows authentication.



Hope that helps.
Regards,
C#jnrDeveloper

这篇关于如何在Windows身份验证模式下创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！