title: SQL Server 2008, Error: 948 While Attach Database got Version error?
body: <p>Yesterday I installed SQL Server 2008 on my laptop (Windows 7 64 bit), I need to attach a <code>.mdf</code> to the server, but when I try to do this, I get this error:</p>
  
  <blockquote>
    <p>Attach Database failed for server 'prince/sqlexpress' (Microsoft.SqlServer.smo)</p>
    
    <p>ADDITIONAL INFORMATION:
    1.An Exception Occured while executing a Transact Sql statement or Batch (Microsoft.SqlServer.connectioninfo)</p>
    
    <p>2.Unable to open the Physical file Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)</p>
  </blockquote>
  
  <p>With the help of Internet, I found some solution.</p>
  
  <blockquote>
    <p>1.Start SQL Server manager as Administrator (right-click on the program, choose "Start as administrator"):</p>
  </blockquote>
  
  <p>But I still got the same error.</p>
  
  <p>That <code>.mdf</code> file does have have permission, so I moved into external drive (pendrive because my system have only <code>C:\</code> drive, yet no partition I have done ) .</p>
  
  <p>Then I got another error,</p>
  
  <blockquote>
    <p>Attach database failed for Server 'Prince\SQLEXPRESS'.<br>
    (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION:</p>
    
    <p>An exception occurred while executing a Transact-SQL statement or
    batch. (Microsoft.SqlServer.ConnectionInfo)</p>
    
    <p>The database 'Databasename' cannot be opened because it is version
    655. This server supports version 611 and earlier. A downgrade path is not supported. Could not open new database 'Databasename'. CREATE
    DATABASE is aborted. (Microsoft SQL Server, Error: 948)</p>
  </blockquote>
  
  <p>I use the Query -</p>
  
  <blockquote>
    <p>"select @@version;"</p>
  </blockquote>
  
  <p>I got the Output as </p>
  
  <blockquote>
    <p>"Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007
    22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition
    on Windows NT 6.1 (Build 7600: )"</p>
  </blockquote>
  
  <p>what shall i do? But i installed SQL Server 2008. how do i change that?
  How to solve this error, please help out this problem, If you have any solution please post it.</p>