Skip to main content

How to Connect to a Hostek Microsoft SQL Server Database With SQL Server Management Studio

You can connect to a Microsoft SQL Server database hosted on a Hostek server using SQL Server Management Studio (SSMS). This guide provides the steps for a customer to establish a connection to their database using the SSMS client.

You can connect to a Microsoft SQL Server database hosted on a Hostek server using SQL Server Management Studio (SSMS). This guide provides the steps for a customer to establish a connection to their database using the SSMS client.

Before you begin

You will need:

  • A Hostek account with access to a Microsoft SQL Server database.

  • SQL Server Management Studio (SSMS) installed on your local computer.

  • The specific server address, port, and login credentials provided by Hostek.

Connecting to the database

  1. Open SQL Server Management Studio on your computer.

  2. In the Connect to Server dialog, click Server type and select Microsoft SQL Server.

  3. In the Server name field, enter the server address provided by Hostek.

  4. In the Authentication field, select SQL Server Authentication.

  5. Enter the Login and Password provided by Hostek.

  6. Click Connect.

Confirm the result

  • The Object Explorer pane will populate with the database tree.

  • You will be able to browse tables, views, and stored procedures within the database.

  • A successful connection message will appear in the status bar of the SSMS application.

Troubleshooting connection issues

This typically indicates that the server address or port is incorrect, or that a firewall is blocking the connection.

  • Verify that the server address and port number provided by Hostek are entered correctly.

  • Ensure your local network allows outgoing traffic on the specific port used by the SQL Server.

Connection fails with "Login failed for user"

This indicates that the credentials provided are incorrect or the user does not have permission to access the specific instance.

  • Re-enter the Login and Password provided by Hostek.

  • Ensure you have selected SQL Server Authentication rather than Windows Authentication.

Limitations

This procedure requires a direct network path to the Hostek server. If you are behind a corporate firewall, you may need to contact your local IT department to allow traffic to the specific port used by your SQL Server.

Did this answer your question?