ConnectionString for online website
i uploaded my webSite online by using PLESK
i need to change my ConnectionString
add name="DB"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|\XXX.mdf;
Initial Catalog=|DataDirectory|\XXX.mdf;
User ID=XXX;
Password=XXX;
suggest changes please
1 answer
Is the SQL Server a local SQL Express version on the site host server?
If not, you need to know the name (address) of the server running SQL Server. That name should replace the ".\SQLEXPRESS" value.
You also need to know the user name and the password for the SQL Server account to use when connecting.
You should get this info from the staff or the site of the hosting company.