There is a permissions error in the Fan log in. To fix it Go to TOOLS in the Visual Studio menu, choose SQL, NEW QUERY. Connect the database to .\sqlexpress. Type in the following SQL.
Use ShowTracker Grant Select on FanLogin to FanRole
Once you run this code you should have the permissions you need
There are a couple of other common problems.
In the Login class there is a line (47) that assigns the userkey to key
key = u.ReviewerKey;
For some reason with the showtracker database we have to cast this to an int
key = (int)u.ReviewerKey;
Finally, be aware the random seed that is concatenated with the password is "LoginRandom" in the fanlogin table, not "FanKey" or "FanLoginKey."
No comments:
Post a Comment