Hi Will,
Quote:
Can someone please help me and explain why can't I just upload the database
and connect it in the normal way? and what I need to do exactly?
|
It seems that you are trying to attach an MSSQL DB. We don't support MSSQL user instances on Shared servers.
I would recommend you to follow these steps to get your Database working :
a) Create a blank MSSQL DB from Plesk control panel.
b) Take a backup of your DB in .BAK format from local PC & upload the BAK file into your webspace.
c) Provide us the exact location of your DB-BAK file & update your connection string with the new DB details.
d) [We will get the DB-BAK] restored into your blank DB properly, once done, you can access the DB through your scripts.
Quote:
Is it as simple as just creating a .BAK file? What happens behind the scene?
Do you guys copy the backed up database and transfer all the table to the
database I created in Plesk? Do you transfer the data for us? How does it work?
|
Under Plesk CP, when you create a
website hosting, a application pool user (IWAM user) also gets associated with it and your web applications run under this user. So for attaching the DBs and assigning privileges to this user is security thread. So we restore .bak file on your bank DB and it runs under the DB user created under Plesk CP.
After the DB gets restored from bak file, you will need to change your connection string in web.config file as follows:
<add name="ConnectionString" connectionString="Data Source=Server IP\SQLEXPRESS;Initial Catalog=Database Name;User ID=DB_User;Password=DB_PWD" providerName="System.Data.SqlClient" />