Portal Home > Knowledgebase > Windows Hosting > How to Config Database connection in Windows Hosting with Plesk panel


How to Config Database connection in Windows Hosting with Plesk panel




How to Config Database connection in Windows Hosting with Plesk panel

In web.config file



<connectionStrings>
<add name="dbConnectionString" connectionString="server=162.17.198.296;user=usdhar;password=ad123;database=admin_db"
providerName="System.Data.SqlClient"/>
</connectionStrings>

note : change the Server IP, User Name, Password, Database name to yours

write this code in web.config file before starting

here database ip, database user name, database password & database name used.

from control panel there is a option to create database & after clicking on the database .. there is a option " create user " from there create user & password of database. to create table that can be done by using " EMS - SQL Manager lite for sql server "  software or from " web admin " option of database from control panel.

in ems sql manager there is an option to register database there u have to give the ip address of database then database user name & password ( tick on sql authentication ) then after few sec a new dialogue box will open there from the top combo box select your created database name from the list of database available in the server. next next etc .. then in the left side that database will be listed. double click there. server database will be connected. from there you can see your database's user name .. expand it .. table (0) will be there. right click - new table .. give table name .. from the field tab .. create fields ( left side new field option ) at last click on compile ( left side option )

thats it.


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

Powered by WHMCompleteSolution