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

rrhandle8Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
rrhandle8Connect With a Mentor Author Commented:
The problem is that a shared MSSQL database will not allow you to create addtional database.
0
 
guru_samiCommented:
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
0
 
rrhandle8Author Commented:
I am wondering if it is even possible to use a shared mssql database???  Maybe I should use Access.
0
 
guru_samiCommented:
--->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?
0
All Courses

From novice to tech pro — start learning today.