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

How to set SQL Server only accept SQL Server Authentication mode?

How to set SQL Server only accept SQL Server Authentication mode?
Our company will not use mixed authentication mode, how to switch SQL Server
Authentication?ABC
I don't think you can do that. Either SS2000 and SS2005 accept Windows and
SQL Server and Windows Authentication
However it does not o have onyl SQL Server Authentication.
Why would you want to do that? If you want , you cam build a connection
string to the SQL Server by using SQL Server Authentication by providing a
user and a password but it will be alwasy an another option to connect by
WA.
"ABC" <abc@.abc.com> wrote in message
news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
> How to set SQL Server only accept SQL Server Authentication mode?
> Our company will not use mixed authentication mode, how to switch SQL
> Server Authentication?
>
>
>|||I don't know why.
Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
There have reports that directly call to sql server's stored procedure. I
also call SetDatabaseLogon method to change user id and password. But I
found the crystal reports use ASPNET account to logon SQL Server, not my
expected user id.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
> ABC
> I don't think you can do that. Either SS2000 and SS2005 accept Windows
> and SQL Server and Windows Authentication
> However it does not o have onyl SQL Server Authentication.
> Why would you want to do that? If you want , you cam build a connection
> string to the SQL Server by using SQL Server Authentication by providing a
> user and a password but it will be alwasy an another option to connect by
> WA.
>
>
> "ABC" <abc@.abc.com> wrote in message
> news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
>|||ABC
Does the server have Mixed Authenitcation or Windows only?
"ABC" <abc@.abc.com> wrote in message
news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>I don't know why.
> Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
> There have reports that directly call to sql server's stored procedure. I
> also call SetDatabaseLogon method to change user id and password. But I
> found the crystal reports use ASPNET account to logon SQL Server, not my
> expected user id.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
>|||Mixed mode.
"Uri Dimant" <urid@.iscar.co.il> glsD:%230Zzda%23JGHA.2912@.tk2msftngp13.phx.gbl...[
vbcol=seagreen]
> ABC
> Does the server have Mixed Authenitcation or Windows only?
>
> "ABC" <abc@.abc.com> wrote in message
> news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]

HOW to set Authentication Using OSQL

I would like to change the authentication method for an MSDE instance. How
do I do it via OSQL ?
This I need when there is no EM installed. I would like to turn the default
authentication from Windows to Mixed mode.
I searched BOL but it talked about using EM.
Thanks in advance for your input.
MacYou can switch MSDE to mixed mode during installation and after that.
Here it is
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
Regards
---
All information provided above AS IS.
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> I would like to change the authentication method for an MSDE instance.
How
> do I do it via OSQL ?
> This I need when there is no EM installed. I would like to turn the
default
> authentication from Windows to Mixed mode.
> I searched BOL but it talked about using EM.
> Thanks in advance for your input.
> Mac
>|||Thanks for the quick response!! That worked.
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:%23o1rkv9nDHA.372@.TK2MSFTNGP11.phx.gbl...
> You can switch MSDE to mixed mode during installation and after that.
> Here it is
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930&Product=sql#5
>
> Regards
> ---
> All information provided above AS IS.
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:bnu8sh$20ag$1@.si05.rsvl.unisys.com...
> > I would like to change the authentication method for an MSDE instance.
> How
> > do I do it via OSQL ?
> > This I need when there is no EM installed. I would like to turn the
> default
> > authentication from Windows to Mixed mode.
> > I searched BOL but it talked about using EM.
> >
> > Thanks in advance for your input.
> > Mac
> >
> >
>