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 |
|
mamdy
Starting Member
3 Posts |
 Posted - 2008-07-23 : 12:40:05
|
| I am using SQL server 2005 express with windows vista home premium. I create a Login using following procedure: Security > Logins >Right Click> New LoginI choose a Login Name and select the “SQL Server authentication” and enter a password. Also I deselect “Password Enforce Policy”. Then I set the Default database to one of my database and click OK. There is no problem up to here but when I want to login in using “SQL Server authentication” the following error appears:Login failed for user 'hi'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)I can’t solve this problem. I’d appreciate any one that can show me a way to fix this problem |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-23 : 14:20:29
|
| Did you enable SQL server authentication in server properties? |
 |
|
|
mamdy
Starting Member
3 Posts |
Posted - 2008-07-24 : 01:26:29
|
| Do you mean “Right Click on Server name> Properties>Security>SQL Server and Windows Authentication mode”?I enable the radio button but still that error appears. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 13:34:29
|
| Restarted sql after enabling it? |
|
|
|
|
|
|
SQL Server authentication strange problem