title: Local Load Testing: The load test results database could not be opened
body: <p>I am creating some Load tests using VS2012. I can run the tests using a StorageType of "None", but when I change this to a StorageType of "Database" I get the dreaded error</p>
  
  <blockquote>
    <p>The load test results database could not be opened.  Check that the
    load test results database specified by the connect string for your
    test controller (or local machine) specifies a database that contains
    the load test schema and that is currently available.  For more
    information, see the Visual Studio help topic 'About the Load Test
    Results Store'.   The connection error was: An error occurred while
    attempting to create the load test results repository schema: To
    create the database 'LoadTest2010' your user account must have the
    either the SQL Server 'sysadmin' role or both the 'serveradmin' and
    'dbcreator' roles</p>
  </blockquote>
  
  <p>I have created a database on a non local copy of SQL called LoadTest. When I test the connection from the SQL Tracing Connect String dialog I get a success. </p>
  
  <p>I have created a SQL user that has the Server Roles of dbcreator, public, serveradmin and sysadmin. The user has a User Mapping to the LoadTest2010 database that was created from the loadtestresultsrepository.sql in the VS2012 IDE directory. On the database the user has the Database role memberships db_accessadmin, db_datareader, db_datawriter, db_owner.
  In the Owned Schemas i ticked on the db_datareader, db_datawriter, db_owner and db_securityadmin howver these have now gone to a blue square instead of a tick when displayed.</p>
  
  <p>So what's going on? Is Visual studio trying to create the database or is something else the issue? </p>
  
  <p>I am not using TestControllers or TestAgents I am simply using a local run.</p>