How To Fix Login Failed for User Microsoft SQL Server Error 18456 Step-By-Step

Download this episode

Download Video

Description

In this post, I will teach you how to determine what user has administrative rights on the server as well as walk you Step-By-Step how to configure SQL Server to allow other users to login as Administrators to SQL Server.  The generic message "Login Failed for User (Microsoft SQL Server, Error: 18456)" means you entered invalid credentials when logging into SQL Server.  In the below screen shot, I am logging into Microsoft SQL Server Management Studio with a user that does not have administrative permissions to connect to the server. Stick around after you fix this problem to learn how you can avoid many potential problems in the near future by learning a few fundamentals about dealing with SQL Server and inevitable SQL server issues.

SNAGHTML1d3c8af8

You need to figure out what user does have rights to SQL server.  Usually this is the user that you logged in with when you installed SQL Server or the user that is the default administrator on the computer.  To get a list of users on the machine... For full blog article navigate to: How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456) Step-By-Step – Add SQL Administrator to SQL Management Studio

Web Analytics Clicky

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.