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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-12-08 : 09:13:50
|
| I can log on to the local query analyser using windows authentication but can not log on using sql server authentication (using the username and password that I added to the local machine)The error message is: not associated with a trusted sql server connection.How can i solve this please?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-08 : 16:29:51
|
| So did you add the account to SQL Server or just to the local machine inside Computer Management? And did you specify SQL authentication on connect? Also, are you using mixed mode authentication? It is not the default setting.Tara |
 |
|
|
|
|
|
connection to sql server 2000