[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Authentication Problem

Posted on 2004-11-05
5
Medium Priority
?
302 Views
Last Modified: 2010-05-18
I have a SQL Server login called supportuser on a server.  The problem is that whenever I try to log in using this account (either through QA or C#) I get this error:

Unable to connect to server XXXX
Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'supportuser'. Reason: Not associated with a trusted SQL Server connection.

Mixed Authentication IS enabled.  I have checked this both through Enterprise Manager and through QA (I can log in using Windows Authentication).  Everything that I have found either deals with Mixed Authentication or a guest account, neither of which help me.  Does anyone have any ideas.  Thanks.
0
Comment
Question by:duckcreektech
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:ShogunWade
ID: 12507217
What edition of SQL Server do you have,  what service packs what operating system?
0
 
LVL 6

Expert Comment

by:Duane Lawrence
ID: 12507680
You need to isolate where the problem is.

1.
Go to the machine the database is running on
Can you log in manually using that user id?
supportuser

2.
Go to the remote machine.
Can you log in manually using that user id?
supportuser

3.
It sounds like the computer that is connecting to your database does not have the correct Active Directory setting.  You can give such in such networks or computers "trusted connection" status in Active Directory.  I can't help you do the Active Directory setting, but I am sure there is a group here that can.

Duane
0
 

Author Comment

by:duckcreektech
ID: 12507823
It is SQL Server 2000 Standard running on Server 2000.

I was able to Remote Desktop into the server, open up QA, and log in using the supportuser login.  So how do I set up trusted connection status on the server to allow other domain users?  Thanks.
0
 
LVL 6

Accepted Solution

by:
Duane Lawrence earned 500 total points
ID: 12507862
0
 

Author Comment

by:duckcreektech
ID: 12508192
I got it working.  Thank you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question