473,480 Members | 1,857 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Remote AspNetdb, Renamed Database . Now error: 'InstallCommon.sql'

I renamed the name of my remote database where I had a working
AspNetdb configuration working.

I now get this error when I compile in development:

An error occurred during the execution of the SQL file
'InstallCommon.sql'. The SQL error number is 1802 and the SqlException
message is: CREATE DATABASE failed. Some file names listed could not
be created. Check related errors.
Cannot create file 'C:\xx\xx\APP_DATA\ASPNETDB_TMP.MDF' because it
already exists. Change the file path or the file name, and retry the
operation.
Creating the ASPNETDB_c36c4d7886f14b22929c877266bc3a03 database...

My site was was working fine before, the ony quirk before was that
even though I know for a fact security was in the remote database,
that my the project would insist on recreating the AspNetDb in the
project.

My web.config is of course point to the remote database and there was
no entry for

<authorization>
<allow users="*" />
</authorization>
<membership defaultProvider="SqlProvider">
<providers>
<add name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="Retailer" applicationName="/"
minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"
requiresQuestionAndAnswer="false"/>
</providers>
</membership>

and this was removed:

<roleManager enabled="true"/>

Jul 19 '07 #1
0 2491

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

Similar topics

5
3047
by: VB Programmer | last post by:
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...
1
1695
by: Derek | last post by:
I am trying to deploy a web site on a server but I am having problems with the ASPNETDB database. It works fine in development on my PC but as SQL Server 2005 Express Edition only supports local...
8
6691
by: nick | last post by:
I have only SQL Server 2005 installed on my PC. And I tried to add the following rows in web.config to use SQL Server 2005 instead of Express: <connectionStrings> <clear /> <add...
0
1582
by: Jonathan Wood | last post by:
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had...
2
5620
by: =?Utf-8?B?Sm9zaCBOaWtsZQ==?= | last post by:
i'm in the process of putting my first .net app on a remote server, and i'm having no end of trouble getting the aspnetdb database (sitememberships on my host) to work correctly. after a lot of...
2
2319
by: gihope | last post by:
I have searched everywhere for answers to this but none of the posts I have read have helped yet. My website works perfectly until I upload it onto a remote web host. When this happens the logisn...
3
3520
by: R.A.M. | last post by:
Hello, I have created ASP.NET application with aspnetdb database. In the following codeI have an error: System.Security.Principal.IPrincipal user = HttpContext.Current.User; if...
6
9574
by: Mr. X. | last post by:
I have visual studio 2008. My site has a plesk on it. I want to deploy my project, and save it on the host machine. Looking for solution for folowings, please : 1st solution =======...
6
8799
by: Mr. X. | last post by:
Hello. How can I create aspnetdb from scratch ? (I want a script that create all table, views, etc... on that database). Thanks :)
0
7055
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
7059
Oralloy
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,...
1
6758
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7010
tracyyun
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...
1
4799
isladogs
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...
0
3011
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...
0
3003
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1311
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 ...
1
572
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.