dcmorrell
asked on
command: Roles.GetUsersInRole causes: SQL Server Error
I get the error below.
it seems strange because I don't see how looking for the user's role has anything to do with SQL, seeing how I'm using checking users against an LDAP connected to active directory. Any ideas?
it seems strange because I don't see how looking for the user's role has anything to do with SQL, seeing how I'm using checking users against an LDAP connected to active directory. Any ideas?
Server Error in '/' Application.
--------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
Line 20:
Line 21: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Line 22: Dim someArray As Array = Roles.GetUsersInRole(User.Identity.Name)
Line 23: Me.lbl_test.Text = someArray(0)
Line 24:
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
what roleManager provider are you using? What does your web.config look like, i.e. what is the connection string to this provider?