Computer Science Era

Advertisement
Showing posts with label add database connection in visual studio. Show all posts
Showing posts with label add database connection in visual studio. Show all posts

Friday, 28 February 2014

1st step: Open Server Explorer by Pressing Ctrl+Alt+S and Click on Add Connection

add-connection-in-server-explorer

2nd step: Click on Change Data Source in Add Connection Window

click-change-button

3rd step: change Microsoft SQL Server Database File to Microsoft SQL Server and Press OK

click-on-Microsoft-SQL-Server

4th step: Select the Server Name by clicking on icon of drop down menu

select-server-name

5th step: select the database name by clicking on icon of drop down menu

select-database-name

6th step: Click on Test Connection Button

test-connect

7th step: Test Connection Succeeded and Press OK

test-connection-succeeded

8th step: Press OK in Add Connection window

press-ok

Finally, Database Connection is visible now Server Explorer

data-connection-of-database-in-visual-studio