无法登录到SQL Server 2008 R2 Management Studio中的服务器 [英] Unable to log in to server in SQL Server 2008 R2 Management Studio

问题描述

我有一个SQL Server 2008 R2实例，可以使用sa用户登录.但是我想定义另一个用户(administrator)来使用SQL Server Management Studio登录，因此我执行了以下操作:

I have a SQL Server 2008 R2 instance and can log in using the sa user. But I want to define another user (administrator) to log in with SQL Server Management Studio, so I did the following:

• 以sa身份登录Management Studio中的服务器.
• 右键单击数据库名称.
• 单击属性.
• 然后在允许的情况下，我选择所需的用户名(administrator).
• 我授予他所有许可.

• Logged in to the server in Management Studio as sa.
• Right clicked on the database name.
• Clicked on properties.
• Then under permission, I select the required username (administrator).
• And I grant him all the permission.

但是当我尝试使用administrator登录时，出现以下错误:

But when I tried to log in using administrator, I got the following error:

用户管理员"错误18456登录失败.

Login failed for user "administator" Error 18456.

任何人都可以建议出什么问题吗?

Can anyone advise what might be the problem?

推荐答案

您需要添加

You need to add a server login:

1. 使用sa的SSMS连接到SQL Server.
2. 在SSMS的 Object Explorer 窗格中钻入服务器的 Security 文件夹.
3. 右键单击出现在对象资源管理器中的服务器的安全> 登录文件夹.
4. 在出现的上下文菜单中单击新登录... .
5. 在打开的 Login-New 对话框中提供新登录的详细信息-尤其是其 General ，服务器角色和用户映射页面(沿左侧). (请参阅每页的屏幕截图，并在答案的底部输入示例.)

1. Connect to your SQL Server with SSMS as sa.
2. Drill into the server's Security folder in SSMS's Object Explorer pane.
3. Right-click on the server's Security > Logins folder that appears in Object Explorer.
4. Click on New Login... in the context menu that appears.
5. Provide details of the new login in the Login - New dialog that opens - particularly its General, Server Roles, and User Mappings pages (along the left). (See the screenshots of each page with sample input at the bottom of the answer.)

您可能需要根据需要添加数据库用户，但是必须使用服务器登录名(例如sa登录名)才能使用Windows或SQL Server身份验证连接到SQL Server实例.将新的登录名映射到 数据库用户 (在登录-新建"对话框的"<用户>映射"页面中)，如果您指定的用户名还不存在或者，您可以将新登录名映射到现有的数据库用户.

You may need to add a database user depending on your needs, but a server login (like your sa login) is necessary to connect to the SQL Server instance using Windows or SQL Server authentication. Mapping the new login to a database user (in the Login - New dialog's User Mappings page) will create a new user in the mapped database if you specify a username that does not already exist; alternatively you can map the new login to an existing database user.

另一个SO问题谈到服务器登录名和数据库用户之间的区别.

Another SO question speaks to the differences between server logins and database users.

或

或

这篇关于无法登录到SQL Server 2008 R2 Management Studio中的服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！