logo

Test the Database Connection String in Visual Studio

   

Added on  2023-04-23

16 Pages405 Words479 Views
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.
Test the Database Connection String in Visual Studio_1
iii. Select server name as “.\SQLEXPRESS” and select or enter the database name to
connect as “college” as below.
Test the Database Connection String in Visual Studio_2
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.
Test the Database Connection String in Visual Studio_3
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).
Test the Database Connection String in Visual Studio_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
This is following steps to connect our application with
|3
|307
|412

STEPS TO CONNECT TO AZURE ACCOUNT AND MySQL WORKBENCH Step 1:
|4
|206
|66

Setting up Actions on Windows System
|13
|616
|473

Assignment on Internet Working with TCP and IP
|14
|849
|105

Remote Desktop and PuTTY Connection for Network Systems
|15
|2745
|137

IT Technical Support
|21
|2363
|76