首先，您需要更改登录类型以允许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.