Connect to MS SQL Server

Click New on the Connection menu.

Select SQL Server.

Connection name: assign a name.

Server name: assign the Server name. This can either be a Server name or an IP address.

Note: The MS SQL Server default port is 1433; if your database Server uses another port than specify like that: IP, port (e.g. 188.020.22.66,1434)

Authentication: define if the Server is setup for Windows or MS SQL Server authentication.

User: enter the user id

Password: enter the database password

Initial catalog: enter the database name you want to connect to.

Connection timeout: define the time out setting in seconds.

SQL dialect: define which SQL Server SQL dialect to use. That should be consistent with the MS SQL Server version of your database.

Enable Offline mode: Learn more here

Select User Groups who can view the Connection: Assign user groups with privileges to open objects from this connection.

Click Ok to establish the connection.

Related

Connect to DB2