User already exists in current database SQL Server 2005 Error 15023http://interactiveasp.net/blogs/natesstuff/archive/2008/01/14/user-already-exists-in-current-database-sql-server-2005-error-15023.aspxI posted a blog entry a while back about how to change the owner of a database. What that still does not solve is the problem you have when there is a database user in the database you restored and there is a database user already in your system, eachenCommunityServer 2008 (Build: 30417.1769)re: User already exists in current database SQL Server 2005 Error 15023http://interactiveasp.net/blogs/natesstuff/archive/2008/01/14/user-already-exists-in-current-database-sql-server-2005-error-15023.aspx#1219Fri, 31 Jul 2009 22:06:57 GMTb80005ef-4071-4968-b08e-765d7d71b33e:1219scripter<p>gr8 post, solved my problem with a preexisting login name. Thx a lot.</p> <div style="clear:both;"></div><img src="http://interactiveasp.net/aggbug.aspx?PostID=1219" width="1" height="1">re: User already exists in current database SQL Server 2005 Error 15023http://interactiveasp.net/blogs/natesstuff/archive/2008/01/14/user-already-exists-in-current-database-sql-server-2005-error-15023.aspx#377Wed, 14 Jan 2009 10:22:01 GMTb80005ef-4071-4968-b08e-765d7d71b33e:377Sham<p>Good blog.Thnx a lot</p> <div style="clear:both;"></div><img src="http://interactiveasp.net/aggbug.aspx?PostID=377" width="1" height="1">re: User already exists in current database SQL Server 2005 Error 15023http://interactiveasp.net/blogs/natesstuff/archive/2008/01/14/user-already-exists-in-current-database-sql-server-2005-error-15023.aspx#125Tue, 28 Oct 2008 13:42:55 GMTb80005ef-4071-4968-b08e-765d7d71b33e:125Chris Luebbe<p>Thank you!!!</p> <div style="clear:both;"></div><img src="http://interactiveasp.net/aggbug.aspx?PostID=125" width="1" height="1">re: User already exists in current database SQL Server 2005 Error 15023http://interactiveasp.net/blogs/natesstuff/archive/2008/01/14/user-already-exists-in-current-database-sql-server-2005-error-15023.aspx#17Wed, 23 Apr 2008 07:11:27 GMTb80005ef-4071-4968-b08e-765d7d71b33e:17Kipp<p>The important distinction is that if you already have a user by the same name then you need to use: EXEC sp_change_users_login &#39;update_one&#39;, &#39;WebUser&#39;, &#39;WebUser&#39;; &nbsp;If you do not have a user by that name already in that database, you need to use: EXEC sp_change_users_login &#39;Auto_Fix&#39;, &#39;WebUser&#39;, NULL, &#39;MyWebUserPassword&#39;</p> <div style="clear:both;"></div><img src="http://interactiveasp.net/aggbug.aspx?PostID=17" width="1" height="1">