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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2004-04-06 : 02:51:03
|
| Hi all,I am facing a very strange problem. while connecting SQL throught login name 'sa', I am getting following messageUnable to connect to serverServer Msg. 18452, level 16, state 1[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.While I am able to connect through 'Use windoes NT authentication'Since this is important. Waiting for reply ASAP.Thanks in advance. |
|
|
MuadDBA
628 Posts |
Posted - 2004-04-06 : 08:32:49
|
| What version of SQL Server?Looks like you are trying to login under mixed mode secuirty or something, instead of SQL server authentication. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-06 : 12:25:24
|
| I think that SQL Server was installed to only allow Windows Authentication. You have to allowed mixed mode in order to be able to use SQL authentication. Right click on your server in Enterprise Manager, go to properties then to security tab. Select mixed mode authentication.Tara |
|
|
|
|
|
|
Sql Login problem