Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Msg 4701, Level 16 trying to truncate table through Linked Server February 2, 2021
  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
  • Msg 8115, Level 16 Arithmetic overflow November 4, 2020
  • SQL Server Columnstore Index Performance Benefits October 6, 2020
February 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
« Jan    

Tag: 18456

SQL Server: Login Failed for user Error: 18456

Many times you have applications that need to have a SQL Server login instead of one that uses Windows authentication. So you create one, and then you try to login using the credentials and you get the dreaded: Login failed for user Error: 18456 error. Below I am going to show you one way that fixes the issue.

Continue reading SQL Server: Login Failed for user Error: 18456
Posted on September 4, 2020July 11, 2020Categories Hints and TipsTags 18456, authentication, error: 18456, login failedLeave a comment on SQL Server: Login Failed for user Error: 18456
Create a website or blog at WordPress.com