I have setup a test IIS box and would like to use that as my development platform. I have installed sql express 2005 for my database on the box as well.
I can setup new pages on the file server just fine.. But when I try and setup a login page and use the asp.net configuration web page to setup security which create a user DB it will not let me create it...
I get the following:
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 "J:\INETPUB\NBSRECAP\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_4a9331c5903148ca92e3ffbee7d29976 database...
Can someone let me know.
Are you trying to create a database on a network path? This is not supported by default, however you can open a trace flag to allow this:dbcc traceon(1807,-1)
go
create database testUNC on (name='testUNC_data',
filename='\\iori\xxx\testUNC.mdf')
log on (name='testUNC_log',
filename='\\iori\xxx\testUNC.ldf')
