Sql身份验证失败 [英] Sql Authentication Failed

查看:117
本文介绍了Sql身份验证失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我的SQL2005是默认登录名,如sa pwd Sa125。现在我已经改为pwd Sa @ 125



我有使用sql 2005的应用程序c#。现在应用程序无法正常工作给我错误,登录失败。我已经改变了在application.config文件中。以下是配置文件

My SQL2005 Was default Login Name Like sa pwd Sa125. Now I have changed to pwd Sa@125

I had application c# using sql 2005.Now that application is not working giving me error that log in failed.I have changed in the application.config file. Below is config file

<configuration>
 <appsettings>
    add key="connectionString" value="Data Source=SYSTAM3\SQLEXPRESS;initial catalog=Export;persist security info=False;User ID=sa;Password=sa@125;" 
    add key="AppPath" value="E:\Exim\Latest EXIM Coding as on 10.11.2009" 
 </appsettings>
</configuration>



在connectionString中显示相同的pwd值?


in connectionString the value showing same pwd?

推荐答案

在连接字符串中,更改持久安全性的设置:

In your connection string, change the setting for persist security:
persist security info=True



如果这解决了您的问题,请在代码中的某处从SqlConnection实例而不是配置文件中检索连接字符串。


If this solves your problem, somewhere in your code you retrieve the connectionstring from an SqlConnection instance instead of your config-file.


这篇关于Sql身份验证失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆