SqlMembershipProvider trouble

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jeff

    SqlMembershipProvider trouble

    hi

    asp.net 2.0
    sql server 2005

    I've created a database on my win2k3 machine. Now I'm moving this database
    over to my Vista business 32bit machine. (I scripted the database on the
    win2k3 machine).

    Now when I open the Web Site Administration Tool I get this error message:
    The 'System.Web.Sec urity.SqlMember shipProvider' requires a database schema
    compatible with schema version '1' However the current database schema is
    not configured with this vesion. You may need to either install a compatible
    schema with aspnet_regsql.e xe (available in the framework installation), or
    upgrade the provider to a newer version

    I've checked and I didn't fint aspnet_regsql on the vista mashine

    any suggestions?


  • sloan

    #2
    Re: SqlMembershipPr ovider trouble


    You can read this:
    http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!160.entry

    and the ScottGu reference article.

    .......

    Is your Web Server the same machine as the Database Server?

    You can run the aspnet_regsql tool from a machine without Sql Server, but
    point it TO a machine with Sql Server.

    ............

    Please provide more info about which machine is what ( WebServer? DbServer?)
    in your scenario.

    Are you trying to use full blown Sql Server or Express?

    The more details the better.








    "Jeff" <it_consultant1 @hotmail.com.NO SPAMwrote in message
    news:ONNMrqMSJH A.408@TK2MSFTNG P02.phx.gbl...
    hi
    >
    asp.net 2.0
    sql server 2005
    >
    I've created a database on my win2k3 machine. Now I'm moving this database
    over to my Vista business 32bit machine. (I scripted the database on the
    win2k3 machine).
    >
    Now when I open the Web Site Administration Tool I get this error message:
    The 'System.Web.Sec urity.SqlMember shipProvider' requires a database schema
    compatible with schema version '1' However the current database schema is
    not configured with this vesion. You may need to either install a
    compatible schema with aspnet_regsql.e xe (available in the framework
    installation), or upgrade the provider to a newer version
    >
    I've checked and I didn't fint aspnet_regsql on the vista mashine
    >
    any suggestions?
    >

    Comment

    • Jeff

      #3
      Re: SqlMembershipPr ovider trouble

      Is your Web Server the same machine as the Database Server?
      yes, it is the same machine. It's that Vista Business 32bit box
      I'm developing on that vista box


      "sloan" <sloan@ipass.ne twrote in message
      news:OxxRIXNSJH A.1484@TK2MSFTN GP03.phx.gbl...
      >
      You can read this:
      http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!160.entry
      >
      and the ScottGu reference article.
      >
      ......
      >
      Is your Web Server the same machine as the Database Server?
      >
      You can run the aspnet_regsql tool from a machine without Sql Server, but
      point it TO a machine with Sql Server.
      >
      ...........
      >
      Please provide more info about which machine is what ( WebServer?
      DbServer?) in your scenario.
      >
      Are you trying to use full blown Sql Server or Express?
      >
      The more details the better.
      >
      >
      >
      >
      >
      >
      >
      >
      "Jeff" <it_consultant1 @hotmail.com.NO SPAMwrote in message
      news:ONNMrqMSJH A.408@TK2MSFTNG P02.phx.gbl...
      >hi
      >>
      >asp.net 2.0
      >sql server 2005
      >>
      >I've created a database on my win2k3 machine. Now I'm moving this
      >database over to my Vista business 32bit machine. (I scripted the
      >database on the win2k3 machine).
      >>
      >Now when I open the Web Site Administration Tool I get this error
      >message:
      >The 'System.Web.Sec urity.SqlMember shipProvider' requires a database
      >schema compatible with schema version '1' However the current database
      >schema is not configured with this vesion. You may need to either install
      >a compatible schema with aspnet_regsql.e xe (available in the framework
      >installation ), or upgrade the provider to a newer version
      >>
      >I've checked and I didn't fint aspnet_regsql on the vista mashine
      >>
      >any suggestions?
      >>
      >
      >

      Comment

      • sloan

        #4
        Re: SqlMembershipPr ovider trouble

        Ok.

        c:\WINDOWS\Micr osoft.NET\Frame work\v2.0.50727 \aspnet_regsql. exe

        Did you install the Framework(s) on the Deployment Machine? (The machine
        acting as the Web and Database Server)?

        .........





        "Jeff" <it_consultant1 @hotmail.com.NO SPAMwrote in message
        news:%23h40ZfNS JHA.2432@TK2MSF TNGP05.phx.gbl. ..
        Is your Web Server the same machine as the Database Server?
        yes, it is the same machine. It's that Vista Business 32bit box
        I'm developing on that vista box
        >
        >
        "sloan" <sloan@ipass.ne twrote in message
        news:OxxRIXNSJH A.1484@TK2MSFTN GP03.phx.gbl...
        >>
        >You can read this:
        >http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!160.entry
        >>
        >and the ScottGu reference article.
        >>
        >......
        >>
        >Is your Web Server the same machine as the Database Server?
        >>
        >You can run the aspnet_regsql tool from a machine without Sql Server, but
        >point it TO a machine with Sql Server.
        >>
        >...........
        >>
        >Please provide more info about which machine is what ( WebServer?
        >DbServer?) in your scenario.
        >>
        >Are you trying to use full blown Sql Server or Express?
        >>
        >The more details the better.
        >>
        >>
        >>
        >>
        >>
        >>
        >>
        >>
        >"Jeff" <it_consultant1 @hotmail.com.NO SPAMwrote in message
        >news:ONNMrqMSJ HA.408@TK2MSFTN GP02.phx.gbl...
        >>hi
        >>>
        >>asp.net 2.0
        >>sql server 2005
        >>>
        >>I've created a database on my win2k3 machine. Now I'm moving this
        >>database over to my Vista business 32bit machine. (I scripted the
        >>database on the win2k3 machine).
        >>>
        >>Now when I open the Web Site Administration Tool I get this error
        >>message:
        >>The 'System.Web.Sec urity.SqlMember shipProvider' requires a database
        >>schema compatible with schema version '1' However the current database
        >>schema is not configured with this vesion. You may need to either
        >>install a compatible schema with aspnet_regsql.e xe (available in the
        >>framework installation), or upgrade the provider to a newer version
        >>>
        >>I've checked and I didn't fint aspnet_regsql on the vista mashine
        >>>
        >>any suggestions?
        >>>
        >>
        >>
        >
        >

        Comment

        Working...