Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
来源:互联网 发布:有什么软件像初页 编辑:程序博客网 时间:2024/05/22 04:55
We are able to connect to MSSQL Server Management Studio with Windows Authentication but unable to connect with SQL Server Authentication. The 'sa' login details are correct but still getting the following error message:
In order to resolve the issue, please refer to the following steps:
1. Login to the MSSQL Server Management Studio with Windows Authentication.
2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
3. Under the Server Properties, select a page of "Security".
4. Select the Server authentication as "SQL Server and Windows Authentication mode" and click Ok.
5. Restart the SQL Services and then try to login with 'sa' details.
Hope this will help you....
- Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
- Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
- Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The st
- Trouble shooting:login failed for user 'sa' ,the user is not associated with a trusted SQL Server
- SQL SERVER sa login 18456 Error with 2012 R2 server
- Cannot open database "WWALMDB" requested by the login.The login failed Login failed for user sa
- MSSQL2005 报 Login failed for user 'sa'. 错误
- "Login failed for user 'sa'. Reason: The account is disabled.
- SSIS Hresult: 0x80040E4D Description: "Login failed for user 'sa'.
- The Error "Login failed for user"
- 消息 18456,级别 14,状态 1,第 1 行 Login failed for user 'sa'.
- Login failed for user 'username'. The user is not associated with a trusted SQL Server connection
- Login failed for user 'Tester'. Reason: Not associated with a trusted SQL Server connection.
- Login failed for user ''.Reason:Not associated with a trusted SQL Server connection.
- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
- SQL Server 2008 R2 error: sa 18456
- 用户 'sa' 登录失败。 (Microsoft SQL Server,错误: 18456)
- 用户sa登陆失败 microsoft sql server 错误18456
- ecmall 的二次开发
- 延长处理对python性能的影响
- vpn + route 路由实现 工作娱乐两不误 ~
- C# 用Linq的方式实现对Xml文件的基本操作(创建xml文件、增删改查xml文件节点信息)
- ExtJS 动态添加checkboxgroup
- Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
- XML转义字符
- 初来乍到
- 曹冲秤象新解
- DL104规约小结
- ie6下的iframe,问题多多
- Asp.Net调用Office组件操作时的DCOM配置
- 在英文操作系统上处理韩文
- 设置路由表,让vpn分别走本地和国外线路