SQL Server logins (server principals) have an SID associated with them. This is used to map logins to database users.
I'm using the script to transfer logins to another SQL Server instance: Transfer logins and passwords between instances of SQL Server
The generated output has got the SID value for SQL Server logins, but there is no SID for windows users and groups. This is understandable for AD windows users and groups since their SID is derived from the AD. However for local windows users, groups and local service accounts the script doesn't include the SID.
For example: NT SERVICE\MSSQLSERVER, NT SERVICE\SQLSERVERAGENT, NT AUTHORITY\SYSTEM and my local windows users (PCNAME\USER1) don't have an SId generated by the above script.
I realize that the local SQL Server service accounts (listed above) have the same SID on every SQL Server instance. Maybe that is why their SID isn't included in the script.
But what about local windows users? Will these definitely be orphaned when using this script or is there any workaround to ensure that the local windows users aren't orphaned?