Problem attaching mdf file in sql server 2008

sql-server-2005sql-server-2008

I have an mdf file of sql server 2005 database now i want it to attach in sql server 2008 R2 but when i try to attach it, it gave me error saying.

Unable to open the physical file "D:\Fraz\Freelance\Database\DBmdf13aug\mbh_pk.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

what can be the problem and how to fix it? Is this folder permission error or sql server 2008 have something missing

Best Answer

I think we'll need a bit more info about the server to help properly, but have you tried the basics? e.g.

  • Is the VNC server service installed and configured correctly with no errors logged when it runs?
  • can you ping from the client to the server?
  • Is there any firewalls that could be blocking the VNC traffic in the mix?
Related Topic