How to copy user in master database to new server?

I just install new server for testing only. I have problem about user in
master database. How to copy all user from production server to testing
server?Are you referring to users in the master database or logins? Also, what version of SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:A01991A7-16F8-4E16-BC3F-EA21842E8011@.microsoft.com...
>I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||Hi
I assume you are meaning logins rather than users which can be scripted. To
transfer logins check out http://support.microsoft.com/kb/246133/
John
"Mesak" wrote:
> I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||If I have backup site (another building). I test system at backup site one
time per year. Do you have any solution to copy login to new server at backup
site?
Thank you.
"John Bell" wrote:
> Hi
> I assume you are meaning logins rather than users which can be scripted. To
> transfer logins check out http://support.microsoft.com/kb/246133/
> John
> "Mesak" wrote:
> > I just install new server for testing only. I have problem about user in
> > master database. How to copy all user from production server to testing
> > server?|||Hi,
Use the below URL:
http://www.databasejournal.com/features/mssql/article.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at
> backup
> site?
> Thank you.
> "John Bell" wrote:
>> Hi
>> I assume you are meaning logins rather than users which can be scripted.
>> To
>> transfer logins check out http://support.microsoft.com/kb/246133/
>> John
>> "Mesak" wrote:
>> > I just install new server for testing only. I have problem about user
>> > in
>> > master database. How to copy all user from production server to testing
>> > server?|||The solution to copy login is in the URL that John posted:
http://support.microsoft.com/kb/246133
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at backup
> site?
> Thank you.
> "John Bell" wrote:
>> Hi
>> I assume you are meaning logins rather than users which can be scripted. To
>> transfer logins check out http://support.microsoft.com/kb/246133/
>> John
>> "Mesak" wrote:
>> > I just install new server for testing only. I have problem about user in
>> > master database. How to copy all user from production server to testing
>> > server?