• Enable and change FILESTREAM Setting SQL Server 2008 R2 Express

    When you are trying to restore one database and you stuck with the error showing FileSTREAM feature is disabled.   Solution To enable and change FILESTREAM settings     On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then...
  • Connect to the SQL Server 2008 Express remotely

    Steps to configure Open SQL Server Configuration Manager. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager. On SQL Server Configuration Manager, select SQL Server Services on the left window. If the state on SQL Server Browser is not running, you...