473,387 Members | 1,420 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

SQLExpress database file auto-creation error...

Hi!
I have Web Application with forms authentication. Data
and security model resides in Oracle database.
I have 'login' page with MS 'Login' control.
In my LoggingIn event for debug purposes I have
only:
FormsAuthentication.RedirectFromLoginPage(
"testlogin', false);
(all users are authenticated)
It works fine till now - I have still error:

"SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using
a database location within the applications App_Data directory. The
provider attempted to automatically create the application services
database because the provider determined that the database does not exist.
The following configuration requirements are necessary to successfully
check for existence of the application services database and automatically
create the application services database:
If the applications App_Data directory does not already exist, the web
server account must have read and write access to the applications
directory. This is necessary because the web server account will
automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server
account only requires read and write access to the applications App_Data
directory. This is necessary because the web server account will attempt
to verify that the Sql Server Express database already exists within the
applications App_Data directory. Revoking read access on the App_Data
directory from the web server account will prevent the provider from
correctly determining if the Sql Server Express database already exists.
This will cause an error when the provider attempts to create a duplicate
of an already existing database. Write access is required because the web
server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user
profile. See the readme document for details on how to create a local user
profile for both machine and domain accounts.

"

Why ASP want to create some database?
How can I disable 'automatic' providers, managers of ASP.NET
to prevent this kind of errors?

regards

mrozik
Mar 15 '07 #1
1 5880
On Thu, 15 Mar 2007 14:47:07 +0100, Mrozik <mr******@interia.plwrote:
Hi!
I have Web Application with forms authentication. Data
and security model resides in Oracle database.
I have 'login' page with MS 'Login' control.
In my LoggingIn event for debug purposes I have
only:
FormsAuthentication.RedirectFromLoginPage(
"testlogin', false);
(all users are authenticated)
It works fine till now - I have still error:

"SQLExpress database file auto-creation error:
I found solution - not to user biuld-in 'Login control' ;-)
mrozik
Mar 15 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: andrewcw | last post by:
I am trying to use the NorthWind database or anything with SQLEXPRESS on VS 2005 RC. I can see SQLExpress started with the tool SQL Server Configuration Manager. But when i select DataBase | New...
1
by: VB Programmer | last post by:
I have created an ASP.NET 2.0 site and just published it to my webserver. None of the database stuff works, including membership, etc.... because my hosting company (webhost4life) claims that they...
2
by: Crash | last post by:
Windows XP MS SQLExpress VS 2003 ..NET 1.x SP1 {for Application} ..NET 2.0 {for SQLExpress} MS Enterprise Library June 2005 This works from a command prompt osql -E -S localhost\SQLEXPRESS
13
by: Matt Fielder | last post by:
First off, if this is better posted in another group that qualifies as a manged group, please let me know. I currently have an application written in VB.Net using MSDE as the database. Current...
1
by: lexman | last post by:
Hello, How do you deploy a vb.net application with a SQL express database? My vb.net programming book offers a single paragraph that amounts to "Select publish, choose options in wizard, job...
2
by: jed | last post by:
I have created this example in sqlexpress ALTER PROCEDURE . @annualtax FLOAT AS BEGIN SELECT begin1,end1,deductedamount,pecentageextra FROM tax
2
by: Michel Vanderbeke | last post by:
Hello, I have a program, running in several places, using SQLEXPRESS as database. The different places are stand-alone, and not connected to a network. Regulary, I have to apply changes on...
49
by: ARC | last post by:
Hello all, I have one chance to get this right, as I'm nearing a release of a program. I've looked at the database settings, and so far, have set the following: * Unchecked 'Enable design...
1
by: Aykut Canturk | last post by:
Can I use SqlExpress2005 AttachDatabase feature with classic ADO connections in my .asp pages ? But I need ConnectionString. Although I searched the web for couple of weeks I still coulnd't find...
1
by: sherifffruitfly | last post by:
Hi all, I made a c# app that includes a sqlexpress database. I can't seem to find the mdf file though, so I'm wondering exactly how/whether I can give the app to my friend to use/test. Will the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.