ForensiT Homepage
Forum Home Forum Home > ForensiT Support > Desktop Management
  Active Topics Active Topics
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

SQL Server using Windows Authentication

 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
kpmartin View Drop Down
Newbie
Newbie


Joined: 16 Oct 2019
Online Status: Offline
Posts: 2
  Quote kpmartin Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server using Windows Authentication
    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?
Back to Top
Support View Drop Down
Moderator Group
Moderator Group


Joined: 09 Nov 2006
Location: United Kingdom
Online Status: Offline
Posts: 1330
  Quote Support Quote  Post ReplyReply Direct Link To This Post Posted: 17 Oct 2019 at 3:29am
User Profile Wizard migrates the user profile to a new user account. The new user account will have a different SID.
Back to Top
kpmartin View Drop Down
Newbie
Newbie


Joined: 16 Oct 2019
Online Status: Offline
Posts: 2
  Quote kpmartin Quote  Post ReplyReply Direct Link To This Post Posted: 17 Oct 2019 at 10:14am
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:
  • File system permissions elsewhere than within the new Profile (I assume)
  • SQL accounts using Windows Authentication
  • Personal encrypted information including:
    • Private keys for certificates
    • File system encryption keys
    • (probably) stored credentials

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.016 seconds.