在 SQLServer 中创建用户后无法登录

我的问题是，在创建用户之后，我无法登录到 SQLServer。用户创建成功，因为新用户被列在 security/login 下。

如何解决这个问题? ? ？

用户“ sims”登录失败。该用户与 可信的 SQL 服务器连接(Microsoft SQL Server，错误: 18452)

77386 次浏览
小开
最佳答案

Try setting your authentication mode to mixed mode. Your server does probably not accept logins using sql server accounts.

  1. Open properties
  2. Go to "Security"
  3. Select "SQL Server and Windows Authentication mode"
小开

SQL Server was not configured to allow mixed authentication. Here are steps to fix:

  1. Right-click on SQL Server instance at root of Object Explorer,
  2. click on Properties.
  3. Select Security from the left pane.
  4. Select the SQL Server and Windows Authentication mode radio button, and
  5. click OK.
  6. Open up Services and restart the SQL Service (SQLEXPRESS) Windows service.
小开

Right click Server for properties...

enter image description hereproperties


提交答案