CODEWITHSUNDEEP
sql-serverssmsssms-2014
Kelly
Kelly

Reputation: 1005

Cannot connect to SQL Server via SQL Server Authentication

I am using SQL Server 2014 Management Studio to connect to a SQL Server 2008 R2 instance. I can connect via Windows auth but none of the SQL Server authentication credentials work, even though they work for my coworkers on their computers. It says "Login Failed". It doesn't seem like any SQL Server authentication works for any server. Does anyone know of settings I can look for, anything with firewalls maybe? Or something on SQL Server that could be blocking just me?

Details say

Msg 18456, Severity: 14, State: 1, Line Number: 65536.

Upvotes: 1

Views: 3479

Answers (2)

Shmuel Milavski
Shmuel Milavski

Reputation: 67

Following Tab Alleman Answer - You will need to restart SQL service to activated the functionality.

Upvotes: 0

Tab Alleman
Tab Alleman

Reputation: 31785

Login with windows, right click on the server and select "Properties".

In the Properties dialog click "Security".

In the right pane, under "Server Authentication", select "SQL Server and Windows Authentication mode".

Not sure if you need to restart SQL Service or reboot the server after this.

Upvotes: 1

Related Questions