如何在Sql Server 2008 R2中创建Sql Server登录？ [英] How Do I Create A Sql Server Login In Sql Server 2008 R2?

问题描述

我使用正常的Windows身份验证创建了一个数据库。



i记录并转到安全文件夹并右键单击转到新登录

输入登录名（Promod）和密码（P @ 19861030）。



和取消用户必须在下次登录时更改密码。



默认数据库应该是我的数据库。



服务器角色..我公开



用户映射

i输入我的数据库并将默认模式设置为dbo并单击确定。



然后我从服务器断开连接通过我已创建的
sql server身份验证登录。



用户名= Promod

密码= P @ 19861030



但是当我点击连接时它会给我一个错误。



无法连接PD-JANAKAN



iser'Promod'登录失败

Microsoft sql server，错误：18456

解决方

如果您收到有关错误状态的信息，这将有助于解决这个问题。无论如何，请查看此列表 http://blogs.msdn.com/ b / sql_protocols / archive / 2006/02/21 / 536201.aspx [ ^ ]。



如你所见，有很多可能出现问题但是如果你从错误信息中检查状态，你应该能够找出问题所在

i have created a database using normal windows authentication.

i logged and went to security folder and right click went to new login
entered a login name(Promod) and password(P@19861030).

and untick user must change password at next login.

default database should be my database.

in server roles.. i put public

user mapping
i entered my db and set default schema to dbo and clicked okay.

then i disconnected from the server and logged through
sql server authentication which i have created.

username = Promod
Password = P@19861030

but it will gives me an error when i click connect.

cannot connect PD-JANAKAN

login failed for iser 'Promod'
Microsoft sql server , Error: 18456

解决方案

If you received information about the error state, it would help to solve the problem. Anyhow, have a look at this list http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx[^].

As you see, there are quite a few possibilities what may have gone wrong but if you check the state from the error message, you should be able to pinpoint the problem.

这篇关于如何在Sql Server 2008 R2中创建Sql Server登录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！