Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vraya
Starting Member
5 Posts |
 Posted - 2008-08-22 : 05:01:17
|
| Hello everybodyAm using SQL Server 2005 and i installed the SQL Server in Mixed Modewith userid as sa and my own password.When i establish connection in C# with asp.net. and opens the connection i get errorin page as :Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. The connection string was working fine before but now its not what may be the reason plz help meVijayaraya |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-08-23 : 08:40:24
|
| Sounds like someone's set the server back to windows authentication only. Can you check that?p.s. Don't use sa as an application login. Create a login that has the minimum rights that the application needs and use that.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Login failed for user 'sa'. Reason: Not associated