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:03:28
|
| 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 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-12-08 : 09:39:26
|
| Can you post your connection string for both examples? |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-12-08 : 09:42:06
|
| Hi,The is no connection string.I basically go to the query analyser and can indeed logon to the local machine using windows authentication but can not log on when I enter a username and password using sql authentication |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-12-08 : 10:10:38
|
| Maybe you are providing the wrong credentials (username+password).Or the server only uses windows authentication, and not mixed authentication.select serverproperty('IsIntegratedSecurityOnly')rockmoose |
|
|
|
|
|
|
logon