Developers community number 1 connection string reference

ConnectionString for online webSite

Posted 2010-07-31 15:22
by Owais kia
in the SQL Server Forum
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
Reply 2010-08-03 12:16
by Max Wikström
in the SQL Server Forum
Hi

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.

Did this help?
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.