数据库连接问题 [英] Problem in database connection

问题描述

当我试图打开我的数据库时出现错误无法打开数据库... [数据库路径] ..登录请求。登录失败。登录失败，用户'user-pc\user'。



SHOUTING已删除 - OriginalGriff [/ edit]

解决方案

有两种方法对SQL服务器的身份验证 [ ^ ];

1. Windows身份验证 - 是默认设置，通常称为集成安全性，因为此SQL Server安全模型与Windows紧密集成。特定的Windows用户和组帐户受信任登录到SQL Server。已经过身份验证的Windows用户不必提供其他凭据
2. 混合模式 - 支持Windows和SQL Serve的身份验证r。在SQL Server中维护用户名和密码对

您没有指定您选择的方法类型。 />


运行 MS SQL Server Management Studio [ ^ ]并进行检查。根据这些设置，设置正确的连接字符串 [ ^ ]。



如需了解更多信息，请参阅：

关于配置SQL Server身份验证模式的建议和指南 [ ^ ]

选择身份验证模式 [ ^ ]

更改服务器身份验证模式 [ ^ ]

when i tried to open my database an error occur "cannot open database...[database path].. requested by the login. login failed.login failed for user 'user-pc\user'.

[edit]SHOUTING removed - OriginalGriff[/edit]

解决方案

There are 2 ways of authentication to the SQL server[^];

1. Windows authentication - is the default, and is often referred to as integrated security because this SQL Server security model is tightly integrated with Windows. Specific Windows user and group accounts are trusted to log in to SQL Server. Windows users who have already been authenticated do not have to present additional credentials
2. Mixed mode - supports authentication both by Windows and by SQL Server. User name and password pairs are maintained within SQL Server

You did not specify what kind of method you have chosen.

Run MS SQL Server Management Studio[^] and check it. Depending on these settings, set proper connection string[^].

For further information, please see:
Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server[^]
Choose an Authentication Mode[^]
Change Server Authentication Mode[^]

这篇关于数据库连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！