你需要添加一个服务器登录:

You need to add a server login:

1. 使用 SSMS 作为 sa 连接到您的 SQL Server.
2. 在 SSMS 的 Object Explorer 窗格中深入了解服务器的 Security 文件夹.
3. 右键单击服务器的 Security > Logins 文件夹，该文件夹出现在 Object Explorer 中.
4. 在出现的上下文菜单中单击 New Login....
5. 在打开的登录 - 新建对话框中提供新登录的详细信息 - 特别是其常规、服务器角色和用户映射 页面(沿左侧).(请参阅每个页面的屏幕截图以及答案底部的示例输入.)

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 实例.将新登录名映射到 数据库用户(在 Login - New 对话框的 User Mappings 页面中)将在映射数据库中创建新用户尚不存在；或者，您可以将新登录名映射到现有数据库用户.

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.

或

或