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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-19 : 12:22:39
|
| Ihsan writes "dear sql teamI have sql server 2000 and my operating system windows 2000 advanced server when i try to connect to the sql using sql server authenticationwith a user name sa and password it fail and give me a message log in failed with user sa reason not associated with sql server connection kindly I know my password is correct and when i connect using windows authentication it connect but it is very slow in addation to i have a machine with a suitable rams and processor pls tell me whats the problembest regardsIhsan Jaafar" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-06-20 : 03:01:00
|
| Are you sure it doesn't say "...Not associated with a trusted connection"?Make sure SQL is in mixed security mode.-Chad |
 |
|
|
Ihsan
Starting Member
1 Post |
Posted - 2002-06-22 : 03:39:10
|
quote:
Are you sure it doesn't say "...Not associated with a trusted connection"?Make sure SQL is in mixed security mode.-Chad
the message is "login failed for user sa reason not associated with a trusted sql server connection" but how can i be sure sql server is in amixed security mode |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-22 : 04:20:16
|
| In Enterprise Manager, right click on the server name, click on Properties, go to Security tab. Select the radio box "SQL Server and Windows NT" under authentication.Restart your SQL Server--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
about sql server connection