| Author |
Topic |
|
BankOfficerHere
Posting Yak Master
124 Posts |
 Posted - 2008-08-28 : 00:36:20
|
| I created a log in and password in SQL. But when I tried to log in, there's a problem on authentication. Do you know the problem?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BankOfficerHere
Posting Yak Master
124 Posts |
Posted - 2008-08-28 : 00:38:19
|
| I'm not on my workstation. But it's something with Failed Authentication when I tried to log in to Query Analyzer. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BankOfficerHere
Posting Yak Master
124 Posts |
Posted - 2008-08-28 : 00:42:54
|
| Okay Here it is:not associated with a trusted sql server connection |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 00:48:52
|
| Did you select SQL authentication when you tried to login? Is the database server setup with mixed mode authentication, remember that Windows authentication only is the default?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
BankOfficerHere
Posting Yak Master
124 Posts |
Posted - 2008-08-28 : 00:51:10
|
| Yes, I've created a new database with log in and password. Then I triled to log in with Query Analyzer. That is where I got the message:not associated with a trusted sql server connection |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BankOfficerHere
Posting Yak Master
124 Posts |
Posted - 2008-08-28 : 01:00:51
|
| yes i did select it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 01:03:04
|
| And what about the second question in that post? You can't read just half a post. Do you know what mixed mode authentication is? Do you know how to enable it?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
authentication issue