troubleshooting Question

command: Roles.GetUsersInRole causes: SQL Server Error

Avatar of dcmorrell
dcmorrell asked on
ASP.NETMicrosoft SQL ServerMicrosoft SQL Server 2008
2 Comments1 Solution353 ViewsLast Modified:
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:
ASKER CERTIFIED SOLUTION
udaya kumar laligondla
Technical Lead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros