Provided below is a simple ASP script to test MSSQL database connectivity.
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.