Problem connecting ASP.Net to 2005 Database

[Buddha Brillian]

I have 2 connection strings in my config file. They contain the same connection information, but one has a connection for normal database connecting, and the other is for connecting to user/role/membership information.

I have moved all the user/role/membership info from the usual ASPNETDB.mdb, and set up membership info in my web.config file.

This all works locally. Also, when I connect locally and use the Live Database on catalyst2, it works fine.

However, when I make everything LIVE and connect from ASP 2.0 to the Database, I get the following error, when it attempts to check User information (User.IsInRole):

"
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 71:
Line 72: 'Check if logged in
Line 73: If User.IsInRole("Admin") Or User.IsInRole("User") Then

etc....
"

Anyone have any ideas what might cause this?

[WhiskyFudge]

Have you checked both of your connection strings are correct?

[Buddha Brillian]

Hi.

It's OK, I made a temporary fix by checking for authenticated users, rather than checking .Net2 Role Membership.