Last post Mar 22, 2007 07:28 AM by XiaoYong Dai - MSFT
Mar 19, 2007 12:31 PM|brazen|LINK
Friends I am workin on a module to enable the users to change their password on a web page.
Now I have directly used an Update statement with an "ChangePassword .NET Control" in my page.On the change password button click I get this error.
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:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\ADMININVENTORY\APP_DATA\ASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation.
Creating the ASPNETDB_ff665c7c934e489983a6aacae89f2545 database...
I want to know what exactly is triggering this error as on other pages insert and update statements work pretty well.Is this the '"ChangePassword control" which is responsible.
People on other forums have mentioned that deleting the SQLEXPRESS folder in DocmentSettings\AppData\MS server dara\XXXX....\SQLEXPRESS would do the trick but then I get a "Sharing vioation error" when i delete this folder.
Any help would b appreciated.
Thanx in advance.
Mar 22, 2007 07:04 AM|Zhao Ji Ma - MSFT|LINK
Please try creating or updating aspnetdb on local server, detach your
aspnetdb dabase on remote server and upload it again. Hope it helps.
Mar 22, 2007 07:28 AM|XiaoYong Dai - MSFT|LINK
You cannot remove this
even in Safe Mode?
In the long run, my suggestion is that you can custom the provider to meet your requirements, (For example: use SQL Server)
First, create a DB using aspnet_regsql,
Second. remove the default provider in configuration like this
<remove name="localsqlserver" />
At last, try changing the name of the membership provider from
AspNetSqlMembershipProvider to a custom name such as MyProvider, then use the Website administration tool from the VS 2005 to test this provider so that it is able to connect to the DB you created earlier.
Also, provide this information as a convenience to you:)