cexceptionsharepoint
How can I re-direct the user to the standard SharePoint "access denied" page, similar to the image below?
Currently, I am throwing an UnauthorizedAccessException, but this error message is not as elegant as SP message.
throw new UnauthorizedAccessException("User does not have permission to access this list");
Any help will be highly appreciated.
By default, SharePoint has custom handling for access denied exceptions (including the redirect to the custom page) within page/webservice requests, bypassing the excepton handling in your code.
To disable this custom handling, set SPSecurity.CatchAccessDeniedException to false.
Looks like it's failing trying to open a connection to SQL Server.
You need to add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database.
In SSMS, under the server, expand Security, then right click Logins and select "New Login...".
In the New Login dialog, enter the app pool as the login name and click "OK".
You can then right click the login for the app pool, select Properties and select "User Mapping". Check the appropriate database, and the appropriate roles. I think you could just select db_datareader and db_datawriter, but I think you would still need to grant permissions to execute stored procedures if you do that through EF. You can check the details for the roles here.
Best Answer
You should be able to use SPUtility.HandleAccessDenied to do this. (You can pass in null for the exception parameter if you just want to force the Access Denied page to be displayed, but aren't actually handling an exception.)