How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456) Step-By-Step – Add SQL Administrator to SQL Management Studio


In this post and video, 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. 

SNAGHTML1d3c8af8

You need to figure out what user does have rights to SQL server...

Read More... How to Fix Login Failed for User (Microsoft SQL Server, Error: 18456) Step-By-Step & Add SQL Administrator to SQL Management Studio

Skip to main content