SqlServer: firewalls, mixed mode authentication

When doing a new install of SQL, I always remember to turn on TCP/IP client access, and to allow SQLServer through the firewalI . But I sometimes forget about the port number, and I did that again today.

From here:

SSFW01

SSFW03

Now it’s fine…

SSFW02


There is a second thing I consistently forget: that Mixed Mode authentication is off by default in a new SQLServer installation:

Advertisements