copying sql server logins and users

Hi All,
I have a user database with 20 users. I have to transfer this database to some other location (location B) with the user and login, so that others would be able to login (assuming i have provided them username and pwd for logging). I can take the backup of the database, which can be restored at location b, in which the users will also be available.
Now my question i
Is there a mechansim to copy sql server logins also, such that, when the database is restored at location b, the users will be able to simply login...
Thanks
GYKThis should help
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&
Ray Higdon MCSE, MCDBA, CCNA
--
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:40A125DF-6C22-48DA-9780-DA7A7ED52B5E@.microsoft.com...
> Hi All,
> I have a user database with 20 users. I have to transfer this database to
some other location (location B) with the user and login, so that others
would be able to login (assuming i have provided them username and pwd for
logging). I can take the backup of the database, which can be restored at
location b, in which the users will also be available.
> Now my question is
> Is there a mechansim to copy sql server logins also, such that, when the
database is restored at location b, the users will be able to simply
login...
> Thanks
> GYK

Copying SQL logins to new Domain

Good day!
I have 2 SQL 2000 Servers, in a NT4 domain, that will be staying tehre
for the time being. But I am starting to move users from that domain
to an AD domain. We are doing them bit by bit. I want the Windows
Authentication-based SQL Logins to move over so that I don't have to
re-create the logins.
What is the best way to do this, assuming I want to do them slowly?
Thanks.Have you considered creating Groups on the new domain, give the groups the
relevant SQL permissions and when you're ready to migrate a user simply add
him to the new group.
HTH
Ryan Waight, MCDBA, MCSE
"Bob" <Bob@.nospam.com> wrote in message
news:nkkfqvg1fvjnc0j8lu9l8c2i2trtvvf8jq@.4ax.com...
> Good day!
> I have 2 SQL 2000 Servers, in a NT4 domain, that will be staying tehre
> for the time being. But I am starting to move users from that domain
> to an AD domain. We are doing them bit by bit. I want the Windows
> Authentication-based SQL Logins to move over so that I don't have to
> re-create the logins.
> What is the best way to do this, assuming I want to do them slowly?
> Thanks.
>|||I suppose I could do that. But is there a way to do what I am looking
to do?
On Tue, 4 Nov 2003 16:52:42 -0000, "Ryan Waight"
<Ryan_Waight@.nospam.hotmail.com> wrote:
>Have you considered creating Groups on the new domain, give the groups the
>relevant SQL permissions and when you're ready to migrate a user simply add
>him to the new group.|||Bob wrote:
> Good day!
> I have 2 SQL 2000 Servers, in a NT4 domain, that will be staying tehre
> for the time being. But I am starting to move users from that domain
> to an AD domain. We are doing them bit by bit. I want the Windows
> Authentication-based SQL Logins to move over so that I don't have to
> re-create the logins.
> What is the best way to do this, assuming I want to do them slowly?
you might try running sp_help_revlogin and then editing the script to your
liking.|||Hi Bob,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.
From your description, I understand that you would like to transfer the Windows Authentication
Logins and passwords to a new AD domain between the instances of SQL Server. Have I fully
understood you? If there is anything I misunderstood, please feel free to let me know.
I agree with Chxxx that you can create sp_help_revlogin stored procedure on the source
server, which this procedure generates a script that you can run on the destination server to re-
create logins with the original security identification number (SID) and retain the current
passwords.
For how to transfer Logins and Passwords between SQL Server 2000, please refer to the
following step by step articles:
246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/?id=274188
Bob, does this answer your question? Please apply the suggestion above and let us know if it
helps you resolve your problem. If there is anything more we can assist you with, please feel
free to post it in the group.
Best regards,
Billy Yao
Microsoft Online Partner Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||> From your description, I understand that you would like to transfer the
Windows Authentication
> Logins and passwords to a new AD domain between the instances of SQL
Server. Have I fully
> understood you? If there is anything I misunderstood, please feel free to
let me know.
If Bob is interested in the Windows authentication logins, why would he like
to transfer the passwords?
One of the problems with migrating the NT user accounts to AD how to deal
with the following scenario:
1. NT user NTDomain\myUser is migrated to ADDomain\myUser (likely with
SIDHistory)
2. The SID of NTDomain\myUser is different from ADDomain\myUser
3. The system tables sysxlogins and sysusers still store the SID for
NTDomain\myUser
4. If the NTDomain domain is completely disabled, SIDHistory will not be
useful any more
(Note, not being an AD migration expert, I don't know whether you can
migrate NT user accounts to AD without assigning them new SIDs. It's not how
we are migrating user account anyway.)
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Billy Yao [MSFT]" <v-binyao@.online.microsoft.com> wrote in message
news:7GUTrC0oDHA.2148@.cpmsftngxa06.phx.gbl...
> Hi Bob,
> Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
> From your description, I understand that you would like to transfer the
Windows Authentication
> Logins and passwords to a new AD domain between the instances of SQL
Server. Have I fully
> understood you? If there is anything I misunderstood, please feel free to
let me know.
> I agree with Chxxx that you can create sp_help_revlogin stored procedure
on the source
> server, which this procedure generates a script that you can run on the
destination server to re-
> create logins with the original security identification number (SID) and
retain the current
> passwords.
> For how to transfer Logins and Passwords between SQL Server 2000, please
refer to the
> following step by step articles:
> 246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL
Server
> http://support.microsoft.com/?id=246133
> 240872 HOW TO: Resolve Permission Issues When You Move a Database Between
> http://support.microsoft.com/?id=240872
> 274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is
Incomplete
> http://support.microsoft.com/?id=274188
>
> Bob, does this answer your question? Please apply the suggestion above and
let us know if it
> helps you resolve your problem. If there is anything more we can assist
you with, please feel
> free to post it in the group.
>
> Best regards,
>
> Billy Yao
> Microsoft Online Partner Support
> ----
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>
>|||Hi Bob,
I agree with Linchi's comments and thanks for his reminder.
If you transfer logins to an instance of SQL Server in a different domain than the source
instance of SQL Server, you should edit the script generated by the sp_help_revlogin
procedure, and REPLACE the domain name with the new domain in the sp_grantlogin
statements. Because the integrated logins granted access in the new domain will not have the
same SID as the logins in the original domain, the database users will be orphaned from
these logins.....
This is announced in the "Remarks" of the KB 246133. I recommend you review the remarks
carefully before you apply this logins transference, so that you will not miss some important
points you should pay attention to.
246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133
If there is anyting unclear or anything more I can assist you with, please feel free to post it in the
group.
Best regards,
Billy Yao
Microsoft Online Partner Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Copy users between databases

Hello All,
I used DTS to copy one database to a blank database for a backup of the
database. A duplicate database.
How do I copy over the user logins to the new database.
This did not happen with DTS.
The databases are on the same instance of SQL.
Any help appreciated.
Thanks,
Terry
tgwillett@.cox.netRun this on the database to autofix users
select 'exec sp_change_users_login ''Auto_Fix'', ''' + name + '''' from
sysusers
where name not in ('INFORMATION_SCHEMA', 'dbo', 'guest', 'public')
"Terry" wrote:

> Hello All,
> I used DTS to copy one database to a blank database for a backup of the
> database. A duplicate database.
> How do I copy over the user logins to the new database.
> This did not happen with DTS.
> The databases are on the same instance of SQL.
> Any help appreciated.
> Thanks,
> Terry
> tgwillett@.cox.net
>
>

Copy users between databases

Hello All,
I used DTS to copy one database to a blank database for a backup of the
database. A duplicate database.
How do I copy over the user logins to the new database.
This did not happen with DTS.
The databases are on the same instance of SQL.
Any help appreciated.
Thanks,
Terry
tgwillett@.cox.netThis is a pretty good article on it:
http://support.microsoft.com/defaul...kb;en-us;246133
Christian
"Terry" <tgwillett@.cox.net> wrote in message
news:r_62g.56456$gE.9859@.dukeread06...
> Hello All,
> I used DTS to copy one database to a blank database for a backup of the
> database. A duplicate database.
> How do I copy over the user logins to the new database.
> This did not happen with DTS.
> The databases are on the same instance of SQL.
> Any help appreciated.
> Thanks,
> Terry
> tgwillett@.cox.net
>

Copy users between databases

Hello All,
I used DTS to copy one database to a blank database for a backup of the
database. A duplicate database.
How do I copy over the user logins to the new database.
This did not happen with DTS.
The databases are on the same instance of SQL.
Any help appreciated.
Thanks,
Terry
tgwillett@.cox.netThis is a pretty good article on it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
Christian
"Terry" <tgwillett@.cox.net> wrote in message
news:r_62g.56456$gE.9859@.dukeread06...
> Hello All,
> I used DTS to copy one database to a blank database for a backup of the
> database. A duplicate database.
> How do I copy over the user logins to the new database.
> This did not happen with DTS.
> The databases are on the same instance of SQL.
> Any help appreciated.
> Thanks,
> Terry
> tgwillett@.cox.net
>

Copy the Logins

Hi,
I have SQL Server 2000 in Machine 'Machine1'. SQL Server
name is 'SQL1'. In SQL1, some miscellaneous databases
and some logins are there.
In a new Machine, 'Machine2', I've installed the another
SQL Server 2000 and the sql server name is 'SQL2'.
I have taken the backup of miscellaneous databases from
SQL1 and restored it in SQL2.
Now what I want is, how to copy the user logins from
SQL1 to SQL2, because all the logins are stored in master
database in SQL1.
kindly help, plz.
Sathu Kutti.Hi,
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Sathu Kutti" <anonymous@.discussions.microsoft.com> wrote in message
news:240bb01c45f48$62086d60$a301280a@.phx
.gbl...
> Hi,
> I have SQL Server 2000 in Machine 'Machine1'. SQL Server
> name is 'SQL1'. In SQL1, some miscellaneous databases
> and some logins are there.
> In a new Machine, 'Machine2', I've installed the another
> SQL Server 2000 and the sql server name is 'SQL2'.
> I have taken the backup of miscellaneous databases from
> SQL1 and restored it in SQL2.
> Now what I want is, how to copy the user logins from
> SQL1 to SQL2, because all the logins are stored in master
> database in SQL1.
> kindly help, plz.
>
> Sathu Kutti.

copy sql server db on same server

what would be the best way to copy the entire db to the same server instance?
The only thing is the db name needs to be changed. But the logins, tables,
etc are all the same.
Can't use the wizard since the same instance...
thanx?
Simply restore a full backup and restore it to a different db name and
either place the files on different drives or rename them with the MOVE
option.
Andrew J. Kelly SQL MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F44B8F48-4635-45AD-844F-473899A5B94E@.microsoft.com...
> what would be the best way to copy the entire db to the same server
> instance?
> The only thing is the db name needs to be changed. But the logins, tables,
> etc are all the same.
> Can't use the wizard since the same instance...
> thanx?

copy sql server db on same server

what would be the best way to copy the entire db to the same server instance
?
The only thing is the db name needs to be changed. But the logins, tables,
etc are all the same.
Can't use the wizard since the same instance...
thanx?Simply restore a full backup and restore it to a different db name and
either place the files on different drives or rename them with the MOVE
option.
Andrew J. Kelly SQL MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F44B8F48-4635-45AD-844F-473899A5B94E@.microsoft.com...
> what would be the best way to copy the entire db to the same server
> instance?
> The only thing is the db name needs to be changed. But the logins, tables,
> etc are all the same.
> Can't use the wizard since the same instance...
> thanx?

copy sql server db on same server

what would be the best way to copy the entire db to the same server instance?
The only thing is the db name needs to be changed. But the logins, tables,
etc are all the same.
Can't use the wizard since the same instance...
thanx?Simply restore a full backup and restore it to a different db name and
either place the files on different drives or rename them with the MOVE
option.
--
Andrew J. Kelly SQL MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F44B8F48-4635-45AD-844F-473899A5B94E@.microsoft.com...
> what would be the best way to copy the entire db to the same server
> instance?
> The only thing is the db name needs to be changed. But the logins, tables,
> etc are all the same.
> Can't use the wizard since the same instance...
> thanx?