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

From: Mac Davis (news_at_blindsided.org)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 10:14:12 -0500

Bala,

Thanks very much -

I already had both authentication methods selected.
Stopping and re-starting seems to have solved the problem.

Mac
If the obvious weren't so obscure, I'd be less confused.

"Bala Neerumalla[MSFT]" <balnee@online.microsoft.com> wrote in message
news:ewIB7tm$DHA.2308@tk2msftngp13.phx.gbl...
> 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.
> >
> >
>
>

Quantcast