[SQL2.03] Can I use Microsoft SQL Server Management Studio to manage my MSSQL database?

We run Microsoft SQL Server 2008 on our servers, only Microsoft SQL Server Management Studio 2008 is supported, earlier versions are not compatible.
This is available as a free download as part of Microsoft SQL Server 2008 Express with Tools:
http://www.microsoft.com/downloads

From your Hosting cPanel v7.5 Control Panel MSSQL Databases feature, you should be able to find the server IP address, port, username and password. To connect remotely, inside the 'Connect to Server' dialogue box (displayed on start up of Management Studio or from the menu File -> Connect Object Explorer...), you should ensure that:

Authentication is 'SQL Server Authentication'
Server name is ServerIP,ServerPort
Login and password should the username and password

Was this answer helpful?

 Print this Article

Also Read

[SQL2.01] Backup and Restore MS-SQL Database.

MS SQL databases are backed up and restored using the MS SQL Web Data Administrator tool, This...

[SQL2.02] What are valid connection strings on the Windows platform?

MySQL:Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;...