Group Already Exists

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John E Davis (JohnEDavis_at_discussions.microsoft.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 08:27:02 -0800

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

Relevant Pages

  • Re: SQL job owner and right
    ... It is the wrong type of account. ... who can login with that account can manage those jobs. ... Windows group that both windows users belong to and have that own the ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: builtin/administrators
    ... I suggest you start with creating a new windows group, ad appropriate windows users, add it to SQL ... Server and grant sysadmin for that. ...
    (microsoft.public.sqlserver.server)
  • copy permissions from one user to another?
    ... Is it possible in SQL 2000 to copy the permissions assigned to one database ... user(a windows group in this instance) to another user using a ... Jez. ...
    (microsoft.public.sqlserver.security)
  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 express security issue
    ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ... You do not have to use the "sa" account and it's not recommended using this account because every hacker knows that SQL Server has a built-in sysadmin account which is called "sa". ...
    (microsoft.public.sqlserver.security)