Open port for SQL Server remote connection

Ports and protocols used by Microsoft SQL Server database engine (SQLServer).

About this task

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
SQL Server is used by:

Read More

Restoring database from .mdf and .ldf files of SQL Server 2008

  1. First Put the .mdf and .ldf file in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA folder
  2. Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
  3. Click the “Add” button to open and Locate Database Files From C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAfolder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

Read More

Solving SQL Server Connection Problem

Inspect Server Settings

There are three significant aspects that users may neglect, which lead to the failure of the connection to the SQL Server.

Enable TCP/IP Connection

To check whether your server enabled to TCP/IP connections:

Read More