When I Create A Set Up And After Installation I Got Following Error Plzzz Help Me

Question

1.00/5 (1 vote)

See more:

SQL

an attempt to attach an auto-named database for file
E:\ Default Company Name \Cloth Invenotry \Garment.mdf failed .
A database with the same name exists or specified file cannot be opened or it is located on UNC share.

(in winodow based application )

Posted 27-Jun-14 1:59am

pagal panti

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pravuprasad · Answer 1 · 2014-06-27T02:37:00

When testing the import into IIS7.5 and after getting an error I always changed the database name for the next test - ie I started off with myDB01 and on the second attempt I called it myDB02 etc.

I always selected the option not to include the App_Data folder and I always added a custum script as follows:

CREATE USER [SomeUserName]

FOR LOGIN [IIS APPPOOL\DefaultAppPool]

GO

EXEC sp_addrolemember 'db_datareader', 'SomeUserName'

GO

After testing 30 times I finally was able to load it into IIS7.5 without errors. The connection string for the destination database that finally worked was:

Data Source=localhost\SQLExpress;Initial Catalog=MyDatabaseName;User ID=SomeUserName' ;Integrated Security=SSPI;Persist Security Info=False

And the connection string that I put into the web.debug.config for web transformation was:

Data Source=localhost\SQLExpress;Initial Catalog=MyDatabaseName;Trusted_Connection=Yes;Persist Security Info=False

I hope this helps.