Travis Tran

Travis Tran

BREAKTHROUGH the limits

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:

Continue reading

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

  1. First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ 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 Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

Continue reading

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:

Continue reading
X
Glad to have you at travistran.me
Welcome to TravisBot
wpChatIcon