Connecting Application to Database

The assignment content provides steps to connect a web application with a database after it is published or hosted. The steps include modifying the Web.config file, setting up the data source, initial catalog, user ID, and password for SQL Server. If the application does not connect, showing an error message, the troubleshooting steps involve starting the SQL Server service, enabling TCP/IP protocol, changing the TCP port to 1433, and restarting the SQL Server instance.

This is following steps to connect our application with database:
After published/host your web application there will be web config file before running you application
you need to add/modify your current database credential with your application:
Data Source = System Name (Name should be register as in SQL database).
Initial Catalog=Database Name.
User Id=SQL user id credential.
Password=SQL password credential.
1. In spite of changing this step when application is not connecting showing the following message at
application end:

If published application is on network:
First step attempts:
(I) Press window + R (Run window Open) and in run window type "services.msc" and new
services open find SQL SERVER(SQLEXPRESS) service start and try again it works for me
Hope Its Works for You also.
Second step attempts:
(I) Open "SQL Server Configuration Manager"
(II) Now Click on "SQL Server Network Configuration" and Click on "Protocols for Name"
(III) Right Click on "TCP/IP" (make sure it is Enabled) Click on Properties
(IV) Now Select "IP Addresses" Tab -and- Go to the last entry "IP All"
(V) Enter "TCP Port" 1433.
(VI) Now Restart "SQL Server .Name." using "services.msc" (winKey + r)
Screen Shots:
1) Open Sql Server Configuration Manager --> SQL Server Network configuration --
> Protocols for <(INSTANCE)> --> TCP/IP (double click on it).
2) Select --> IP Addresses(Tab).
3) Go to the last entry IP All and mention TCP Port 1433.

4) Press Win+R and enter services.msc.
5) Now restart SQL Server <(INSTANCE)>.