The specified username is already aliased | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The specified username is already aliased

hello buddy, i have a question here. i am installing SQL 6.5 with SP4 into a server with WINDOWS SERVER 2000.
After i complete my installation , i am restoring the backup database to this server 6.5.
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 try to assign the users permission to the database: ERROR 15022 : [SQL SERVER] THE SPECIFIED USER IS ALREADY ALIASED. I COULDN’T SEE ANY OF THIS USER IN THIS SCREEN AND I CHECKED USING THE SP_CHANGE_USERS_LOGIN ‘REPORT’, AND IT RETURN 0 RESULT. I ALSO TRY TO LOCATE IN THE SYSUSERS AND SYSLOGINS TABLE BUT STILL I COULDN’T FOUND ANY USERS CONFLICT WITH THE ONE I CREATED, PLEASE HELP!!!!!!!!!!!!!!!!


http://groups.google.com/group/micr…285550d7b81efdf?sa=X&oi=groupsr&start=1&num=3 —————————————-
http://spaces.msn.com/members/dineshasanka

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |