How to connect to SQL Server 2005 using SQL Server Management Studio?

DETAILS
To connect to your Microsoft SQL Server 2005 database using SQL Server Management Studio for database managment, you will need to follow the steps listed below.

Open SQL Server Management Studio, the Connect to Server Window will pop up, select/enter the following:

Server Type: Database Engine
Server Name: [The SQL server name provided by OISSite.com and found in your hosting control panel]
Authentication: SQL Server Authentication
Login: [SQL 2005 Login name]
Password: [SQL 2005 Password]

Click connect and you will be connected to the OISSite.com SQL 2005 server.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Remote Connections for SQL Server 2008

Remote Connections to the MS SQL Server are enabled for all SQL Server 2008 instances....

How can I import my database

You can import your database by going to http://sqladmin.oissite.net/. You need to login using...

How can backup/export my database

You can export your database by going to http://sqladmin.oissite.net/. You need to login using...

Can I have more than 1 MS SQL database with my hosting account?

DETAILS Yes.  You can order up to 5 MS SQL 2000 database addons per account. 

Transferring SQL 2005 databases

SUMMARYThis document provides a step-by-step guide on how to transfer your current SQL Server...