如何将用户添加到SQL Server 2008 Management Studio [英] How to add users to SQL Server 2008 Management Studio

问题描述

我正在尝试安装DotNetNuke CMS.我在安装Microsoft Visual Studio 2010之后安装的Microsoft SQL Server Management Studio 2008中创建了一个数据库.我为其创建了登录名和密码，但无法登录.

I am trying to install DotNetNuke CMS. I created a database in my Microsoft SQL Server Management Studio 2008, which I installed after installing Microsoft Visual Studio 2010. I created a login for it and a password but I am not able to log in.

这使我的SQL登录失败18456.我已经尝试了该站点和许多其他站点中存在的帖子，但是我无法登录.

It is giving me SQL login failed 18456. I have tried the post that exist in this site and many different sites but I am not able to log in.

我需要更新到SQL Server 2008吗?

Do I need to update to SQL Server 2008?

推荐答案

首先，您需要更改登录类型以允许sql安全登录(否则，您必须开始弄乱Domain用户帐户).

Firstly you need to change the type of login to allow sql security login (otherwise you have to start messing with Domain user accounts).

要执行此操作，请转到服务器名->右键单击属性"->转到左侧的安全"选项卡->选择"Sql Server和Windows身份验证模式"

To do this go to servername --> right click 'properties' --> go to security tab on left hand side --> choose 'Sql Server and Windows Authentication mode'

然后.....

要设置用户，您需要设置他们:

To set up users you need to set them up:

1)作为登录名 2)作为数据库中的用户.

1) as a login 2) as a user in the database.

为此，请转到服务器名称(在Management Studio中)->安全性->登录名，然后右键单击新登录名".

To do this go to server name (in Management Studio) --> security --> logins then right click 'new login'.

然后转到数据库->您的数据库->安全性->用户->添加用户.

Then go to databases --> your db --> security --> users --> add user.

然后，您只需要添加选择椭圆的用户并添加刚刚在上面创建的用户即可.

Then you just need to add the user selecting the elipses and adding the user you just created above.

这篇关于如何将用户添加到SQL Server 2008 Management Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！