I set up everything in development. The roles works fine. Then I used a script to copy/recreate the dev database to my godaddy.com server (shared hosting). I copied all my web files to godaddy, (with a reconfigured web.config).
But now, it bombs in production (prod). When <roleManager enabled = "true"> in my web.config, I get the following error msg. However, if this is set to "false", it is able to connect to the prod DB. But of course, my roleManager is then not working.
"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) "
In WSAT, I click the PROVIDER link and then click "Select a different provider for each service (advanced)" link. There are two providers listed:
Membership Provider. The test link connects to the DB.
Role Provider. There are 2 items here. The AspNetSqlroleProvider has the radio button selected. The test link for this item fails. The following error message appears:
"Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
In my web.config, I only have a Membership provider:
<roleManager enabled="true" />
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="apt" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
Do I need to have a provider for Roles? I don't have a deep understanding in this area so I've been just trying to follow the book lead/example. Hence, I am really at a loss on how to diagnose this further. I've spent at least a 1/2 day stuck ... of course, I've tried searching the Internet forums for answers but to no avail ... help is appreciated ... thanks!