Search Chirayu Software Solutions Blog

Wednesday, March 12, 2014

Connecting to inbuilt sql server ( express edition ) using Visual Studio

In Visual Studio 2010,
1) Goto View->Server Explorer
2) Right Click on 'Data Connections'
3) Click on Add Connection
4) In Data Source select "Microsoft SQL Server (SqlClient)"
5) In Server name enter "." or ".\Sqlexpress".
6) Select "Windows Authentication"
7) Click on "Test Connection" in bottom of window.
8) Then Select the database name in drop down.
9) Click 'OK'.

No comments: