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]