Here is a quick one, only because I messed around missing the obvious after installing SQL 2012 when not being able to connect to the database after installation. Once I went back to basics and realised the issue was the firewall, I used the following command to configure the Windows Firewall on my Windows Server 2012 Core machine so I could connect to SQL:
netsh advfirewall firewall add rule name="SQL Server 1433"
dir=in action=allow protocol=TCP localport=1433
NOTE: The command is wrapped, it should be a single line
No comments:
Post a Comment