Hi,

I'm having a BIG problem, this is my 3rd day looking for answer !

I'm trying to create a custom membership provider with MS SQL database 2005 but not the default ASPNETDB.
I've changed the web.config to be as following:

But when I try to login to the site using the login control the following error occurs:

Line 149:    <roleManager>
Line 150:      <providers>
Line 151:        <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 152:        <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 153:      </providers>

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.213

 It is clear that this is a prblem with my Machine.Config file - since I've "worked!" on this file for a while. But when I've checked the Machine.config file I've found the LocalSqlServer connection it is talking about! .

I'm lost and I dunno what to do, can anyone help?

Here is the mahine.config in case if you need it:

 hi

i don't know this will help u or not but i think u r trying this connection with wizard but try it with codes .

here i have some of them .

public partial class _Default : System.Web.UI.Page
{  
    SqlConnection con = new SqlConnection();
    DataSet ds = new DataSet();
    SqlDataAdapter da = new SqlDataAdapter();
    protected void Page_Load(object sender, EventArgs e)
    { 
        SqlConnection con = new SqlConnection("uid=sa;pwd=sa;database=office");//codes for Sql connection .
        SqlDataAdapter da = new SqlDataAdapter("select*from record",con );
        SqlCommand cmd = new SqlCommand();
        DataSet ds=new DataSet() ;
        da.Fill(ds, "tbl1");
//Connectivity through SQL in gird view
        GridView1.DataSource = ds;
        GridView1.DataBind();
        DataTable dt = ds.Tables[0];
/
    }

I believe the connectionStringName element is case sensitive. Try this.

1    <connectionStrings>
2    
3    <add name="sqlConn" connectionString="Data Source=.;Integrated Security=True;Initial Catalog=ASPNETDB;"
4    providerName="System.Data.SqlClient" />
5    
6    </connectionStrings> <system.web>
7    
8    <trace enabled="true" />
9    <roleManager enabled="true" />
10   <authentication mode="Forms" />
11   
12   <membership defaultProvider="MySqlProvider">
13   <providers>
14   
15   <remove name="AspNetSqlProvider"/>
16   <add name="MySqlProvider" connectionStringName="sqlConn"
17   type="System.Web.Security.SqlMembershipProvider" applicationName="/" />
18   
19   </providers>
20   </membership>

 The problem was fixed. But just for records, The connection string was written in the Web.Config file and not by wizard .. Thanks!

manchanda:

 hi

i don't know this will help u or not but i think u r trying this connection with wizard but try it with codes .

 

here i have some of them .

public partial class _Default : System.Web.UI.Page
{  
    SqlConnection con = new SqlConnection();
    DataSet ds = new DataSet();
    SqlDataAdapter da = new SqlDataAdapter();
    protected void Page_Load(object sender, EventArgs e)
    { 
        SqlConnection con = new SqlConnection("uid=sa;pwd=sa;database=office");//codes for Sql connection .
        SqlDataAdapter da = new SqlDataAdapter("select*from record",con );
        SqlCommand cmd = new SqlCommand();
        DataSet ds=new DataSet() ;
        da.Fill(ds, "tbl1");
//Connectivity through SQL in gird view
        GridView1.DataSource = ds;
        GridView1.DataBind();
        DataTable dt = ds.Tables[0];
/
    }

 Thanks jguadagno,

The problem was the incomplete/incorrect membership provider.

Thanks!

jguadagno:

I believe the connectionStringName element is case sensitive. Try this.

 

1    <connectionStrings>
2    
3    <add name="sqlConn" connectionString="Data Source=.;Integrated Security=True;Initial Catalog=ASPNETDB;"
4    providerName="System.Data.SqlClient" />
5    
6    </connectionStrings> <system.web>
7    
8    <trace enabled="true" />
9    <roleManager enabled="true" />
10   <authentication mode="Forms" />
11   
12   <membership defaultProvider="MySqlProvider">
13   <providers>
14   
15   <remove name="AspNetSqlProvider"/>
16   <add name="MySqlProvider" connectionStringName="sqlConn"
17   type="System.Web.Security.SqlMembershipProvider" applicationName="/" />
18   
19   </providers>
20   </membership>

  Look at line 16.