Can you check whether you can access sql server from your IIS server using OSQL/ISQL or ODBCPING.exe utilities with same login ID and password?

If you use ODBC DSN to connect SQL Server, enable SQL Trace from ODBC administrator to see any errors.

Make sure you use correct authentication method, ie you may have to configure SQL Server with windows and SQL server authentication.

Edited by - Allen_Cui on 06/04/2003 11:38:38 AM