I wish I could lend an experienced hand here, but I can only report that I am suffering from the exact same problem with the exact same hosting provider. I can run the site fine in my Dev environment (VS2008) I tried running the site after posting using
the databases in the App_Data folder as well as attempting to configure the SQL databases for the site (and running the script) and setting up the ASP Schema.
I can however see the error message, but it hasn't yet provided me with any kind of a clue as to how to fix the problem (this is all very new to me)
When you modified the web.config did you comment out the <customErrors mode="RemoteOnly" defaultRedirect="ErrorPage.htm"/> line and set <compilation debug="true">?
The error message I get is:
Server Error in '/' Application.
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)
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: 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)
Source Error:
Line 4: Line 5: void Application_Start(object sender, EventArgs e) { Line 6: if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators"); Line 7: } Line 8:
Tagard
Member
4 Points
2 Posts
Re: Club Site in full MS SQL Server??
Feb 26, 2010 05:10 AM|LINK
I wish I could lend an experienced hand here, but I can only report that I am suffering from the exact same problem with the exact same hosting provider. I can run the site fine in my Dev environment (VS2008) I tried running the site after posting using the databases in the App_Data folder as well as attempting to configure the SQL databases for the site (and running the script) and setting up the ASP Schema.
I can however see the error message, but it hasn't yet provided me with any kind of a clue as to how to fix the problem (this is all very new to me)
When you modified the web.config did you comment out the <customErrors mode="RemoteOnly" defaultRedirect="ErrorPage.htm"/> line and set <compilation debug="true">?
The error message I get is:
Server Error in '/' Application.
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)
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: 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)
Source Error: