How to setup SQL auth. for SQLserver 2005 express?

Hi,

I can't seem to set up SQL server authentication for SQLserver 2005 Express edition..

I simply can't find the settings for that. I have Management Studio Express installed and I can see the SA user but I can't login using that user.. I know that there's supposed to be a setting for turning on SQL auth. but it's not like it used to be in Enterprise manager :) so I can't find it.. ;/ I couldn't find any documentation on how to do this so I thought I'll try here..

(I need SQL auth for my project :) - it must be done with that..)

Thanks in advance,

ZenX

Hi,

have a look in on my site in the Screencast section, there is a detailed Screencast for this which will show you the steps.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de