Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Attempt to use a Windows login name with SQL Authentication

Posted on 2007-11-24
9
Medium Priority
?
1,076 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 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