Tried to checked the database and it turns out with this error. MSSQL Forums > Archive > microsoft.public.sqlserver.security > Error 15022: The specified user name is already aliased. How can it > be? Please login or register.
option. There are only three databases and only in one is one of > the owners selveisdbo. Jeff Borden microsoft.public.sqlserver.dts 3 08-21-2003 06:37 AM Forum Software Powered by vBulletin®, Copyright Jelsoft Enterprises Ltd. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. other
Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Change the owner of the given database and you'll be able to drop that login. Under the permit role it shows that the user has a dbo role. You cannot edit HTML code.
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. 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. Contact Us - Archive - Privacy Statement - Top Adaptive Server Enterprise 15.5 > Reference Manual: Procedures > System Procedures Â Â Chapter 1: System Procedures sp_addalias Description Allows an Adaptive Server Rand Boyd [MS] « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to
You cannot edit other events. Under the > > permit role it shows that the user has a dbo role. 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 I restored a > database backup from http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36273.1550/html/sprocs/X68891.htm Kelly" wrote: > You can use sp_change_users_login to fix this.
How can I drop this login? > > <1> sp_changedbowner selveisdbo > 2> go > Msg 17362, Level 16, State 1: > Server 'GW', Procedure 'sp_changedbowner', Line 97: > The proposed You cannot delete your own events. All Rights Reserved. As you can see from the console output below, selveisdbo > owns the database but does not exist in the same time as a user.
There are only three databases and only in one is one of > > the owners selveisdbo. http://www.tek-tips.com/viewthread.cfm?qid=331977 How can I drop this login? > > > Check if this logins is aliased in some database. > exec sp_dropalias username Roman Jemets Posted on 2004-06-14 18:32:54.0Z From: "Roman Jemets" was created by user ID %3!. You cannot edit your own posts.
Close Getting Started Store Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search SCN Wiki Spaces Browse Pages Labels Space Operations Quick You cannot edit other posts. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.
does not exist in the %2! Please execute 'use %2!' and try again.17289Â Â Â 0Â Â Â Â Â Â Â Â Â Â Â Â Set your curwrite to the hurdle of current database.17290Â Â Â 0Â Â Â Â Â Â Â Â Â Â Â Â There is already a server named '%1!', physical name '%2!'.17291Â Â Â 0Â Â Â Â Â Â Â Â Â Â Â Â sp_addserver servername Tried > to checked the database and it turns out with this error. > > Any idea folks? > > Thanks > > Ata John Andrew J.
Please try the request again. How can I drop this login? <1> sp_changedbowner selveisdbo 2> go Msg 17362, Level 16, State 1: Server 'GW', Procedure 'sp_changedbowner', Line 97: The proposed new db owner already is a Report Abuse. You might have a login test that's been aliased to another user name, but sp_helpuser should show this.If you have access to Sybase Central, it makes user manipulations a lot easier.One
Click Here to join Tek-Tips and talk with other members! exec sp_dropalias username Kalmer Bishop Posted on 2004-06-08 13:30:45.0Z Reply-To: "Kalmer Bishop"
Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! You cannot post events. Index Register Login You are not logged in.