Re: Group Already Exists
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 01/10/05
- Next message: Geoff N. Hiten: "Re: How do I Allow SQL DB dump job through a firewall?"
- Previous message: Paul Cyr: "How do I Allow SQL DB dump job through a firewall?"
- In reply to: John E Davis: "Group Already Exists"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 10 Jan 2005 14:55:48 -0500
Update your client tools to SP3a. You can then see 'orphaned' users,
including Windows-based users, in your database. You can then delete the
database user before re-adding it. 'sp_change_users_login' only allows you
to fix SQL-based logins.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "John E Davis" <JohnEDavis@discussions.microsoft.com> wrote in message news:B6D1B78F-29B5-4AAC-A2CE-FCF1D9D546CF@microsoft.com... > I have run the "sp_change_user_logins" to create accounts that were already > lodged in a database to the new SQL server. > > I have a Windows Group that I would like to recreate the SQL login for but I > get an error when I manually try to create the account stating that the > account already exists. > > I don't see a Stored Procedure for the Groups other then "changegroup" but > that just changes a users setting for an existing group. > > So the question is, HOw do I bring that Windows Group that already exists in > the database so that I can create a SQL logon for that Windows Group. > > Thanks
- Next message: Geoff N. Hiten: "Re: How do I Allow SQL DB dump job through a firewall?"
- Previous message: Paul Cyr: "How do I Allow SQL DB dump job through a firewall?"
- In reply to: John E Davis: "Group Already Exists"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
