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

To connect to your Microsoft SQL Server 2005 or 2008 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 WebHostForASP.NET and found in your hosting control panel],1750
Authentication: SQL Server Authentication
Login: [SQL 2005 or 2008 Login name]
Password: [SQL 2005 or 2008 Password]

Click connect and you will be connected to the WebHostForASP.NET SQL 2005 or 2008 server.

Note : Our database is configured on port 1750, and you need to write the servername,port number in the server field.

Please make sure your ISP does not block port 1750.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I obtain the MS SQL Server or Host Address?

Follow these steps below to get that information : Login to your DotNetPanel :...

Can I set up additional logins for my MS SQL database?

No. You cannot setup additional logins for your MS SQL database.

How do I obtain the MS SQL database disk usage?

For our user's convenience, we provide a SQL disk space usage meter in the MSSQL Manager section...

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

Yes. You can order unlimitted MS SQL database add-ons per account. You can order your SQL...

Do you support SQL Server Integration Service?

SQL Server Integration Service (SSIS) is not supported.