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:
Restoring database from .mdf and .ldf files of SQL Server 2008
- First Put the
.mdf
and.ldf
file inC:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA
folder - Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
- Click the “Add” button to open and Locate Database Files From
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATA
folder - Click the “OK” button. SQL Server Management Studio loads the database from the
.MDF
file.
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: