SQL Server Management Studio Express is available for free from Microsoft:
Navigate to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.
Upon opening the program, you should be prompted with a Connect to Server box. Fill out the fields with your database information.
Try our troubleshooting service
- Microsoft Certified Engineers
- Remote Log-in to Your Servers
- End-to-End Troubleshooting
Our Certified Technicians have been supporting Microsoft® products for well over a decade.
Tell us where you are getting stuck
Having Trouble Implementing This Solution?
Why not let our Microsoft® Certified Engineers do it for you.
Just $50.00 one time fee.
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.
Then type in the Name of the Database you wish to connect to, and Click Connect.