Sunday, September 18, 2011

Test SQL Connectivity Without Management Studio

If you need to test SQL connectivity from a web to the database server and not just ICMP or TCP without having to install the SQL Client Tools, you can use the ODBC control panel applet to setup a data source using the connection parameters you want to test

1) Open the ODBC applet and click Add to add a user data source

2) Choose SQL Server as the driver for your data source

3) Provide any name for the data source and type the correct name of your SQL server

4) Choose your method of authentication.

5) Finish the wizard and click Test Data Source

No comments:

Post a Comment