无法为用户创建SQL Server Express登录-登录失败

I have created a new login for SQL Server Express as follows:

我为SQL Server Express创建了一个新的登录:

USE [master]
GO
CREATE LOGIN [Test] WITH PASSWORD=N'SF#$%GD%^J675JFS4fds' 
    MUST_CHANGE, 
    DEFAULT_DATABASE=[master], 
    CHECK_EXPIRATION=ON, 
    CHECK_POLICY=ON
GO

ALTER SERVER ROLE [sysadmin] ADD MEMBER [Test]
GO

USE [master]
GO

CREATE USER [Test] FOR LOGIN [Test]
GO

USE [master]
GO

ALTER ROLE [db_securityadmin] ADD MEMBER [Test]
GO

When I try to connect via the Test login, I receive the error message that

当我尝试通过测试登录连接时，我收到了错误消息

Login failed for user 'Test'

用户“测试”登录失败

1 个解决方案

#1

I needed to configure the server for SQL Server and Windows Authentication Mode.

我需要为SQL server和Windows身份验证模式配置服务器。

1. Open SSMS.
2. 开放的地对地导弹。
3. Connect to the server via Windows Authentication.
4. 通过Windows身份验证连接到服务器。
5. Right click the server and choose Properties.
6. 右键单击服务器并选择属性。
7. Change to "SQL Server and Windows Authentication Mode"
8. 更改为“SQL Server和Windows身份验证模式”

See also: http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456

参见:http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft + SQL + Server&EvtSrc = MSSQLServer&EvtID = 18456