Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Asp.Net Programming

2.0 membership roles database problem


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.php?_m=knowledgebase&_a=viewarticle...

and

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

"MarkAurit" <MarkAu@discussions.microsoft.com> wrote in message

news:5AA962FF-6655-43DD-B710-C977EB57504A@microsoft.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc