System DSN acct removed from db server but authentication still works!

[leveetated]

I have a mystery on my hands. I need to disable a company-wide System DSN. It's the same DSN on every computer, using the same SQL Server 2005 authentication login account.

Initially I thought, I'll just remove the SQL Authentication account used in that DSN entry on all the computers. So I deleted it - it no longer exists anywhere on the SQL Server 2005 instance.

Problem is - users can still use the System DSN to login (using an application that uses this System DSN to authenticate to the SQL Server).

Are Systems DSNs cached? I don't see how anyone can still authenticate to the SQL Server when the DSN account no longer exists! What might I be missing?

Best, and many thanks,

Lee.

 

[SQLBill]

Where did you remove it from Security>Logins? If so, you may not have completely removed it. If I don't uncheck all the databases prior to dropping (deleting) a login, I'll get the error that it doesn't remove the users from the databases.

Open one of the databases and go to Security>Users. Is the account still there?

Since you've already removed the server login, you may have to create a script to loop through each database and remove the login.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875