Monthly Archives: June 2016

Visual Studio Database Project error SQL03006: User: [xxx] has an unresolved reference to Login [xxx].

source url When I create a new database project wizard and import my existing database schema, it won’t “build”. I get the error:

http://starcommediafutures.com.au/speakers/ SQL03006: User: [xxx] has an unresolved reference to Login [xxx].

The Login is actually defined in the master database of the server install. The CREATE USER statement needs to point at an existing Login otherwise it errors. The Database Project is not aware of the Login at the server level. Either you can create a Server Project to handle the Logins, or you can turn off the checking of Security objects in your Database Project. See the answer by Demetri M for more details:(below)

protonix retail price get link What I did for the step “import database objects and settings” was as follows which did ultimately lead to fix:

Right click on the DB Server project and select to do an “Import objects and settings…”.  When they ask you for the server and database, select the same server as your Database Project and then select the “master” database on that server.  After that imports, you can then link the Database project to the Database Server Project.  Finally do a clean and rebuild of the solution and the User error should be cleared.

Anyway, that is what worked for me.  I hope this helps.