Step-by-Step: Installing SQL Server Management Studio 2008 Express

UPDATE 7/31/2012 – Since this post new versions of SQL Server & Visual Studio have been released. To install the latest version of SQL Server see SQL Server Install. For more information on working with SQL Server Local DB in Visual Studio 2012 see Working with SQL Server LocalDB in Visual Studio 2012 and the MSDN Library SQL Server 2012 …

Microsoft Windows Server 2008 R2 Allow SQL Server access through windows firewall

Scenario: You have a Microsoft Windows Server 2008 R2 Server that is running a SQL Server 2008 r2 express database. Problem: You have a branch office connected through an ipsec VPN tunnel users on that network are complaining about access to their database application returning the following error: “The database was not found or access …