Configure ODBC Connection SQL Server

When we build a SQL database or SQL AlwaysON, how do we test if the connection is OK?

One way is to "Configure ODBC-connected SQL Server"

1. Open ODBC Data Source Manager: Control Panel--〉ODBC Data source

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image002 "border=" 0 "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/M01/72/56/ Wkiom1xhfwtq7m6maae8x22q04m753.jpg "" 558 "height="/>

2. Add a User DSN

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image004 "border=" 0 "alt=" clip_image004 "src=" http://s3.51cto.com/wyfs02/M02/72/56/ Wkiom1xhfwxzjz7oaae22bdg5zs289.jpg "" 557 "height=" 427 "/>

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image005 "border=" 0 "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/M00/72/56/ Wkiom1xhfwxd_jpuaaeztrktbym749.jpg "" 556 "height=" 459 "/>

3. Enter the data source name, description, server address (can be SQL standalone server or cluster IP address/fqdn name)

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image007 "border=" 0 "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/M00/72/56/ Wkiom1xhfwazcu_kaafyj9j20tu596.jpg "" 557 "height=" 435 "/>

Select the authentication method for the connection database (Windows authentication or SQL authentication), where I use Windows authentication

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image009 "border=" 0 "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M02/72/52/ Wkiol1xhgslwxsjkaagj__wytwq648.jpg "" 557 "height=" 436 "/>

4. Select the database name for the connection test, other default

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image011 "border=" 0 "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/M00/72/52/ Wkiol1xhgsoa2fhmaafaekbyy-4071.jpg "" 557 "height=" 433 "/>

Next

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image013 "border=" 0 "alt=" clip_image013 "src=" http://s3.51cto.com/wyfs02/M01/72/52/ Wkiol1xhgssgbtv_aahhuwsyawq393.jpg "" 557 "height=" 434 "/>

Complete

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image014 "border=" 0 "alt=" clip_image014 "src=" http://s3.51cto.com/wyfs02/M02/72/52/ Wkiol1xhgswy6aqdaahqfqroyra372.jpg "" 439 "height=" 502 "/>

5. Start testing the data source.

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image015 "border=" 0 "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/M00/72/52/ Wkiol1xhgsxx5rz_aaekj68vw4o677.jpg "" 438 "height=" 502 "/>

You can see from the picture above that the connection was successful, and that SQL SERVER 2012 ODBC was configured successfully.

Also, be aware that the SQL Server firewall port is open for exceptions or shutdowns when testing, and the default port is 1433.

650) this.width=650; "Style=" background-image:none; border-bottom:0px; border-left:0px; padding-left:0px; padding-right:0px; border-top:0px; border-right:0px; padding-top:0px "title=" clip_image017 "border=" 0 "alt=" clip_image017 "src=" http://s3.51cto.com/wyfs02/M01/72/52/ Wkiol1xhgsajeekwaae7av4p7iy123.jpg "" 557 "height=" 431 "/>

Configuration is complete.

Configure ODBC Connection SQL Server