Re: Membership Roles problem w database

Thanks.
The solution was to place the providers in her app's web.config.

Efran Cobisi wrote:
> Hi Mark,
>
> Are you sure Z: is a label which refers to a local machine volume?
> If not, and maybe it is mapping a network share, please consider that
> SQLServer does not support network database files by default [1];
> however, this behavior could be changed by turning on trace flag 1807.
> If this is the case, I highly recommend to switch your database location
> to a local machine volume, thus avoiding this issue.
>
> [1] http://msdn2.microsoft.com/en-us/library/ms176061.aspx
>
> HTH,
>
> Efran Cobisi
> http://www.cobisi.com
>
> Mark Aurit wrote:
>> Im trying to help a friend who is attempting to deploy an asp.net 2.0
>> app.  She wants to use the membership/role system, and the necessary
>> database and its tables, etc, exist in the sql server 2000 instance
>> (which is on a seperate server).  When she brings up the asp.net admin
>> app from within vs.net, she can do the database connection test to her
>> membership/role database and her application's database.  However, if
>> she clicks on the Security tab, she gets:
>> "The following message may help in diagnosing the problem: An error
>> occurred during the execution of the SQL file 'InstallCommon.sql'. The
>> SQL error number is 5110 and the SqlException message is: The file
>> "Z:\DEVELOP\APP_DATA\ASPNETDB_TMP.MDF" is on a network path that is not
>> supported for database files. CREATE DATABASE failed. Some file names
>> listed could not be created. Check related errors. Creating the
>> ASPNETDB_f99997c331604d0a92dfe86aca285b0e database...".
>> Im at somewhat of a loss, as I role my own role systems, but a few
>> things jump out: the database exists, but the message says the error is
>> in their creation.  But even if she were doing the sql server 2005 thing
>> where one puts the mdf file in the \App_Code, the path is not correct,
>> its to here development, not prod (they are on the same machine, so the
>> drive letter is correct).
>> In review:
>> 1. asp.net 2.0
>> 2. sql server 2000 on seperate machine
>> 3. role/memberships database/table set up, and is recognized in the web
>> admin app under Providers
>> Any advice would be greatly appreciated.
>> Thanks, Mark
>>
>> --
>> ====================
>> Mark Aurit
>> [email protected]
>>
>> ===================================
>> This list is hosted by DevelopMentor®  http://www.develop.com
>>
>> View archives and manage your subscription(s) at
>> http://discuss.develop.com
>
> ===================================
> This list is hosted by DevelopMentor®  http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>

--
====================
Mark Aurit
[email protected]

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com