We help IT Professionals succeed at work.
Get Started

SQL Server 2000 Cannot Grant Access to Recreated User

dr_dudd asked
Last Modified: 2012-05-09
I know its old, and yes we are upgrading to SQL Server 2008, but in the meantime I have this problem.

When I try to grant access to a database using an AD user that was deleted and recreated (they left the company and came back) SQL allows me to add the user, but they get "Access Denied" when they try to access it. I believe that SQL is somehow either linking to the old AD account GUID, or maybe the delete process doesn't quite get rid of the old one. Anyway I need to be able to grant this returning user access to teh DB, any ideas?
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE