Solved

Attempt to use a Windows login name with SQL Authentication

Posted on 2007-11-24
9
1,067 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
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20344677
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# GridRow get Old/New Value 1 55
CROSS APPLY 4 45
Filename to be appended with DateTimeof Download 3 47
Sql query 107 30
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now