Test the Database Connection String in Visual Studio

Option 1: Check if the database connection string is created
1) Start your program on visual studio and check on the server explorer if “.\
sqlexpress.college.dbo” connection is created as below.
2) If the “.\sqlexpress.college.dbo” is not created create it as follows
i. Select the server explorer.
ii. Right click and add new connection.

iii. Select server name as “.\SQLEXPRESS” and select or enter the database name to
connect as “college” as below.

iv. Test the connection by clicking the “Test connection” button.
Now connection is successful as above, click ok and ok button.
v. Now run the program and see if it will run successfully.

Option 2: ALLOW SERVER REMOTE CONNECTION
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 click apply and ok.

4) Open Sql Server Configuration Manager --> SQL Server Network configuration --
>SQL server services--> sql server (SQLEXPRESS)-->Right click --> Restart.
5) Press (Win KEY+R) and enter services.msc go to start -> enter Run-> Click RUN->and
enter services.msc then ok.

6) Select the standard tab and select SQL SERVER(SQLEXPRESS).

7) Right click on the SQL server(SQLEXPRESS)->properties->start type-> select to be
automatic

8) Click apply then ok

9) Now the SQL server (SQLEXPRESS) will be running automatically.

Option 3 : SET AND ENABLE THE TCP/IP CONNECTION
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 and click ok.

vi. Now Restart "SQL Server