How do I Create a MSSQL Database for a particular domain name ?


Windows Reseller Web Hosting comes with Plesk Control Panel. You will be able to add mssql database in Plesk Control Panel of a particular domain name. Please follow the below procedure to add a database

[1] Access your control panel at https://www.yourdomain.com:8443 [ Example :https://www.crmcell.com:8443 ]
[2] Click on Subscriptions.
[3] Click on subscription name and click on website and domains.
[4] Click on Databases
[5] Click on Add New Database
[6] Give Database name
[7] Give the Type as MSSQL
[8] Click on Add database user name and give password
[9] Click on ok

MSSQL Database Troubleshooting FAQs

How to reset database login details ?

Solution :

[1] Access your control panel at https://www.yourdomain.com:8443/
[2] Click on Subscriptions.
[3] Click on Control panel of that domain and click on website and domains.
[4] Click on Databases
[5] Click on Database name
[6] Click on Database user name
[7] Give new password [ Note : password should be tough which consists of alphanumeric characters ]
[8] Confirm the password
[9] Click on Ok

I am getting error A network-related or instance-specific error while accessing SQL Management Studio ?

Solution :

If your ip address is not allowed in server firewall then you will get an error ” A network-related or instance-specific error”. To add ip addresses, follow the steps given below

[1] Login to your plesk control panel
[2] Click on the domain name you wish to add the ip for sql access from the subscriptions list
[3] Click on Websites and Domains option in your control panel
[4] Click on AddSQLIP button in the control panel
[5] Supply the IP Address and submit
[6] Wait for 15-20 min to get your ip reflected in the firewall

Then you can access the database via sql management studio.

I am getting error ” Ip address is already exist in firewall “

Solution :

Please note that the given ip address XXXXX is already present in the server firewall. So you no need to add ip address again. You can able to connect the database by using below mentioned connection steps:

Server type : Database engine
Server name : server ip
Authentication : SQL server authentication
Login : database username
Password : database password

ISP is not valid

Solution:

Please note that the ISP of the mentioned ip address is not a valid ISP. Kindly update us the ISP name which you are using and also visit http://getmyip.co.in/ and update us the screen shot in order to check at our end.

I am getting error “Login Failed for user” while accessing mssql database ?

Solution :

Kindly reset the database login details and check at your end

[1] Access your control panel at https://www.yourdomain.com:8443/
[2] Click on Subscriptions.
[3] Click on Control panel of that domain and click on website and domains.
[4] Click on Databases
[5] Click on Database name
[6] Click on Database user name
[7] Give new passwrod [ Note : password should be tough which consists of alphanumeric characters ]
[8] Confirm the password
[9] Click on ok