role management problem

Hi,

Can anyone please help me? I'm so desperate. I've tried many days to fix my problem.
I've also read all the related articles. I still can't solve my problem.

I have a site with user role management which works fine in my local computer.
The problem is that when I uploaded the site, I got the following error :
==================================================================================
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)


Here's my web.config:
==============

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
<remove name="ConnectionString1" />
<add name="ConnectionString1" connectionString="Data Source=tcp:mblahblah.discountasp.net;Persist Security Info=True;User ID=SQL2005_12345_personal_user;Password=*****" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<authentication mode="Forms" />
<roleManager enabled="true"/>
<compilation debug="false"/></system.web>
</configuration>


After uploading ASPNETDB.MDF to dir \App_Data, I used DiscountASP.net SQL Tool Suite to attach the data file (MDF). No luck yet.
Anyone, please..... assist!



Johnson

Post Edited By Moderator (Aristotle [DASP]) : 2/18/2007 7:04:00 PM GMT

 

Since you are using the connection string called "ConnectionString1" you must configure your role provider to use this specific connection string. By default it uses one called "LocalSqlServer". My advice is to change your connection string name to this one.

Also, see this knowledgebase article: http://kb.discountasp.net/article.aspx?id=10413

Aristotle

DiscountASP.NET
www.DiscountASP.NET