Hi Kumar,
Quote:
MVC Hosting tips with database
I would like to let you know while deploying the MVC application in web.config,
connection string please change your string,use
SQL Server Mode
rather than using normal
Windows Authentication mode
in SQL Server,set
userid=""
and
password=""
in your connection string, use following connection string if you have hosted it on IIS
<br />
connectionString="Data Source=something;user id=something;password=something;Initial Catalog=databasename" providerName="System.Data.SqlClient"
- Once you have changed the connection string,
- Change the user access rights of the project main folder IUSR in your case
- Publish your website as usual
- Do all the changes and restart your IIS
Mark as answer if you find it useful!!Best of luck :)
Thanks,
Gunaprasad