Your website logs in (usually) via a different login than you do. The security for that login needs to be reset on the restored database. What happens is the SIDs get out of sync.
These are also known as orphaned users.
Start here (MSDN link):
http://msdn.microsoft.com/en-us/library/ms175475.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA