Re: User ID issue - urgent

John,

Was there anything unusual about this account? Have you restored a
database? Master or your target database? If anything looks odd, try.

1. Dropping ID as a user of any database.
2. Dropping the ID login.
3. Recreating the Login and User.

What happens? Do you get any error messages during this process?

RLF
"John" <John@xxxxxxxxx> wrote in message
news:OezGt%237bHHA.1216@xxxxxxxxxxxxxxxxxxxxxxx
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?








.