title: Visual Studio unable to publish or schema compare database
body: <p>I have no idea what went wrong with my Visual Studio, but I am unable to publish or schema compare any database on my development server. Here are my two issues:</p>
  
  <ul>
  <li><p>When publishing a new database I get an error message after timing out that says "Unable to reconnect to database"</p></li>
  <li><p>When schema comparing to an existing database I get an error message saying "An error was received from SQL Server while attempting to reverse engineer elements of type..."</p></li>
  </ul>
  
  <p><strong>Additional Troubleshooting</strong></p>
  
  <ul>
  <li>I am connecting to the server as myself with Windows
  Authentication. I am already set up on the development server as a
  sysadmin role.</li>
  <li>I have no issues logging in via Management Studio</li>
  <li>I can create a database using the login in Management Studio</li>
  <li>The "test connection" button in VS2012 says connection successful</li>
  <li>I have deleted the database in question from the database and attempted to republish with no success</li>
  <li>I have started a completely new VS SQL project and tried to publish a new test database, but have the same exact issue</li>
  <li><strong>I have no problems whatsoever on my production server</strong></li>
  <li>I have deleted my server login and recreated it</li>
  <li><strong>I can't schema compare or publish a database even with the [sa] account</strong></li>
  <li>I have restarted both SQL Server instance and Windows Server itself</li>
  </ul>
  
  <p>The only recent change to the server was that I restored two production database backups into my development server. I do not know if this is when the issue started.</p>
  
  <p>What else can/should I be trying??</p>
  
  <p><strong>Update</strong>
  This question is still preventing me from schema comparing or publishing any database. Even from a new project. Additional troubleshooting since the first post:</p>
  
  <ul>
  <li>Deleted SQL Server from the server and reinstalled</li>
  <li>Removed all connection references to development server from client registry</li>
  <li>SQL Server Profiler shows Visual Studio is successfully executing commands, however the above messages persist</li>
  </ul>