Quick Windows Server 2008 R2 – SQL Server Firewall setup

Setting up SQL Server 2012 I received the same warning I have always received when setting up a SQL instance on a new Windows server:

SQL Setup Support Rules – Firewall Warning

So I executed my handy Windows Server Firewall batch file for SQL to set up the default ports on the Firewall, which executed successfully, but I noticed the following warning during execution:

Warning – netsh firewall is deprecated

After a quick check I updated the file with the new correct script options (I have left the original script lines in, just commented them out for reference:

@echo =========  SSRS Ports  ===================
@echo Enabling SQLServer default instance port 1433
REM Deprecated: netsh firewall set portopening TCP 1433 "SQLServer" 
netsh advfirewall firewall add rule name="SQLServer" dir=in action=allow protocol=TCP localport=1433

@echo Enabling Dedicated Admin Connection port 1434
REM Deprecated: netsh firewall set portopening TCP 1434 "SQL Admin Connection" 
netsh advfirewall firewall add rule name="SQL Admin Connection" dir=in action=allow protocol=TCP localport=1434

@echo Enabling conventional SQL Server Service Broker port 4022  
REM Deprecated: netsh firewall set portopening TCP 4022 "SQL Service Broker" 
netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow protocol=TCP localport=4022

@echo Enabling Transact-SQL Debugger/RPC port 135 
REM Deprecated: netsh firewall set portopening TCP 135 "SQL Debugger/RPC" 
netsh advfirewall firewall add rule name="SQL Debugger/RPC" dir=in action=allow protocol=TCP localport=135

@echo =========  SSAS Ports  ==============
@echo Enabling SSAS Default Instance port 2383
REM Deprecated: netsh firewall set portopening TCP 2383 "Analysis Services" 
netsh advfirewall firewall add rule name="Analysis Services" dir=in action=allow protocol=TCP localport=2383

@echo Enabling SQL Server Browser Service port 2382
REM Deprecated: netsh firewall set portopening TCP 2382 "SQL Browser" 
netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=TCP localport=2382

@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80 
REM Deprecated: netsh firewall set portopening TCP 80 "HTTP" 
netsh advfirewall firewall add rule name="HTTP" dir=in action=allow protocol=TCP localport=80

@echo Enabling SSL port 443
REM Deprecated: netsh firewall set portopening TCP 443 "SSL" 
netsh advfirewall firewall add rule name="SSL" dir=in action=allow protocol=TCP localport=443

@echo Enabling port for SQL Server Browser Service 'Browse' Button
REM Deprecated: netsh firewall set portopening UDP 1434 "SQL Browser" 
netsh advfirewall firewall add rule name="SQL Browse" dir=in action=allow protocol=TCP localport=1434

@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
REM Deprecated:netsh firewall set multicastbroadcastresponse ENABLE
netsh advfirewall set currentprofile settings unicastresponsetomulticast enable

@echo Complete, Check your results.
pause

 

You can download this as a Windows batch file here: [download id=”5″]

Hope it make your future installs easier.

Tested on:

  • Windows Server 2008 R2 Sp1 while installing SQL Server 2012
  • Windows Server 2008 R2 while installing SQL Server 2008 R2

Sources:

http://technet.microsoft.com/en-us/library/cc771046(v=ws.10).aspx

http://support.microsoft.com/kb/947709

http://support.microsoft.com/kb/949543

 

Note: This script is provided “as is” without any representations or warranties, express or implied – use of this script is at your own risk.

Welding – A new hobby

Source: https://www.flickr.com/photos/serenitbee/6812020407/

Source: https://www.flickr.com/photos/serenitbee/6812020407/

A few months ago I needed perform some minor repairs to a metal railing which in turn required the use of the welding machine that I had acquired from my dads’ dusty store room.

I managed to fix the metal railing but the result was not very neat or very strong (the repair fortunately does not need to take load)

A couple of weeks after the railing repair a colleague at work was discussing general home renovations and he suggested we both try to improve our dismal welding skills by going on a welding course that he had spotted online.

The course offered was a half day introduction to stick welding; Starting with a short introduction to the theory of welding, types of welding, welding equipment and welding safety.

Once all the theory was covered the training moved out to a little workshop where the students could try our hands at actual welding first on an angle iron to get the feel of how to weld (with the instructor on hand to inform us on what we were doing wrong with our technique), then on to two pieces of metal to work on our joining techniques.

After we all had a go and most of us were comfortable with the equipment we moved on to the project of the day  welding together a beer can chicken holder.

From Wikipedia:

…beer can chicken, beer butt chicken, dancing chicken or chicken on a throne) is made by standing a prepared chicken upright on a partially filled can of beer and cooking it slowly in a barbecue or oven. The can goes into the opening of the chicken so that the beer evaporates and permeates the cooking chicken…

The result of my effort; a functional and relatively neat beer can chicken holder is below (it is amazing what a little bit of grinding, sand paper, elbow grease and a lick of paint can do to finish off a job nicely)

P.S. I have used my holder twice since I made it to great success on my Weber Grill.

HTC Desire S – Unable to download Google Play application updates over wireless

I recently had an issue where I was unable to download application updates on my Android phone.

Error Message:

  • Error: Update for “<application>” could not be downloaded due to an error. (495)

Phone details:

  • HTC Desire S
  • Android 2.3.5
  • HTC Sense 3.0

After much searching I eventually used these two different options to resolve my issues:

Option 1 – Clear phone download manager cache:

  1. Settings > applications > all applications > Download manager > Clear cache
  2. Settings > applications > all applications > Google Play > Clear cache
  3. Restart phone
  4. Attempt application download again.

This resolved some of my update issues (3 of 6 outstanding updates downloaded successfully over wireless)

Option 2 – Wireless network is blocking a required port for the download:

  1. Disable phones wireless connection
  2. Switch on your 2G/3G connection
  3. Attempt application download again.

This resolved the balance of my download issues and once all the current updates were successfully downloaded and installed the error with wireless downloads has corrected itself (future updates downloaded successfully over wireless).

Hope this helps if you have similar issues on your android device.