Friday, February 17, 2012

Database deployment - SQL Express

I have an application being developed in VS 2005 using SQL Express. I've built up some new roles and have several users pre-populated that I'd like to deploy to a shared hosting evironment.

The problem is that I seem to keep getting:

Database 'd:\hosting\member\asanga\App_Data\ASPNETDB.mdf' already exists. Choose a different database name.
Cannot attach the file 'd:\hosting\member\r2agility\site1\App_Data\ASPNETDB.MDF' as database 'ASPNETDB'.

I saw another post with a similar issue, but that resolution has not seemed to help. Can anybody give me insights as to where the "asanga" is coming from? That might help me diagnose the issue.

Thanks in advance

Problem solved. Just had to rename the "Initial Catalog" value from ASPNETDB to ASPNETDB1

No comments:

Post a Comment