Re: User ID issue - urgent

I get the error when i try to login to the db from my web app and when I try
to use query analyzer.


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:cc2g03dpriomcrb3nivg1duk0r3u8sbce3@xxxxxxxxxx
And one other thought....if you changed the authentication to SQL
Server and Windows Authentication from Windows Only, the service needs
to be restarted for those changes to take affect. Maybe you changed to
allow SQL Authentication but haven't restarted the service?
From what tool, application or what steps result in the error message
"Login failed for user 'ID'. The user is not associated with a trusted
SQL Server connection."
Does this involve a connection string at all or are you trying through
SQL Server tools?

-Sue

On Mon, 26 Mar 2007 11:59:09 -0400, "John" <John@xxxxxxxxx> wrote:

I thought that was the issue as well. I checked and I have SQL Server and
windows Auth checked and I'm still gettting the error.

This is nerve racking. I've been trying to figure this out most of the
morning.

"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:eUroE87bHHA.2408@xxxxxxxxxxxxxxxxxxxxxxx
John,

Is your SQL Server configured to only support Trusted Connections?
On the Security tab of Server Properties there are two radio buttons:
* Windows Authentication Mode
* SQL Server and Windows Authentication Mode

If you have the first selected, then a SQL Server account cannot login.
Could that be the problem?
RLF

"John" <John@xxxxxxxxx> wrote in message
news:OfZcZ17bHHA.4832@xxxxxxxxxxxxxxxxxxxxxxx
I'm trying to create a new user ID for a database on my box, I keep
getting the message


'Login failed for user 'ID'. The user is not associated with a trusted
SQL Server connection.

I add the ID under the default security tab, then associate that id to
the database I want the ID linked to.
what am I doing wrong with this?








.