Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-12 : 09:05:08
|
| Stephen writes "I had a user in the database that used NT authentication (this was actually the account used for anonymous access on a web server). For one reason and another this account was deleted in NT by the systems administrator and then recreated. However this then stopped the web site working!I deleted the user from the database. I checked with sp_helpuser and looked in sysuser and indeed the user appeared to have gone. Also no roles were left that referenced this account.However, when I try and add the user again it throws an error telling me that the user already exists. Any ideas why this might be the case?(Apologies if this is not hard enough for you! I searched the FAQs and umpteen other SQL Server sites and still haven't found the answer!)Many thanksStephen" |
|
|
|
|
|
can't recreate a user