SQL server error when creating an ActionLink visible to certain roles

Question

What I want to do is to make an ActionLink visible in my page only to certain roles(in this case the "Admin" role).

When I add this code to my Layout page...

@if (Request.IsAuthenticated)
{
    if (HttpContext.Current.User.IsInRole("Admin"))
    {
        <li>@Html.ActionLink("Select Roles", "Index", "SelectRoles")</li>
    }
}

The following SQL Server error shows up:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What seems to be the problem? I observed that I cannot use classes like Membership, Roles or attributes like Authorize because the same problem appears .

Make sure your connection strings are correct. – kelsier Oct 28 '14 at 08:28 — kelsier, Oct 28 '14 at 08:28
It is right. i tried EF with it and it worked. – Stefan P. Oct 28 '14 at 08:29 — Stefan P., Oct 28 '14 at 08:29

score 0 · Answer 1 · answered Oct 28 '14 at 12:40

0

That is a pure Sql connection error, this error has nothing to do with the any roles. Check if by instance you have more than one connection string in your solution, that might be an explanation to why your connection works sometimes and sometimes not.

answered Oct 28 '14 at 12:40

mohamed_assem

123
1
2
9

SQL server error when creating an ActionLink visible to certain roles

1 Answers1