I get this error when database connect with my project

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

, +

Quote:
Server Error in '/CMS' Application.
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Content Pro.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Content Pro_log.ldf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
Cannot open database "Content Pro" requested by the login. The login failed.
Login failed for user 'SAI\munna'.
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Content Pro_log.ldf" may be incorrect.

Posted 4-May-14 23:52pm

Šangeet Šhah

Updated 4-May-14 23:59pm

DamithSL

v3

Add a Solution

3 solutions

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)

King Fisher · Answer 1 · 2014-05-04T23:56:00

Solution 1

Check this :

http://stackoverflow.com/questions/6347312/unable-to-open-the-physical-file-operating-system-error-32[^]

Posted 4-May-14 23:56pm

King Fisher

Kornfeld Eliyahu Peter · Answer 2 · 2014-05-04T23:59:00

According to the path you provided it is highly possible that these are files for active databases in your SQL server. You can not open files while the SQL uses them.
It seems that you try to use AttachDbFileName in your connection string, do not! Use Server, Initial Catalog, User and Password to access your DB!

Yash Raichura · Answer 3 · 2014-09-09T19:29:00

Solution 3

This Might Help You
..
SQL Server management studio 2008 R2 –> connect to my server –> right click on my database name –>tasks –> take offline.
..return to visual studio and reatttached the database it will work...
Thanks

Posted 9-Sep-14 19:29pm

Yash Raichura