Sql-server How to establish a connection with Visual Studio

Sql-server How to establish a connection with Visual Studio

1. Open the database.
   

   650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/91/43/wKiom1j0yN2xsbTDAACKciG0evc200.png-wh_500x0-wm_ 3-wmp_4-s_638833808.png "title=" Database Sql-server "alt=" Wkiom1j0yn2xsbtdaackcig0evc200.png-wh_50 "/>

2. Right-click to create a new database wl.

3. New table:

   You can create them manually or by using commands.

4. Click the WINS icon on your computer, enter Sql-server Configuration Manager at the command line, click Sql-server Configuration Manager, click

Right-click TCP/IP, tap Start, and then double-click.

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/91/45/wKioL1j01BGAtcYIAAFi_c-VaVw084.png-wh_500x0-wm_ 3-wmp_4-s_172399189.png "title=" Qq20170417224006.png "alt=" Wkiol1j01bgatcyiaafi_c-vavw084.png-wh_50 "/>

5. Click IP, enter your own IP and port number in the last one. 650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/91/45/wKioL1j01MuQ_h_6AADqLtdKKrw837.png-wh_500x0-wm_ 3-wmp_4-s_3352874047.png "title=" Qq20170417224006.png "alt=" Wkiol1j01muq_h_6aadqltdkkrw837.png-wh_50 "/>

6. Click Apply.

7. Restart the database.

Sql-server How to establish a connection with Visual Studio