Re: Error 15022: The specified user name is already aliased.

From: Ata John (ataJohn_at_ata1.com)
Date: 10/16/03 

Date: Thu, 16 Oct 2003 14:29:55 -0500

Thanks Andrew, I tried it but I got this error:

The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users
was 0.

Is it because the ID is already aliased in the database?

Ata John

"Andrew J. Kelly" wrote:

> You can use sp_change_users_login to fix this. 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 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
> "Ata John" <anonymous@discussions.microsoft.com> wrote in message
> news:02d501c39412$7738f710$a301280a@phx.gbl...
> > Hi,
> >
> > I am getting this error message after I restored a
> > database backup from Production to a test box: error
> > 15022: The specified user name is already aliased.
> > However when you go to security > logins > and you go the
> > properties tab of the userID, the database access tab
> > doesn't show that the database has been checked. Under the
> > permit role it shows that the user has a dbo role. Tried
> > to checked the database and it turns out with this error.
> >
> > Any idea folks?
> >
> > Thanks
> >
> > Ata John

Relevant Pages

  • Re: Error running Copy Database Wizard (CDW)
    ... I am not sure why the error but why not simply do a restore or an attach ... Issues When a Database Is Moved Between SQL Servers ... > I am using the Copy Database Wizard to copy a database from one SQL ...
    (microsoft.public.sqlserver.tools)
  • Re: Move System and User database
    ... Andrew, Thanks for your reply! ... will the sa password be moved to the new server if system database ... > Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Re: tried dts copy of tables stored procedures etc and it fails exery time
    ... all its objects I would just either restore a full backup or use ... Issues When a Database Is Moved Between SQL Servers ... >, i don't have much expierience with sql 7 data base minuplation, can ...
    (microsoft.public.sqlserver.security)
  • Re: question -- copy database?
    ... > Passwords Between SQL Servers ... > Issues When a Database Is Moved Between SQL Servers ... and have SS recognize the database? ...
    (microsoft.public.sqlserver.dts)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)