Unable to to remove SQL Server Users

[YL5956]

We have a Coldfusion application that has the authority to delete and create SQL Server users.

We are running into the problem where when we perform a delete the user account is removed from Enterprise manager, but when we try to recreate the account, SQL Server comes back with a user already exist error.

How can we clean up the user table? Where are these tables located? Any help would be greatly appreciated.

 

[SonOfEmidec1100]

Maybe the delete process is just be removing the users permit access to the database(s). Using EM if you goto Security/Logins can you still see the user accounts there, if so right click and delete the user. You will need administrator rights.

Maybe this helps.

 

[camy123]

check the master database that where the security details are held is it may be a refresh problem wiht you Odbc connection most likely ADO... if yu are using ado/ado.net are u closing your connection and opeing a new one..
??? i cant see it beeing the database....also check if u are actually deleting the actual user or the permisions of the user....

 

[SQLBill]

What command is being run by the ColdFusion app to delete the user?

-SQLBill

Posting advice: FAQ481-4875