Hi all.
I am using the SQL Server authentication to control access to a SQL Server 2000 database via a web front end.
If I enter an invalid username & password, SQL Server (quite reasonably) returns a page of the form:
ERROR: 401 Access Denied
HResult: 0x80040e4d
Source: Microsoft SQL isapi extension
Description: Access denied
This is all well and good from a security point of view, but I want to be able to provide a customized message, and format the page to match the rest of the site. I have investigated the IIS 'custom error message' pages, but these appear to be separate from SQL's own errors.
It is not possible to switch to Windows authentication, I have to stick with SQL logins.
Does anyone know how to customize this message? Thanks in advance.
--
Joe
I am using the SQL Server authentication to control access to a SQL Server 2000 database via a web front end.
If I enter an invalid username & password, SQL Server (quite reasonably) returns a page of the form:
ERROR: 401 Access Denied
HResult: 0x80040e4d
Source: Microsoft SQL isapi extension
Description: Access denied
This is all well and good from a security point of view, but I want to be able to provide a customized message, and format the page to match the rest of the site. I have investigated the IIS 'custom error message' pages, but these appear to be separate from SQL's own errors.
It is not possible to switch to Windows authentication, I have to stick with SQL logins.
Does anyone know how to customize this message? Thanks in advance.
--
Joe
