asked on

Connect to remote MSSQL for ASP.NET membership and roles

I am trying to use SQL Server with the built-in "membership" function in ASP.NET.

I have a shared SQL Server database on a shared hosting provider.

In the webconfig file, I added the XML below, but when I bring up the ASP.NET configuration screen from within VWD2008, and click on the Security tab, it tells me I do not have permissions. Any ideas?

Username and password have been altered in the code below to protect the site.

<connectionStrings>
    <add name="usharborConn" connectionString="Data Source=72.18.135.40,1533;Initial Catalog=usharbor;Persist Security Info=True;User ID=admin;Password=knot25" />
  </connectionStrings>

    <membership defaultProvider="usharborProvider">
      <providers>
        <add name="usharborProvider"
             type="System.Web.Security.SqlMembershipProvider"
             connectionStringName="usharborConn"
             applicationName="usharbor_2"
             minRequiredPasswordLength="5"
             minRequiredNonalphanumericCharacters="0" />
      </providers>
    </membership>

Open in new window

guru_sami

You can't use asp.net website admin tool to access remote membership DB.
For the you have two options...
1: Write your own administrative pages using membership and roles API:
http://www.asp.net/web-forms/security/
Or
2: Integrate already created tool in your site: http://aspnet.4guysfromrolla.com/articles/052307-1.aspx

rrhandle8

ASKER

I am wondering if it is even possible to use a shared mssql database??? Maybe I should use Access.

guru_sami

--->I am wondering if it is even possible to use a shared mssql database???
What problem are you facing ? and that question is related to membership or in general?

ASKER CERTIFIED SOLUTION

rrhandle8

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial