ASP Script to Test MSSQL Database Connectivity

Provided below is a simple ASP script to test MSSQL database connectivity.

 

Sample Script

Explanation about the variables used in the script:

  • Server: The MSSQL Server IP needs to be mentioned.

     

     

  • Database: Specify exact database name. For example, reseloaq_mssql.

  • UID: Mention the database user associated with the database.

  • PWD: Mention the password for the above database user.