Re: Login failed for user 'IIS'. Reason: Not associated with a trusted SQL Server connection.

From: Bala Neerumalla[MSFT] (balnee_at_online.microsoft.com)
Date: 02/29/04

  • Next message: Bala Neerumalla[MSFT]: "Re: SSL setup problems" 
    Date: Sat, 28 Feb 2004 18:26:40 -0800

    Configure your SQL Server to mixed Authentication mode (SQL Server and
    Windows) using Enterprise Manager (local->Properties->Right clict and select
    Security Tab -> select "SQL Server and Windows" radio button under
    Authentication section->click Ok button ->Restart SQL Server).

    Regards,
    Bala. 

    -- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mac Davis" <news@blindsided.org> wrote in message
news:O9QAe3g$DHA.808@TK2MSFTNGP12.phx.gbl...
> Server 2003
> or
> Server 2003 Web Edition
>
> SQL Server 2000 Service Pack 3a
>
> Network is a workgroup, not a Domain
>
> I've always stumbled through setting up users with a new SQL installation.
>
> I want to use SQL Server Authentication
>
> I have created a user named IIS but when I try to connect from ASP, or
from
> Delphi using ADO
> the response is Login failed for user 'IIS'. Reason: Not associated with a
> trusted SQL Server connection"
>
> Could someone walk me through setting up a user and assigning the proper
> security.
>
> Thanks,
>
> Mac
>
> If the obvious weren't so obscure, I'd be less confused.
>
>
  • Next message: Bala Neerumalla[MSFT]: "Re: SSL setup problems"