Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1079
  • Last Modified:

Attempt to use a Windows login name with SQL Authentication

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
kwh3856
Asked:
kwh3856
  • 5
  • 3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
can you post the error ?
Refer this tooo  www.connectionstings.com
0
 
PaultheBrokerCommented:
hey aneeshattingal - u sure that link is correct??  I get a search result page...
0
 
kwh3856Author Commented:
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!

 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
kwh3856Author Commented:
Now I am getting State: 6.
0
 
kwh3856Author Commented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
try with the DomainName\ username
0
 
kwh3856Author Commented:
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
 
kwh3856Author Commented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now