SQL Server using Windows Authentication |
Post Reply |
Author | |
kpmartin
Newbie Joined: 16 Oct 2019 Status: Offline Points: 2 |
Post Options
Thanks(0)
Posted: 16 Oct 2019 at 7:10am |
Microsoft's SQL Server stores SIDs to associate clients connecting to the server using Windows Authentication with their SQL Logins and SQL Database Users. I haven't found anything to either confirm or refute that even using the Forensit User Profile Wizard, you still end up with a different SID than what you started with, so your access to SQL Server will (probably) be lost after migration. This would also be true of any other software that recognizes you by SID. So... after migration do you end up with the same SID or a different SID?
|
|
Support
Moderator Group Joined: 09 Nov 2006 Location: United Kingdom Status: Offline Points: 1844 |
Post Options
Thanks(0)
|
User Profile Wizard migrates the user profile to a new user account. The new user account will have a different SID.
|
|
kpmartin
Newbie Joined: 16 Oct 2019 Status: Offline Points: 2 |
Post Options
Thanks(0)
|
Thanks for the prompt response. Although this is still a cleaner transfer than MS's migration tool, perhaps you could add to your FAQ those few things that might be left broken after the migrations. Things that come to mind are:
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |