Tool: SQLBackupAndFTP

OK, sometimes a tools comes around that is so easy to use that you kinda wonder why anyone would do it otherwise.

To do backups on SQL Server, highly recommend: http://sqlbackupandftp.com/

Dev: Remote SQL Server Access

How to set up access from SQL Server Management Studio to SQL Server 2008 on Winows 2008 with a software firewall?  Make sure to create a rule in the firewall that enables access to sqlservr.exe that is located in the Binn directory of your database.  See this MSFT article, look to “To access a program through the Windows firewall”.  No need to punch through holes for TCP or UDP.