2

I have SQL Server 2005 SP4 Express, when I try to establish connection from VS2010 to my database, I get a error:

You don't have permission to open this file

Contact the file owner or an administrator to obtain permission.

I am using windows authentication and I am the only user.

Please help me out to overcome this error.

Also sometimes, it shows file is already open

Aaronaught
  • 120,909
  • 25
  • 266
  • 342
Ahmed
  • 21
  • 1
  • 1
  • 3

1 Answers1

2

First of all close visual studio. Now open visual studio run as administrator. If it not solved your problem then open sql server management studio and follow the steps.

  1. Expand your database.
  2. Right click on your database and choose properties option.
  3. A pop is open, select option menu reside on left side.
  4. Make auto close option true situated in automatic pane.

I am sure your problem is solved now.....

cheers.....

FIFO BIZSOL
  • 729
  • 6
  • 6