Link to home
Start Free TrialLog in
Avatar of vmandem
vmandem

asked on

I get access denied error in sharepoint after restore database

I recently setup the development environment and installed MOSS 2007. The environment matches exactly my production environment. I copied the production content database and restored to the newly created website.
1) I created Site collection administrators with the default admin account
2) Farm level administrator with default admin account
3) Authentication provider is windows authentication.
I got no issues until here. I also checked that there are two sites restored.
Then I went to browser to navigate to the URL i gave during configuration and logged as admin but I get access denied error. What else could be wrong and I'm not able to see the site.

Thanks
VM
ASKER CERTIFIED SOLUTION
Avatar of PillalamarriVenkateswaraRao
PillalamarriVenkateswaraRao
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vmandem
vmandem

ASKER

I copied the database from production and restored to a new databae. Then I used stsadm command to attach the restored database to the newly created web site. Before that I deleted the database created by the website. Everything went well and compared the production central admin and both look same.
As far as the Site Collection Administrators I'm using the default System Account because I have not connected to Active Directory to the server but the production is tied to Active Directory.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
How was this resolved?  The "Accepted Solution" cannot possibly be correct...
vmandem,

SwissMeat has asked (at https://www.experts-exchange.com/questions/25853575/19-Apr-10-15-Automated-Request-for-Attention-Q-25019667.html) for an explanation of why you allocated the points as in the way you have for this question.

Remember that if multiple Experts help you to find a solution, you should split the points between the experts by pressing the "Accept Multiple Solutions" button beside any Expert comment. This will open the Point Split page, where you can indicate the award you wish to make for each Expert comment. Remember that all no matter how many points you award to each Expert, they must total the number of points offered in the question - in this case, 125 points.

Please also remember that an answer of "You can't do that" is sometimes the only answer to a question. If that is in fact the answer, it should be accepted as the solution, with an appropriate grade awarded. However, if a solution other than "You can't do that" is given which is valid and workable, then obviously that solution should be accepted instead, as the proposed "You can't do that" solution is obviously incorrect.

Please respond to this request within the next 4 days with an explanation of the award you made for this question. After this time, a Moderator will re-review this question, and may change the point allocation as they see fit. If you wish for the point allocation to be changed, please also indicate that here, and a Moderator will help you.

EXPERTS - Please leave your recommendations here as to how you wish to see this question closed. They may be one of the following:

1) Deleted (With or Without a point refund)
2) PAQ'ed, with points refunded to the asker
3) An Expert Comment Accepted
4) Points 'Split' between more than one expert comment

For #3 or #4, please include the specific post IDs (in the form http:#a) to be used for the Point Award / Split.

Thank you,

CoolLeoMod
Community Support Moderator