| Author |
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?
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| 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@microso
ft.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?
| |
| John Bell 2006-10-24, 6:33 pm |
| 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:
[color=darkred]
> 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:
>
| |
| Hari Prasad 2006-10-24, 6:33 pm |
| Hi,
Use the below URL:
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E- 602D2ACF2D9C@microso
ft.com...[color=darkred]
> 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:
>
| |
|
|
|
|