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

How do I assign additional SQL logins to my SQL 2005 database?

SUMMARYThis document details the step-by-step instructions on how to assign a SQL login...

Can I have more logins for my MS SQL database?

DETAILS Yes.  In addition to the default login assigned for each SQL database addon, you...

How do I change the default database of a database login in SQL 2005?

SUMMARYThis document details the step-by-step instructions on how to change the default...

Can I connect to your SQL server using an alternative port?

DETAILS No, the only open port is 1435.  If you find that your ISP or firewall is blocking...

If I send you a backup (.bak) of my SQL Database, can you restore it?

DETAILSYes.  We do restore database backup files from your SQL Server.  But you have to...