Solved

Attempt to use a Windows login name with SQL Authentication

Posted on 2007-11-24
9
1,072 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Back Up Your Microsoft Windows Server®

Back up 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.

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

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!

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

691 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