Accidently the primary site admin user of my sites is deleted from the
ADS of my domain. After that even I was not able to start the
sharepoint central administration and related services.
Then again we re-created the same account in ADS and my central admin
and related services started working. But still I am not able to open
the sites with my primary site admin account.
When I access the site, I get the error 'The file exists. (Exception
from HRESULT: 0x80070050)'.
But with forms authenticated users my sites are working fine with
different zone(Extranet zone). But since those user has less
privilege, I am not to able play around user permissions with that
account. Google not helped me as well.
Any help would be appreciated much
Thanks
Sudha
I just added new user and was trying to add the new user as
administrator from central administrator to my site. But using that
account also I was not able to access the site. Then again I changed
back to my orginal admin user which is solved my problem. I am not
really sure how the SID is recognized this time. But surprisingly my
problem is solved
Thanks
Sudha
I had a similar problem, where an account was recreated in AD with a
different SID, causing the "File exists" error when the user tried to
access his sharepoint site.
I was able to solve it by updating the SID in Sharepoint's UserInfo
table.
CAUTION: Use this procedure at your own risk - I am a Sharepoint
novice.
i.e.
1. Find the problem site by querying the Sites and Webs tables:
select s.Id, w.FullUrl from Sites s inner join Webs w on
s.RootWebId = w.Id
2. Find UserInfo() rows for the problem site & user:
select * from UserInfo where tp_Login='<DOMAIN>\<user>' and
tp_SiteID='<s.Id value from step 1>'
3. Compare the value in the tp_SystemID column with the AD SIDs (old
and new) for the user.
(You will have to somehow determine these SID values, and convert
them from S-n-n-n format to hex format for the comparison).
4. Update the sp_SystemID column to the new SID value for the row
containing the old SID value.
Graeme
I have same problem but with Central Admin. Opening it yields same
error and account which was used to install SP was deleted and
recreated.
Where do you think I should search for this account in db to change
SID (which db and table) ?
Thanks,
Daniel