asp.net 2.0 membership ASPNETDB_TMP.MDF" is on a network path that is not supported for database fil

[jason]

I've been playing around with new (for 2.0) membershp functionality.

I was able to build a simple login form that secures a directory on a
project I built locally on my development desktop.

However, when I attempt to follow the same steps on the remote test
server (a website I access via filesystem security accross my lan ).. I
get the following when I attempt to select the security tab from the
administer selection of the login control:

There is a problem with your selected data store. This can be caused by
an invalid server name or credentials, or by insufficient permission.
It can also be caused by the role manager feature not being enabled.
Click the button below to be redirected to a page where you can choose
a new data store.

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
"\\servername\folder\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_a10a1b7695ae4af7ad287b55252fa7bd database...

To check security, I am from my desktop able to write to the folder and
add new items from vs.net 2005.

However if I attempt to add new item database under the APP_DATA folder
through vs.net I get an error that the db file is on a network path
not support for database files.

How do I correct this? I never knew sqlserver cared where I store data
files.

The remote server is a win 2000 server and the db is sql server 2000.

Could it be that on the remote webserver/db server I authenticate using
a sql server login for sa? On my desktop, I think I just default to
windows authentication. Sorry, noob question, if this is the issue,
where and how to I tell my project how to connect... and if it is, Im
wondering why the new ASPNETDB_TMP.MDF requires a different login since
I did not have to worry about any of this when I tested on my local
client.

 

[Cowboy \(Gregory A. Beamer\)]

The membership database location is stored in <connectionstring> section of
the web.config. You can find which connection string by looking at the
<membership> tag (by name). Also look at the <roleManager> tag.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

 

[jason]

Since sending the email, I did add the connection string to web.config:

<connectionStrings>
<remove name="xx.xxx.xx.xx"/>
<add name="xx.xx.xx.xx"
connectionString="Data Source=MyServer;
Initial Catalog=appservicesdb;
Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>

It did not help.

Are you saying the role manager tag might solve this issue? I would
guess it appears that I can't get sqlserver to wiite a database (using
the installcommon.sql script) to a share. Seems more like file and
system security.


Incidently, I'm creating the website via the file system (after
creating a windows share) because If I attempt to create it via http I
get an error about being unable to create web. At some point I use to
be able to do that when I was using vs.net 2003.. though I don't see
anything in windows or IIS security on the server that sould allow me
to write via http. Perhaps the above goes away If I can create the
website via http:

Also, I notice on the web server that the websites I create via the
file system don't have virtual directories like the ones created
locally via http...

Thank you.

 

[jason]

More on this.

I never set up sql server on my local client. Apparently this was all
done by vs.net 2005. So membership works with very little info in the
web.config when run from the client.

I suspect my problem is that I on the web server, I don't have
integrated security set up. I suspect whatever windows user vs.net uses
(possibly asp.net) can't access the db without a user and password. All
my other asp.net applications have a user and password in the
connection string.

To further prove this, If I xcopy a working asp.net website that has
the membership login code to the web server, I get connection errors..
using the default web.config. I found some instruction on the net for
creating a connection string, but they assume integrated security.

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=MyServer;
Initial Catalog=appservicesdb;
Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>


I was wondering, can the above connection string have a user/password?
or
would it a better approach to somehow allow the asp.net user access to
the DB through windows.. and if so and safe, what's the best way to do
this?