SQL Server Authentication Login And Password = ALWAYS Error

1. 1. Home
   2. Questions
   3. Tags
   4. Users
   5. Companies
   6. Labs
   7. Jobs
   8. Discussions
   9. Collectives

   10. Communities for your favorite technologies. Explore all Collectives

2. Teams

   Ask questions, find answers and collaborate at work with Stack Overflow for Teams.

   Try Teams for free Explore Teams
3. Teams

4. Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

Get early access and see previews of new features.

Learn more about Labs MicrosoftSQL - SQL Server Authentication login and password = ALWAYS error Ask Question Asked 2 years, 11 months ago Modified 2 years, 11 months ago Viewed 912 times 0

So i currently trying the SQL Server Authentication. i follow this website: https://www.microfocus.com/documentation/silk-test/200/en/silktestworkbench-help-en/SILKTEST-7FFBB86A-CREATINGNEWSQLSERVERADMINUSER-TSK.html on how to make an SQL Server Account. for example, i went to security folder and make new security or account. my login name is USER and my password is PASSWORD. i edited the Schema and other whatever the website said. regardless, when i try to login and enter my password, it still cause errors that i cannot login

it say: Cannot connect to DESKTOP-6PK6OTL\SQLEXPRESS Login failed for user 'USER'.(Microsoft SQL Server, Error: 18456)

Is there something i must do before i enter? ive been making 3-5 security/accounts but the problem remains the same.

im using Microsoft SQL Server Management Studio

• sql
• sql-server

Share Improve this question Follow asked Jan 12, 2022 at 12:35 Dreac LeosonDreac Leoson 911 silver badge66 bronze badges 9

• 3 If you connect with the LOGIN that you used to create the new LOGIN, and go to the SQL Server logs, you'll be able to find the true authentication error. What was it? – Thom A Commented Jan 12, 2022 at 12:39
• Did you give it login permission ? – Ehsan Akbar Commented Jan 12, 2022 at 12:45
• the Source says "Logon", then next to it is the Message: "Login failed for user 'USER'. Reason: an attempt to login using SQL authentication failed. Server is configured for Integrated Authentication only. [ CLIENT: <local Machine>]" log type is SQL Server. Error type is 18456, Severity: 14, State: 58 – Dreac Leoson Commented Jan 12, 2022 at 12:45
• AlwaysLearning - i dont think it has something to do with password. my password is even simple and no capslock... Ehsan Akbar - i did give it permission on Server Roles as Public and Sysadmin. same goes toUser Mapping and give the Account check to some database. and to the Database role membership, i even give it permission to db_datareader, db_datawriter even db_owner – Dreac Leoson Commented Jan 12, 2022 at 12:47
• 2 "Server is configured for Integrated Authentication only. " tells the exact reason. Configure the server logon to both methods, SQL Server and Windows Authentication mode. – Serg Commented Jan 12, 2022 at 12:49

| Show 4 more comments Related questions 1 SQL Server login for SharePoint site login errors SSO 1 SQL Server Login Failed 48 An attempt to login using SQL authentication failed Related questions 1 SQL Server login for SharePoint site login errors SSO 1 SQL Server Login Failed 48 An attempt to login using SQL authentication failed 1 SQL Server login username and password 23 Error in login to SQL Server 0 sql login failed for windows authentication 0 Unable to login to sql server 4 Adding SQL Login does not work 1 Microsoft sql server error 18456 login failed for user 0 Unable to login with SQL Server authentication Load 7 more related questions Show fewer related questions

0

Sorted by: Reset to default Highest score (default) Trending (recent votes count more) Date modified (newest first) Date created (oldest first)

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.
• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Draft saved Draft discarded

Sign up or log in

Sign up using Google Sign up using Email and Password Submit

Post as a guest

Name Email

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged

• sql
• sql-server

or ask your own question.

• The Overflow Blog
• How developer jobs (and the job market) changed in 2024
• You should keep a developer’s journal
• Featured on Meta
• The December 2024 Community Asks Sprint has been moved to March 2025 (and...
• Stack Overflow Jobs is expanding to more countries

Hot Network Questions

• How to design a network and loss function for classes, composed of two other classes?
• Mixing between the tonic and dominant in melodic dictation
• How can I replace the anode rod with this in the way?
• Can I use copyleft-licensed library in MIT-licensed project?
• Minimum Number of Squares to Color
• Change label based input value
• How can I attach a second subpanel to this main?
• How to make the curved part of this traffic light?
• Is it rational to want to die someday, because if you live forever, the probability approaches 1 that you'll fall into the center of a star?
• Does adding a reflector to a patio heater cause a safety hazard?
• ElasticSearch cluster master data deleted
• Are Hurdle models equivalent to zero inflated models?
• Expressing non solvable roots?
• Consequences of geometric Langlands (or Langlands program) with elementary statements
• Older movie with a similar premise to Interstellar
• Do all TCP packets from same http request take same route? If not, how can I better understand where each went?
• What livery is on this F-5 airframe?
• The button indexes are different between two controllers. Is there a work around?
• In John 14:1, why does Jesus tell us to believe in him along with God, if he isn't personally God himself?
• What is the I in "I think therefore I am"?
• DTFT of an autocorrelation function is producing a complex PSD?
• The probability of drawing a diamond, then drawing an ace is equal to drawing the ace of diamonds.
• Help identifuing partially built set
• Odds of hitting a star with a laser shone in a random direction

more hot questions Question feed Subscribe to RSS Question feed

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

lang-sql