Database Administrators Asked by user1430949 on October 28, 2021
I am setting up a second SQL Server for a backup site.
I am using SSIS to transfer user logins from production to site2.
I was wondering whether I should transfer the NT Service,NT AUTHORITY and ###MS****### logins from one server to the other or set those up separately on site 2 ?
I was wondering whether I should transfer the NT Service,NT AUTHORITY and ###MS****### logins from one server to the other
No need to transfer those logins, because they are created automatically when you install new SQL Server instance
By the way, easiest way to transfer other logins from one server to another, is to use sp_help_revlogin procedure:
How to transfer logins and passwords between instances of SQL Server
Answered by Aleksey Vitsko on October 28, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP