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 |
|
decapolo
Starting Member
15 Posts |
 Posted - 2006-03-29 : 00:44:15
|
| Please suggest the error message: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connectionregardz,sAm |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2006-03-29 : 01:51:22
|
| Its because you are using Windows authentication mode. You need switch to mixed authentication mode.To change the authentication mode from Windows Authentication to Mixed Mode, use either of the following steps:Using the SQL Enterprise Manager:1.) Expand a Server group.2.) Right-click a server name, and then click Properties.3.) Click the Security tab.4.) Under Authentication, click the SQL Server and Windows option button.5.) Restart SQL Server in order for the change to take effect.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 01:56:38
|
"trusted SQL Server connection" = Windows Authentication ModeIs your SQL Server set to Mixed or Windows Authentication Mode ?Also check your connection string used in your front end application.Is there a "Trusted_Connection=yes"Sample from http://www.connectionstrings.com/Standard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"Trusted connection:"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-29 : 09:14:11
|
| where do you get this error? describe the scenario.lots of reasons for this type of error--------------------keeping it simple... |
|
|
|
|
|
|
Trusted SQL Server Connection