1. To create tables on your Windows hosting account

a) First create the database from Plesk. Here is a guide

https://truehost.co.ke/support/knowledge-base/how-to-create-database-on-windows-hosting/

b) Connect to the database using SQL Server Management Studio using the database name, username and password you selected in Step 1 then create the table. Here’s a guide on how to connect.

https://truehost.co.ke/support/knowledge-base/how-to-connect-remotely-to-mssql-database/

2. For the database configuration, access Plesk >> File Manager>>httpdocs then open the file called web.config. under <connection string>, add the following code

<add name=”connect” connectionString=”data source=YourDomainName;Initial Catalog=YourDatabaseName;User ID=YourDatabaseUser;password=YourDBPassword~;Connection Timeout=60000;” providerName=”System.Data.SqlClient” />

Replace the following:

YourDomainName with your actual domain name

YourDatabaseName with database you created in Step 1

YourDatabaseUser with database user you created in Step 1

YourDBPassword with database password you created in Step 1