How do i connect to SQL Server database?

1. Download sql server management studio express and instale it.
link is :
www.brothersoft.com/sql-server-management-studio-express-62057.html
or 
search keyword from google.com
free download sql server management studio express

2. Steps to connect the database

Supply these detailes in connect window

a. Server type : database engine
b. Server name : Sqlplesk5.securehostdns.com,1533
c. Authentication :SQL server authentication
d. login : username of your database (create database user from your control panel)
e. Password : type your password (create database password from your control panel)

Please create database name , database user and password from your control panel.

------------------------------------------------------------------------------------------------------------------------

How to create Database

1. Login into your Plesk control panel.
2. Click on 'Websites & Domains'.
3. Click on 'Databases'.
4. Click on 'Add New Database'.
5. Put database name.
6. Select database type. (Mysql/MSSQL)
7. Select databsae version.(Mysql5, MSSQL2005, MSSQL2008)
8. Click on OK.
  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

DO YOU ALLOW REMOTE MYSQL ACCESS IN YOUR SERVERS?

Yes, to manage your databases remotely you will need to add an "access host" via the MySQL...

DO YOU PROVIDE POSTGRESSQL FOR YOUR ACCOUNTS?

Yes. We do provide PostgresSQL interface for all cPanel users.

DO YOU SUPPORT MS SQL?

No, we do not support MS SQL.

HOW DO I CONNECT TO MY DATABASE USING A PROGRAM?

If you wish to administer your database from your own computer, via a program like navicat...

HOW DO I CREATE A MYSQL BACK-UP?

1.  First log in to your Cpanel 2.  Click MySQL  Databases...

Powered by WHMCompleteSolution