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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server authentication problem

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-09-29 : 12:00:37
Hello everyone

I am trying to log on to my testing laptop with 2005 dev edition on a vista premium OS. I can logon using windows, but when i set up a user with a password I keep getting error code 18452. I have installed
the instance with mixed authentication. Is there something else i could be doing wrong?

Can someone help please

Kind regards

Rob

MCTS certified

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-29 : 12:10:09
Check server properties -Security -enable both SQL authen and Windows authentication.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2008-09-29 : 12:24:03
thank you i have done that.

Restarted server

and we are on

Thank you.

MCTS certified
Go to Top of Page
   

- Advertisement -