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



ABC
Does the server have Mixed Authenitcation or Windows only?



"ABC" <abc@xxxxxxx> wrote in message 
news:%23tATCN%23JGHA.2088@xxxxxxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxx> wrote in message 
> news:uk5WVE%23JGHA.3896@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxx> wrote in message 
>> news:ueCqj69JGHA.916@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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?
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
> 


.