Trying to find the connection source
- From: Mark Zuroff <mzuroff@xxxxxxxxxxxxxxx>
- Date: Mon, 08 Jan 2007 12:24:40 -0500
I am trying to get rid of a former user domain (inherited a multi-domain structure years ago and need to flatten it). Domains are Win2k AD in a parent / child structure (removing the child domain), and running SQL 2000 SP4.
Have an issue with an ASP site used for reporting from SQL 2000. It is still connecting to a database using an account from the old domain. This is showing in Enterprise Manager (Current Activity | Process Info). If the DC is taken off-line, the ASP web errors out with a SQL error.
What I have already checked:
1) Web Site (IIS Manager): Anonymous access is through another account in the domain that is staying
2) Secure Communications (site certificate): Mapping is to the same account as the web site anonymous access
3) ASP pages that call SQL are using integrated security SSPI
4) System DSN uses network login (not the mystery one)
4) Have text searched all pages for the domain name - no sign of the user (or the old domain) found
.
- Follow-Ups:
- Re: Trying to find the connection source
- From: John Doe
- Re: Trying to find the connection source
- Prev by Date: Re: data encryption
- Next by Date: Re: How to decrypt column from symmetric key encrypted by certificate
- Previous by thread: Re: How does username without login work with certificate
- Next by thread: Re: Trying to find the connection source
- Index(es):
Relevant Pages
|