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:



Now it’s fine…


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