title: Unable to attach database in Amazon RDS SQL Server
body: <p>I'm trying to detach and attach a database in AWS RDS. I'm able to detach the database without any issues. But while I try to attach the database, I'm getting few errors. </p>
  
  <p>When I run the attach command for the first time, I get the following error:</p>
  
  <blockquote>
    <p>Unable to create database: User, group, or role 'sa' already exists in the current database.</p>
  </blockquote>
  
  <p>When I execute for the second time, I get this:</p>
  
  <blockquote>
    <p>Msg 1802, Level 16, State 7.<br>
    CREATE DATABASE failed. Some file names listed could not be created. Check related errors. </p>
    
    <p>Msg 5120, Level 16, State 101.<br>
    Unable to open the physical file "D:\RDSDBDATA\DATA\DBattachTest.mdf". Operating system error 2: "2(The system cannot find the file specified.)". (Line 6)</p>
  </blockquote>
  
  <p>Please advise</p>