?
Solved

Can't get rid of locked user in SQL Server 2005

Posted on 2007-07-20
4
Medium Priority
?
428 Views
Last Modified: 2008-01-09
I'm having an issue deleting a user out of SQL Server 2005. This user is created by an application at install time and given access to the app's database. Somehow, the user got locked. I can uninstall the app, rid the registry of all evidence of the app, delete the login, and delete the database... but when I reinstall the app and it creates the user and database, it denies the user access back to the database. If I try to look at the user's properties in SQL, I get this message:

Property IsLocked is not available for Login '[HRSQL]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

I think I could probably unlock with an "alter login" but I don't know the password of the user and there isn't a way to figure it out.

The server is Windows 2k3 SP2 and I'm running SQL Server 2005 with the following info:

Microsoft SQL Server Management Studio                                    9.00.1399.00
Microsoft Analysis Services Client Tools                                    2005.090.1399.00
Microsoft Data Access Components (MDAC)                                    2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                                    2.6 3.0 4.0 6.0
Microsoft Internet Explorer                                    7.0.5730.11
Microsoft .NET Framework                                    2.0.50727.42
Operating System                                    5.2.3790
0
Comment
Question by:cowanbenefits
  • 3
4 Comments
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 total points
ID: 19532874
I think you are running into a bug in SQL Server. The  9.00.1399.00 is the RTM of SQL2K5. Update the SP of SQL and then try it.
0
 

Author Comment

by:cowanbenefits
ID: 19533245
Nice. That's what I get for assuming that MS Update got me up to date.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 19533329
Well I have a bug on my XP workstation that won't let it take the SQL 2K5 SP2. It seems like that it is workstations with the 2K EM are choking. A workstation with a fresh install works fine.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22689198.html
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 19593451
Glad to be of assistance. May all your days get brighter and brighter.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What we learned in Webroot's webinar on multi-vector protection.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question