Steps to deploy MVC application.
1) Changes in Web.Config, change connectionstring if you are using Windows Authentication mode then switch to SQL Server Mode in SQL Server Authentication,
Authenticate using user id and password.
2) use following connection string if you have hosted it on IIS
connectionString="Data Source=something;user id=something;password=something;Initial Catalog=databasename" providerName="System.Data.SqlClient"
3 Once you have changed the connection string,
Change the user access rights of the project main folder,
a) right click folder,
b) go to Security, in security click Edit button
c) click Add,search for IUSR or current user of the system
d) click ok, provide full access rights to the newly add user
4) Publish your website as usual
5) Do all the changes and restart your IIS
Mark as answer if you find it useful!!Best of luck Smile | :)
Thanks,
Gunaprasad