Error trying to access DB

  • Hello all,

    I am trying to publish a website like since five days ago. I have seen like 1000 forums but still I kind find a solution, maybe someone has the same issue, I try the search and I didnt see it already posted. This is the error:

    An attempt to attach an auto-named database for file C:\Documents and Settings\morase\Desktop\Copy of BPO Portal\BPO Portal\BPO Portal\App_Data\FinancialControl.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

    Here is a little more background. I develop my website on VS 2008, with the SQL that comes already integrated with VS2008. The website runs perfectly locally. Now I am trying to publish it in a Server 2003 but I keep getting that error. Any clue?

  • Hi,

    First of all, why are you trying to create a database with the datafile located at C:\Documents and Settings\morase\Desktop\Copy of BPO Portal\BPO Portal\BPO Portal\App_Data\FinancialControl.mdf ??

    Don't do that. Set the path to some other directory, like c:\SQL_DataFiles or whatever you want. Just make sure that the directory exists on the server and that the SQL service account have r/w access to it.

    cheers

    Alejandro Pelc

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply