Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Intellect Connect

Connect to a Database using Studio Express

SQL Server Management Studio Express is available for free from Microsoft: Download SQL Server Management Studio express

Step 1

Navigate to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express. kb-sql-connect-db-3

Step 2

Upon opening the program, you should be prompted with a Connect to Server box. Fill out the fields with your database information. kb-sql-connect-db-2

Step 3

The Server Name field is the IP of the Database Server. You also must include “,2433′ after the IP to specify port ’2433′. The Authentication field should be ‘SQL Server Authentication’ by default. The Login field is the username you have set up for the database. The Password field is the password you have set up for the user. Optionally, to connect to a specific database only, Click on the “Options” button. Then click on the “Connection Properties” tab. kb-sql-connect-db-1 Then type in the Name of the Database you wish to connect to, and Click Connect.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.