Re: Removing users from WSS 2.0

Let me second Mike's recommendation to never delete things in SQL. Bad things happen.

Keith Ritchie makes a suite of utilities that fill in some of the holes of SharePoint administration. I believe his tool WSSUserUtil will completely remove users from sites and server. Give that a shot and see if it works better for you.

tk
"Patty" <Patty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D1CAA2BC-3F79-440E-B34B-9BFCF08CD0E2@xxxxxxxxxxxxxxxx
Thanks Mike. I did try removing the user from the site collection, in top
level administration, in view site collection user information after removing
users from the iste (manage users). When I recreate the user, a random
number is applied to the user name. It is not gettng deleted. Where else
can i look?

If we reboot the server, it works....but I hate to do that.

"Patty" wrote:

I remove a user from the site collection (Manage site collection users from
top level admin) and manually delete the row from the SQL Server database. I
enter the username again and a random number is added to the username,
although it appears to be a new user. What am I doing wrong?

Thanks!

Patty

.

Relevant Pages

  • Question about AD 2000
    ... which is stored in a SQL server database....So user logs in, the username is ... permissions set are granted. ...
    (microsoft.public.windows.server.active_directory)
  • Windows authentication on SQL
    ... We are about the replace our SQL 7 server running on NT 4.0 Enterprise to ... Windows 2k with SQL 2k - we will buy and install a new server and then move ... running the SQL with the same username & password as the user have on the ...
    (microsoft.public.sqlserver.security)
  • Windows authentication on SQL
    ... Use sql authentication, not windows authentication. ... >We are about the replace our SQL 7 server running on NT ... >running the SQL with the same username & password as the ...
    (microsoft.public.sqlserver.security)
  • Crystal Enterprise manager
    ... When we look at the Server properties it says it is a Windows Server ... not have SQL except the SQL that is part of sharepoint ... The Install Says SQL Servr is configured for Windows Only ... Input an NT Username to create a Database. ...
    (microsoft.public.vb.crystal)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)