Form Authentication - from sqlexpress to sql 2005 connection string

Discussion in 'ASP.NET 2.0' started by gspy, Jul 19, 2006.

  1. I am using Form authentication with sql express with the default settings in web.config with success.</o:p>
    I am trying to convert it to use sql server 2005 with out success after hours of googling it.</o:p>
    </o:p>
    Can anybody suggest a solution?</o:p>
    </o:p>
    My working web config with sql express is:</o:p>
    </o:p>
    </o:p>
    <configuration></o:p>
    <appSettings></o:p>
    </appSettings></o:p>
    </o:p>
    <system.web></o:p>
    <compilation debug="true" /></o:p>
    <authorization></o:p>
    <deny users="?"/></o:p>
    </authorization></o:p>
    <authentication mode="Forms" /></o:p>
    <roleManager enabled="true"/></o:p>
    </system.web></o:p>
    </o:p>
    <system.net></o:p>
    <mailSettings></o:p>
    <smtp></o:p>
    <network host="mail.myname.com"/></o:p>
    </smtp></o:p>
    </mailSettings></o:p>
    </system.net></o:p>
    </configuration></o:p>
    </o:p>
    </o:p>
    What I suppose to write to support the same functionality with a sql 2005 DB?</o:p>
    </o:p>
    Thanks in advanced.</o:p>
    </o:p>
    GSpY</o:p>
     
  2. ....i mean something similar and simply like the above,
    with out running command line utilities or other strange actions,
    and with something applicable to discountasp hosting accounts.
    With sqlexpress is so easy.
    You do nothing and you have an authentication db from nothing.
    Is this applicable to sql 2005? (with or without existing db)?

    Thanks again.
     
  3. Bruce

    Bruce DiscountASP.NET Staff

    i am slightly lost!

    Do you mean you want to use the membership / role provider with ASP.NET 2.0?

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    This is not possible. The ASPNET_DB contains all your member role information, it will need to be stored somewhere (be it SQL 2k5 or SQL express). Since we do not support SQL Express, you'll have to install the ASPNETDB schema on your SQL 2k5 DB.

    See http://kb.discountasp.net/article.aspx?id=10413for details on how to get this setup.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  5. Sorry for my English.</o:p>
    </o:p>
    Yes you are correct.</o:p>
    </o:p>
    I use it locally with the above config and works ok.</o:p>
    If I have already a database it adds users, if I haven?t one it creates the schema and continues.</o:p>
    But it uses sqlexpress.</o:p>
    I want the same functionality but with sql 2005 so I can upload my application to my account in discountasp.</o:p>
    </o:p>
    I don?t want to implement custom providers or run utilities to create the schema.</o:p>
    I just want to change the connection string so I can get the same functionality as with sql express.</o:p>
    </o:p>
    Is this possible?</o:p>
    </o:p>
    Thanks.</o:p>
     
  6. Ok.


    Thanks again for your support.
     

Share This Page