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

You need to override the connection string for Membership and or Roles

See

http://www.integralhelp.com/index.ph...kbarticleid=44

and


http://www.odetocode.com/Articles/427.aspx


"MarkAurit" <(E-Mail Removed)> wrote in message
news:5AA962FF-6655-43DD-B710-(E-Mail Removed)...
> 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