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.