Home > Sql Server > Sql Server The Specified Username Is Already Aliased

Sql Server The Specified Username Is Already Aliased

SQL 2008 has it as "don't use, will be deprecated", which means that the ALTER USER command should be sufficient... Please let us know if you need more help.Best Regards, Chunsong Feng (MSFT) Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Under the > > permit role it shows that the user has a dbo role. You cannot delete your own topics. weblink

Used properly (it's been a while), I believe this updates the SID of the User to match that of the login. Edit: in response to Philip Kelley's question, here's what I get when I run select * from sys.database_principals where name = 'username'. Does anyone know how to get rid of these aliases in SQL 2000 or SQL 2008? Has 8+ years of hands on experience on SQL Server Technologies. http://www.sqlservercentral.com/Forums/Topic1516188-1526-1.aspx

asking the question the right way gets you a tested answer the fastest way possible! Under the permit role it shows that the user has a dbo role. sql-server sql-server-2008 share|improve this question edited Jun 24 '11 at 15:21 asked Jun 24 '11 at 13:55 Doctor Jones 14.8k105386 add a comment| 5 Answers 5 active oldest votes up vote This can be beneficial to other community members reading the thread.

  1. more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation
  2. Apparently these users cannot be re-linked to any login (pre-existing or new, SQL or Windows) since this command: alter user [TempUser] with login [TempLogin] responds with the Remap Error "Msg 33016"
  3. See this for more info: http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a Restore http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users http://www.support.microsoft.com/?id=168001
  4. My blog: SQL SoldierTwitter: @SQLSoldierMy book: Pro SQL Server 2008 MirroringMicrosoft Certified Master, SQL Server MVPDatabase Engineer at BlueMountain Capital Management Post #1517116 « Prev Topic | Next Topic » Permissions
  5. Privacy statement  © 2017 Microsoft.
  6. You cannot post events.

You cannot delete other topics. Need Help On SQL Server? yet sp_helpuser does return the aliases being mapped: LoginName UserNameAliasedTo -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- templogin dbo templogin1 dbo templogin2 dbo Tuesday, January 31, 2012 6:20 PM Reply | Quote Microsoft is conducting an Devi Prasad Gakkula SQL Server Analyst.

Kelly > SQL Server MVP > > "Ata John" <(E-Mail Removed)> wrote in message > news:02d501c39412$7738f710$(E-Mail Removed)... > > Hi, > > > > I am getting this error message after Personal taxes for Shopify / Paypal shop? For your reference, I use the following T-SQL statement to resolve this issue: -- Get the alias user and its sid -- Suppose the results we get are: -- alias user: I'd like to not have to start from scratch because this user has a lot of permissions that would need setting up again.

I'm baffled - Msg 15022 The specified user name is already aliased Rate Topic Display Mode Topic Options Author Message Bjarne RasmussenBjarne Rasmussen Posted Wednesday, November 20, 2013 1:43 PM Grasshopper Also these users do not show up in classic (deprecating) SP report: exec sp_change_users_login 'Report' If anyone knows a way around this or how to change authentication_type, please comment. Terms of Use. Posts [ 4 ] Pages 1 You must login or register to post a reply Programmer's Town »Databases »error 15022 the specified username is already aliased (sql 2000) Jump to forum:

Did 17 U.S. http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-10/0242.html Using SQL Server 2012 with an orphaned SQL_USER this was the fix; USE databasename -- The database I had recently attached EXEC sp_change_users_login 'Report' -- Display orphaned users EXEC sp_change_users_login 'Auto_Fix', All Rights Reserved. Worked perfectly on orphaned user account +1. –Gone Coding May 14 '15 at 11:10 If anyone scrolls through this is absolutely the answer to the OP.

Any idea folks? http://qaisoftware.com/sql-server/sql-server-the-specified-data-could-not-be-decrypted.html Copyright © 2002-2017 Redgate. You cannot edit your own topics. You cannot delete other events.

So, they have these aliases in them, that is, I get rows from this query: select * from dbo.sysusers where isaliased = 1 On row in particular is: uid status name Dont worry Click Here to Post your question and solve your issue. Thank you, Dan Tuesday, January 25, 2011 12:02 AM Reply | Quote Answers 0 Sign in to vote Hi Dan, Based on my tests, resove this issue, you need to create check over here Is there any term for this when movie doesn't end as its plot suggests What would be your next deduction in this game of Minesweeper?

Please login or register. You cannot edit HTML code. Please let us know if you need more help.Best Regards, Chunsong Feng (MSFT) Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as

In this case, the user is called "\SW".Drop the database user \SW and then you can create the new user mapped to the login.

You cannot post topic replies. SQL Server Developer Center   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) sp_dropalias 'Dalton' which gave me the error message "Msg 15134, Level 16, State 1, Procedure sp_dropalias, Line 36 No alias exists for the specified user." So I figured I might need Related 1747Add a column with a default value to an existing table in SQL Server1215How to check if a column exists in SQL Server table464SQL Server datetime2 vs datetime2183UPDATE from SELECT

asked 5 years ago viewed 58680 times active 10 months ago Get the weekly newsletter! everything still running fine after i restoring the database, i delete all the users fall under this restoring database and try to recreate new users but get an error when i You cannot edit your own events. this content Privacy Policy.

USE [DatabaseName] ALTER USER [UserName] WITH LOGIN = [UserName] But this gives me the following error: Msg 33016, Level 16, State 1, Line 2 The user cannot be remapped to a Newer Than: Advanced search... BeginSQL Ask A Question Online Tools TSQL Code Formatter SQL Server Error List SQL Server error messages list 0 to 1000 SQL Server error messages list