My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db for
my 2.0 site to work. Is this accurate?
If so, how can I rename it without breaking anything on my site?
FYI: This is the error I'm getting after I publish my site to their
servers...
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
5  3058 
Well,
If they already have a database out their with the same name (some other
customer probably deployed before you did and they are calling it first come
first served) your only choice will be to rename and change your code... You
should just need to change your connection string to the database file in
your web.config.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:u%******** ********@TK2MSF TNGP15.phx.gbl. .. My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db for
my 2.0 site to work. Is this accurate?
If so, how can I rename it without breaking anything on my site?
FYI: This is the error I'm getting after I publish my site to their
servers...
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
Thanks. Few questions...
1. Why should it matter since everything (like the connection string) is
referencing my app_data dir? Isn't the SQLExpress MDF handled similar to an
Access MDB database? It's just a database file in a dir...
2. If I simply rename the db (in VS2005) and change the web.config VS STILL
automatically creates the ASPNETDB.mdf. Any ideas why?
Thanks again....
"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote in
message news:OM******** ******@TK2MSFTN GP10.phx.gbl... Well,
If they already have a database out their with the same name (some other
customer probably deployed before you did and they are calling it first
come first served) your only choice will be to rename and change your
code... You should just need to change your connection string to the
database file in your web.config.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:u%******** ********@TK2MSF TNGP15.phx.gbl. .. My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db
for my 2.0 site to work. Is this accurate?
If so, how can I rename it without breaking anything on my site?
FYI: This is the error I'm getting after I publish my site to their
servers...
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
VB Programmer,
That's what I thought at first also. And I found out otherwise when I tried
to deploy a SQL Express database to a site experimentally. The ISP didn't
have SQL Express installed on the server. And because it wasn't installed my
database couldn't be loaded. It seems that SQL Express needs to be installed
on the server and it loads up databases just like SQL does. The only real
noticeable difference is how many connections it handles (of course there
are many other differences, but not many that affect day to day development
if a site is small). Anyway, no, SQL Express is not like an access database
file because the server has to be running a component.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Thanks. Few questions...
1. Why should it matter since everything (like the connection string) is
referencing my app_data dir? Isn't the SQLExpress MDF handled similar to
an Access MDB database? It's just a database file in a dir...
2. If I simply rename the db (in VS2005) and change the web.config VS
STILL automatically creates the ASPNETDB.mdf. Any ideas why?
Thanks again....
"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote
in message news:OM******** ******@TK2MSFTN GP10.phx.gbl... Well,
If they already have a database out their with the same name (some other
customer probably deployed before you did and they are calling it first
come first served) your only choice will be to rename and change your
code... You should just need to change your connection string to the
database file in your web.config.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:u%******** ********@TK2MSF TNGP15.phx.gbl. .. My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db
for my 2.0 site to work. Is this accurate?
If so, how can I rename it without breaking anything on my site?
FYI: This is the error I'm getting after I publish my site to their
servers...
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot
be opened, or it is located on UNC share.
My hoster says they just started supporting SQLExpress (after much begging
by myself.)
The wierd thing is one data-driven page is working perfectly. All the
others (using the same db) give me the error:
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
Any more insight is much appreciated.
Thanks again...
"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote in
message news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. VB Programmer,
That's what I thought at first also. And I found out otherwise when I
tried to deploy a SQL Express database to a site experimentally. The ISP
didn't have SQL Express installed on the server. And because it wasn't
installed my database couldn't be loaded. It seems that SQL Express needs
to be installed on the server and it loads up databases just like SQL
does. The only real noticeable difference is how many connections it
handles (of course there are many other differences, but not many that
affect day to day development if a site is small). Anyway, no, SQL Express
is not like an access database file because the server has to be running a
component.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Thanks. Few questions...
1. Why should it matter since everything (like the connection string) is
referencing my app_data dir? Isn't the SQLExpress MDF handled similar to
an Access MDB database? It's just a database file in a dir...
2. If I simply rename the db (in VS2005) and change the web.config VS
STILL automatically creates the ASPNETDB.mdf. Any ideas why?
Thanks again....
"S. Justin Gengo [MCP]" <justin@[no_spam_please]aboutfortunate. com> wrote
in message news:OM******** ******@TK2MSFTN GP10.phx.gbl... Well,
If they already have a database out their with the same name (some other
customer probably deployed before you did and they are calling it first
come first served) your only choice will be to rename and change your
code... You should just need to change your connection string to the
database file in your web.config.
--
Sincerely,
S. Justin Gengo, MCP
Web Developer / Programmer
www.aboutfortunate.com
"Out of chaos comes order."
Nietzsche
"VB Programmer" <do**@emailme.c om> wrote in message
news:u%******** ********@TK2MSF TNGP15.phx.gbl. ..
My web hoster says that I have to rename my ASPNETDB.MDF SqlExpress db
for my 2.0 site to work. Is this accurate?
If so, how can I rename it without breaking anything on my site?
FYI: This is the error I'm getting after I publish my site to their
servers...
An attempt to attach an auto-named database for file
c:\hosting\myho st\member\myacc ount\customerdo mains\mysite\Ap p_Data\ASPNETDB .MDF
failed. A database with the same name exists, or specified file cannot
be opened, or it is located on UNC share.
VB Programmer wrote: Thanks. Few questions...
1. Why should it matter since everything (like the connection string) is
referencing my app_data dir?
ASPNET looks for a specific connection string named "LocalSqlServer " to connect to the security database for its authorization, roles and membership info.
Isn't the SQLExpress MDF handled similar to an
Access MDB database? It's just a database file in a dir...
No, SQLExpress is a full-fledged relational database engine. Although the data is in an MDF file on the hard drive, that data file is manipulated every which way from Sunday by the engine.
2. If I simply rename the db (in VS2005) and change the web.config VS STILL
automatically creates the ASPNETDB.mdf. Any ideas why?
When you start the WebConfiguratio n tool in VS2005 (and there isn't a security database for the Web Site which is recognized as such by the VS2005 development server), a half-dozen SQL scripts are run to create the database and the tables within it. Those SQL scripts all have the database name of "ASPNETDB" hard-coded in them.
--
Take care,
Ken
(to reply directly, remove the cool car. <sigh>) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: VB Programmer |
last post by:
I want to use add some of my own tables to ASPNETDB.mdf to store shopping
cart products, checkout information, additional user information, etc... Is
it recommended that I put this in the same db?
What is the default password to ASPNETDB.mdf? I can't seem to connect to it
via Enterprise Mgr.
Thanks y'all!
|
by: te goody |
last post by:
Problem summary:
Web Site Admin Tool is not generating the application services database
(aspnetdb.mdf); i.e. The DB is not found under the app_data directory.
The Question:
What configuration am I missing to allow WAT to create the application
services database?
Scenarios I tried:
On a dedicated developer workstation running WXP w/ SP2, I installed
|
by: te goody |
last post by:
Problem summary:
Web Site Admin Tool is not generating the application services database
(aspnetdb.mdf) in a SS 2005 only environment; i.e. The DB is not found under
the app_data directory.
The Question:
What configuration am I missing to allow WAT to create the application
services database?
Scenarios I tried:
|
by: Freddie |
last post by:
hi,
i try to get the asp.net 2.0 security controls to work with SQL Server
2005 Dev RTM, this is my connetion string in mashine.config
<connectionStrings>
<add name="LocalSqlServer" connectionString="data
source=.;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User
Instance=false;" providerName="System.Data.SqlClient" />
|
by: mehdi |
last post by:
Hi folks,
I'm designing an sql server 2005 database to hold accounting
information of a given company (ies). The database containg a table for
EmployeeAccounts which in turn should be somehow related to the
aspnet_Users table of aspnetdb table to handle the A&A (Authentication
and Authorization) of an employee within the system.
The question is that how am I supposed to link these 2 tables, say,
EmployeeAccounts an the aspnet_Users? Of...
| | |
by: R.A.M. |
last post by:
Hello,
I am learning ASP.NET. In web application I am programming now I decided to
add a table "Users" to aspnetdb database (with extra data about users) and a
trigger AFTER UPDATE of "aspnet_Users" table. But now I cannot run my
application because of error in line:
MembershipUser mu = Membership.GetUser();
System.Data.SqlClient.SqlException: Cannot open user default database. Login
failed.
Login failed for user 'PC\ASPNET'.
A few...
|
by: John Kotuby |
last post by:
Hello all..
TIA for any help.
I was told that if I'm not using the built in Membership/Forms
Authentication feature in ASP.NET 2.0 that I can delete ASPNETDB.MDF. I
guess it appeared when I opened a web configuration wizard. I use an
external SQL DB for my authentication and just check for session variables
on each page.
When I deleted the ASPNETDB.MDF, I get all these "schema" info messages. Can
|
by: Ryan |
last post by:
PLEASE HELP!!
I am trying to do what I think should be the simplest thing. In
Visual Studio 2005, I set up a datagrid and then went ot configure a
datasource for it. I made my connection to the database using the
same connection string as I used to view the databse in server
explorer. (In server explorer I see all stored procedures). I then
go through the wizard and choose "Specify a custom SQL Statement or
Stored Procedure." Then...
|
by: =?Utf-8?B?RGF2ZQ==?= |
last post by:
How can I rename the default ASPNETDB.MDF database when a login control is
used?
--
L. A. Jones
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
