BJ's Technology Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
BJ's Technology Forum

Let's talk about technology, gadgets and everything geeky in the world. Are you with me? Let's do it!

Search
 
 

Display results as :
 


Rechercher Advanced Search

Keywords

error  

Latest topics
» How To Hide Cortana on Windows 10 Taskbar
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:46 pm by bjtechnews

» How To Use and Configure Windows 10 Notification Center
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:45 pm by bjtechnews

» How To Disable OneDrive and Remove it from File Explorer in Windows 10
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:44 pm by bjtechnews

» Top 23 PowerShell Commands to Uninstall Windows 10 Built-in Apps
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:42 pm by bjtechnews

» How To Schedule Restarts for Windows 10 Updates
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:41 pm by bjtechnews

» How To Get Offline Maps in Windows 10
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:39 pm by bjtechnews

» Windows xp mode in windows 10?
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 25, 2015 10:30 pm by bjtechnews

» MDT 2012: Capturing a Reference Image – Part II
Microsoft SQL Server Error 18456 Login Failed for User EmptyTue Aug 26, 2014 8:14 pm by _blake

» Top 15 Android Voice Actions!
Microsoft SQL Server Error 18456 Login Failed for User EmptyWed Jul 23, 2014 2:32 pm by bjtechnews

March 2024
MonTueWedThuFriSatSun
    123
45678910
11121314151617
18192021222324
25262728293031

Calendar Calendar

Affiliates

free forum

Forumotion on Facebook Forumotion on Twitter Forumotion on YouTube Forumotion on Google+


You are not connected. Please login or register

Microsoft SQL Server Error 18456 Login Failed for User

Go down  Message [Page 1 of 1]

bjtechnews

bjtechnews
Admin

18456 Error Problem


So I was connecting to Microsoft SQL Server and trying to
use the SQL Authentication method and I received this event ID error
18456 login failed for user
you provided. See below example.

Microsoft SQL Server Error 18456 Login Failed for User 3-14-2012-10-14-50-pm
Microsoft SQL Server Error 18456 Login Failed for User 3-14-2012-10-15-10-pm




I did some research online and found out that this usually
means that your connection request was successfully received by the server name
you specified [so why didn't it work], but the server is not able to grant you
access for a number of reasons and throws error: 18456.



Below is a list of reasons and some brief explanation what
to do:



SQL Authentication not enabled: If you use SQL Login for the first time on SQL Server
instance than very often error 18456 occurs because Windows Authentication
(only) is set in Server properties (security section).



To Access Server Properties, Open SQL Server Management
Studio, go to Object Explorer pane (use view if you can’t see it). Use the
connect button to connect to database engine for your server. Once connected
you will see it in object explorer. Right click server and click properties.
Server Properties window will appear.


Microsoft SQL Server Error 18456 Login Failed for User 3-14-2012-10-15-28-pm





See below screenshot that might be causing SQL login to fail



Microsoft SQL Server Error 18456 Login Failed for User 3-14-2012-10-15-51-pm




You should set Server Authentication to SQL Server
Windows Authentication




Microsoft SQL Server Error 18456 Login Failed for User 3-14-2012-10-16-08-pm




Invalid userID:
SQL Server is not able to find the specified UserID on the server you are
trying to get. The most common cause is that this userID hasn’t been granted
access on the server but this could be also a simple typo or you accidentally
are trying to connect to different server (Typical if you use more than one
server)



Invalid password:
Wrong password or just a typo. Remember that this username can have different
passwords on different servers.



less common errors:
The userID might be disabled on the server. Windows login was provided for SQL
Authentication (change to Windows Authentication. If you use SSMS you might
have to run as different user to use this option). Password might have expired
and probably several other reasons…. If you know of any other ones let me know.



18456 state 1 explanations:
Usually Microsoft SQL Server will give you error state 1 which actually does
not mean anything apart from that you have 18456 error. State 1 is used to hide
actual state in order to protect the system, which to me makes sense. Below is
a list with all different states and for more information about retrieving
accurate states visit Understanding “login failed” (Error 18456) error messages in
SQL Server 2005

http://bjtechnews.org

Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum