This can be beneficial to other community members reading the thread. Kelly Tom Moreau Guest Posts: n/a 10-16-2003 Check out sp_change_users_login in the BOL. -- Tom --------------------------------------------------------------- Thomas A. exec sp_helpuser dbo Aliasing is deprecated in sql server 2005 and it will be removed from in future versions... SRJ2005 reethu, Apr 24, 2007 #2 MohammedU New Member You need use sp_changedbowner procedure to remove sa mapping... Source
You may download attachments. You cannot post replies to polls. Copyright © 2002-2017 Redgate. 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 click site
You cannot post or upload images. SRJ2005 reethu, Apr 23, 2007 #2 MohammedU New Member Tod find the dbo alias run the following... Devi Prasad Gakkula SQL Server Analyst.
Privacy statement © 2017 Microsoft. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 2005 Forum Topics > SQL Server 2005 General DBA Questions This can be beneficial to other community members reading the thread. You cannot post events.
All Rights Reserved. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy. Tried > > to checked the database and it turns out with this error. > > > > Any idea folks? > > > > Thanks > > > > Ata setuser 'dbo' select user_name(), suser_sname() >> dbo sa setuser 'adriaan' select user_name(), suser_sname() >> adriaan adriaan Adriaan, May 4, 2007 #2 (You must log in or sign up to reply here.)
SRJ2005 reethu, Apr 25, 2007 #2 reethu New Member thanks it is working fine. You cannot delete your own events. Please login or register. 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:
create login [Dalton] with password = 'asdfASDF1234', sid = 0x81345DC7C969F84DA2E1C7852DFF48D9 Then I tried... 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 You can use sp_addrolemember procedure to add to a role... Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?
Index Register Login You are not logged in. http://smartnewsolutions.com/the-specified/the-specified-color-profile-is-invalid-windows-server-2003.html You cannot post IFCode. 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 SRJ2005 reethu, May 4, 2007 #2 Adriaan New Member Don't get confused: 'sa' is the login name corresponding to user name 'dbo'.
reethu New Member Hi guys i know this quastions seems to simple but i did not understand when i try to create user in db i got this error. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? You cannot delete other topics. have a peek here The time now is 08:29 PM.
Post #1516195 LowellLowell Posted Wednesday, November 20, 2013 2:53 PM SSChampion Group: General Forum Members Last Login: Today @ 10:22 AM Points: 14,657, Visits: 38,744 the issue here is an orphaned 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 edit your own topics.
asking the question the right way gets you a tested answer the fastest way possible! Ata John "Andrew J. Thanks Ata John Tom Moreau Ata John Guest Posts: n/a 10-16-2003 Thanks Andrew, I tried it but I got this error: The number of orphaned users fixed statement and INSERT INTO...
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. You cannot vote within polls. Report Abuse. http://smartnewsolutions.com/the-specified/the-specified-web-server-is-not-running-asp-net-1-1.html HOW TO CONVERT TABLE DATA TO XML AND XML TO TABLE All about SQL Server Views When To Use LOWER/UPPER for comparing data in SQL Server - Alternatives Categories ►CHANGE DATA
Forgot your password? Under the > permit role it shows that the user has a dbo role. 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: Kelly Guest Posts: n/a 10-16-2003 You can use sp_change_users_login to fix this.
Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix