1

Topic: error 15022 the specified username is already aliased (sql 2000)

Hello.
Help to solve a problem.
SQL 2000, users from the Directory Active there have been added.
Yesterday renamed one security account into the Active of the Directory and in SQL remained old , I deleted it from SQL and anew added from the Hell already new renamed.  it was added normally But when I try in property of the user on the contribution "Database Access" to add to it the necessary basis "TEST" produces an error "error 15022 the specified username is already aliased".
Where to dig?

2

Re: error 15022 the specified username is already aliased (sql 2000)

bahadyr;
Deleted both from logins and from users of a DB of the SQl-server?

3

Re: error 15022 the specified username is already aliased (sql 2000)

All found the reason.
use TEST
go
sp_dropalias ' DOMAIN\staryj_login'

4

Re: error 15022 the specified username is already aliased (sql 2000)

icprog;
Yes, from both through the graphic interface.