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

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?
>>
>>
>>
>>
>>
>>
>
> 


.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Crystal Reports / SQL Express / Vista
    ... and was developed under Windows XP using VB.NET 2005 and Crystal Reports XI ... SQL Server at this stage so I am attempting to set up a PC running SQL ... It displays the first prompt before I get the data, ...
    (microsoft.public.vb.crystal)
  • Re: Crystal Reports / SQL Express / Vista
    ... Sorted by installing latest service pack. ... and was developed under Windows XP using VB.NET 2005 and Crystal Reports ... using various incarnations of the full version of SQL Server ...
    (microsoft.public.vb.crystal)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
Quantcast