A network-related or instance-specific error occurred while establishing a connection to SQL Server. MVC Role Authorization

Asked Jan 01 '16 at 15:43

Active Jan 03 '16 at 17:49

Viewed 32 times

This appears to have solved the issue. In modules in web config, I added this line...

I am attempting to limit access to a controller class by role:

namespace tvc.Controllers
{
    [Authorize(Roles="Admin")]
    public class productsController : Controller
    {

User management is working in my application. I'm able to create users, assign roles, log in, etc. However, when I add (Roles="Admin") to the [Authorize] attribute, I get the SQL Server error. I'm guessing that MVC is looking for the local database (in app data), but I don't know where I'd change that behavior and this is production and a remote DB is used.

I would like to know why I'm getting this error and how to properly use the role attribute.

edited Jan 03 '16 at 17:49

asked Jan 01 '16 at 15:43

tintyethan

1,772
3
20
44

1

Check your web.config for connection string and update that to the correct one (db server/user credentials etc) – Shyju Jan 01 '16 at 17:49
yes - defaultconnection is set to remote db and used succesfully for user administration – tintyethan Jan 01 '16 at 17:53
might also be ` ` or the mvc5 ` ` – Mark Schultheiss Jan 02 '16 at 17:50

A network-related or instance-specific error occurred while establishing a connection to SQL Server. MVC Role Authorization

0 Answers0