Return
-
Title
SQL Authentication vs Windows Authentication for the Migration Manager console? -
Description
Factors to consider when choosing your SQL Server authentication method. -
Cause
n/a -
Resolution
When configuring Migration Manager under the "Open Project..." wizard two options are given for the SQL server authentication method.- Use Windows Authenication
- SQL Authenication
If you choose Windows Authentication, you will notice it does NOT accept any credentials. Therefore SQL access is completely dependant on the Windows logon account to access SQL Server.If you choose SQL Authentication, you will notice a place to specify the service account. That service account will be used regardless of what account is used to logon to the Migration Manager console.Therefore, if you want access for any logged on account without having to specify or give access in SQL to those accounts then you will use SQL Authentication.If you want to use Windows Authentication then you will have to give each account access permissions within SQL Studio Management.