Re: Membership Roles problem w database

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