Re: User ID issue - urgent

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?




.