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, 10 months ago Modified 2 years, 10 months ago Viewed 899 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
• We'll Be In Touch - A New Podcast From Stack Overflow!
• The app that fights for your data privacy rights
• Featured on Meta
• More network sites to see advertising test
• We’re (finally!) going to the cloud!
• Call for testers for an early access release of a Stack Overflow extension...

Hot Network Questions

• Printing clist out, but controlling whether there should be a \nobreakspace after “and”
• logical error probability independent from distance in STIM default repetition code
• Using a platinum loop to light a gas stove in Oliver Sacks's memoir
• Chain skipping when pedaling hard
• Best way to design a PCB for frequent component switching?
• Does a matrix C exist so that AC and BC are positive definite?
• Sci-fi movie that starts with a man digging his way out of a crashed spacecraft and promptly being torn in half
• How far above a forest fire or conflagration would you need to be, to not burn alive?
• Do hypotheses need a “how” explanation or are predictions enough to validate them?
• To “digitize” means to turn something into a digital format that was previously not digital. What to call changing one digital format into another?
• USB drives in space?
• Are there any existing (indigenous) European languages with aspirated/unaspirated versions of consonants which are different phonemes?
• Is it a bad idea to talk about the city/country in phd application letters?
• Anti-Hermitian Hamiltonians in Quantum Mechanics and Open Systems
• Publishing an article despite the outcomes are not what we wanted
• New 90 TB/10 drive RAID 5 array state: clean, degraded, recovering. Why, and how long will it take to recover?
• Testing, if a file exists. (The point is the point.)
• Can a signatory country to the International Criminal Court withdraw to evade obligation to comply with an issued order?
• how to stop using a command directly
• Aeschylus quote about wind, sea, skies and sun rays
• Is it safe to solder 230V wire on relay?
• Are there three distinct Pythagorean triples on six integers?
• Drill Small Hole in 2 Inch Wood Ball
• eLife-like publications and Tenure Decisions

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