SqlServerPrerequisites

Owned by Orcrist
Last updated: Dec 18, 2013

In order for SqlServer to work properly, it needs to be configured to:

  • Accept TCP connections
  • Use sql native or mixed mode authentication

And the local Windows server needs to be configured to allow Sql connections (TCP 1433) through the firewall.

Attached to this page are some batch, registry and windows firewall scripts to perform these actions.  Download them as a group and run the setup batch file to perform these actions automatically.