deploy authentication 'forms'

good morning

after many attempts I'm unable to deploy a site with the authentication mode 'forms'

I have a site with a sqlserver 2005 database called "test.mdf" that contains the data
the security is handled by the usual "ASPNETDB.MDF" that contains the roles, user ... all the access/security stuff

I try to deploy the site using xcopy and publish technic with no success

here is what I tried :

first to deploy the site, I copy the 2 mdf files on the server
the database files are then attached to sqlserver using sqlserver management studio express
after that I copy the site on th server, link it to IIS and so on ...
I finally change the connectionstrings in the web.config to tell the site how to connect to the 2 databases on this server

once the site installed, if I open the site in mode 'windows', everything is ok so the access to the test database
but now if I use the mode 'forms' (the one I need to use), I simply can't login

so I think something is missing to tell that the site access is managed by the ASPNETDB database ?

so my question is certainly obvious but I am really without solution how to deploy the security config with the site itself

thanks a lot









.

Relevant Pages

  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Moving full-text index to a different system - problems
    ... What I did was to restore the database into a database which had the db_id I ... > The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... > The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Insert between separate databases
    ... the other is a remote sql server which I can access via ip address. ... You can link the remote sqlserver database inside access if I'm not mistaken, ... If you use sqlserver, and you have both catalogs in the same server, you can do: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Access Layer that allows Multiple Data Sources
    ... I'm looking for something that allows a typical master data source for storing and retrieving data, but I'd also like it to be able send select data to other datasources. ... database server and it would be nice to be able to run these reports ... write it back in sqlserver, pull data from sqlserver A in context 1 and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Upgrading Access 97 application to dotNet
    ... for the database back-end. ... database must reside on the network server, ... like SQLServer. ...
    (microsoft.public.dotnet.languages.vb)