Nov
8
2011

Error: 18456, Severity: 14, State: 58

Today while troubleshooting a SQL authentication issue, came across following error: Login failed for user ‘sa’. (Microsoft SQL Server, Error: 18456, Severity: 14, State: 58) When I use SQL Server Authentication to connect server. This was authentication issue, hence first checked the authentication mode and found that it is configured as Windows Authentication instead of Mixed mode (SQL + Windows) authentication Once I modified the authentication mode to mixed mode, it requested me to restart […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

November 2011
M T W T F S S
« Oct   Dec »
 123456
78910111213
14151617181920
21222324252627
282930  

View Post by Categories

%d bloggers like this: