SQL Firewall Exceptions


SQL Firewall Exceptions

Author
Message
John-Michael Sugden
John-Michael Sugden
Forum Sage
Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)

Group: Forum Members
Posts: 47, Visits: 500
Hi All,

I have created a Batch file to add the correct firewall exceptions to a windows7 or server 2008 firewall for clients to connect to an instance of SQL. Just download the attached file, unzip and then run as Administrator.

The process will display and error if the keys are not added correctly.

Hope this helps,

John-Michael


PS: You will need to be logged into the forum to download files, guest users cannot download.

 

Attachments
SQLfirewall.zip (310 views, 549 bytes)
Edited
5 Years Ago by John-Michael Sugden
John-Michael Sugden
John-Michael Sugden
Forum Sage
Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)

Group: Forum Members
Posts: 47, Visits: 500
Hi All,

One or two people have been unable to download this file. The problem appears to be related to the browser, if you are using Google Chrome to download the file it may fail to download. Please try a different browser, I have tested several versions of Internet explorer and Firefox and these seem to download correctly.

Hope this helps,

John-Michael
Matt Wade
Matt Wade
Forum Sage
Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)

Group: Forum Members
Posts: 296, Visits: 863
Hi John,

Does this get around having to put in a physical Port Number to allow?

ta - M

Matt Wade
Need Training or Consultancy for Broadcast Radio Software Products?
Get in touch
w: https://mattwadeonline.co.uk
e: training@mattwadeonline.co.uk
John-Michael Sugden
John-Michael Sugden
Forum Sage
Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)Forum Sage (4.4K reputation)

Group: Forum Members
Posts: 47, Visits: 500
Hi Matt,

The Script adds the SQL Server exe and The Server Browser exe to the firewall for all ports.

Hope this helps,

John-Michael
Matt Wade
Matt Wade
Forum Sage
Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)Forum Sage (24K reputation)

Group: Forum Members
Posts: 296, Visits: 863
Hiya,

I am still having issues downloading that file. I tried on Firefox and IE but it just links me back to the forum front page.

ta - M

Matt Wade
Need Training or Consultancy for Broadcast Radio Software Products?
Get in touch
w: https://mattwadeonline.co.uk
e: training@mattwadeonline.co.uk
GO


Reading This Topic


Login
Existing Account
Email Address:


Password:


Select a Forum....


































Broadcast Radio Forums


Search