Sql身份验证失败 [英] Sql Authentication Failed
本文介绍了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屋!
查看全文