Home > SQL Server
An error occurred when attaching the database(s). Click the hyperlink in the Message column for details

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details. While attaching .mdf and .ldf database files in SQL server management studio, it throws error attached image - 1 Image - 1 It seems permission issue for which it gives this error while attaching the .mdf and

Read More

Create a rule in Windows Firewall to give access to connect Microsoft SQL Server

Create a rule in Windows Firewall to give access to connect Microsoft SQL Server On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Port, and then click Next. In the Protocol and Ports dialog box, select TCP. Select Specific local

Read More

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 click SQL Server Configuration Manager.    

Read More