Why do I get a permission error when connecting to SQL Server from Visual Studio?

visual-studio-2010 sql-server-2005-express
Ahmed picture Ahmed · Mar 23, 2013 · Viewed 10.1k times · Source

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

Answer

FIFO BIZSOL picture FIFO BIZSOL · Jul 17, 2013

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.....

Related questions

Populating Listbox with data from SQL Server

I don't know what is happening to my program, it took me (4) four minutes to load the result of my code.... can someone tell me why? Can someone tell me how to fix this loading problem? This is my code: …

Read More
The type or namespace name could not be found

I have a C# solution with several projects in Visual Studio 2010. One is a test project (I'll call it "PrjTest"), the other is a Windows Forms Application project (I'll call it "PrjForm"). There is also a third project referenced by …

Read More
Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More