Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Attempt to use a Windows login name with SQL Authentication

Posted on 2007-11-24
9
Medium Priority
?
1,077 Views
Last Modified: 2008-02-01
Attempt to use a Windows login name with SQL Authentication

What is the proper way to solve this error.   I have written a C# program and I am referencing my connection string in the web.cfg file.  When I created the SQL Data Source it tested with no connectivity problems.  Can someone just provide clairty of what this means.


Thanks
Kenny
0
Comment
Question by:kwh3856
  • 5
  • 3
9 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20344651
can you post the error ?
Refer this tooo  www.connectionstings.com
0
 
LVL 6

Expert Comment

by:PaultheBroker
ID: 20344670
hey aneeshattingal - u sure that link is correct??  I get a search result page...
0
 

Author Comment

by:kwh3856
ID: 20344673
Date            11/24/2007 8:30:08 PM
Log            SQL Server (Current - 11/24/2007 8:30:00 PM)

Source            Logon

Message
Error: 18456, Severity: 14, State: 5.

I found on Google that the State 5 means:
Attempt to use a Windows login name with SQL Authentication


0
Technology Partners: 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!

 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20344677
0
 

Author Comment

by:kwh3856
ID: 20344678
Now I am getting State: 6.
0
 

Author Comment

by:kwh3856
ID: 20344684
When you key User ID=, does the username have to be preceded with the domain such as domain\username or can it just be username?

Does it matter either way?

0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 20344692
try with the DomainName\ username
0
 

Author Comment

by:kwh3856
ID: 20344706
That did not work either.  I am currently using this website to evaluate the exact error message

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Any ideas?
0
 

Author Comment

by:kwh3856
ID: 20344738
Aneeshattingal,
You were right.  I had to have the domain\username.  The other thing I had to do was change the security mode on SQL to be Windows Security only.  Now, I have a new error message.  I will post that as a new question.  Thanks for your help.

Kenny
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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

885 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