Link to home
Start Free TrialLog in
Avatar of dcmorrell
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?
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:

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of udaya kumar laligondla
udaya kumar laligondla
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thecoon
thecoon

what roleManager provider are you using?  What does your web.config look like, i.e. what is the connection string to this provider?