mixed mode authentication Archives

SQL Server / SQL Server Accidental DBA Series

SQL Server error 18452 login failed user null

December 10, 2014December 20, 2019 - by SQL Geek - Leave a Comment

One of most oldest and common question in forums is SQL server error 18452 login failed for user ‘null’. The error can be resolved by changing the SQL Server authentication mode …

SQL Server / SQL Server Accidental DBA Series

Error 40 could not open a connection to SQL Server

December 8, 2014December 20, 2019 - by SQL Geek - Leave a Comment

One of the most common errors one may encounter when connecting to SQL Server is Error 40 could not open a connection to SQL server. The error is very clear and …