Is it possible to develop SQL Server Integration Services packages that connect to databases that only use windows authentication without running Visual Studio with run as (using a user that has access to the database)?

Rui Pedro 1 Reputation point
2022-09-30T10:16:55.293+00:00

I need to transfer information from one DB to another using 2 different users and both use Windows Authentication Only.

Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,721 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 43,931 Reputation points
    2022-09-30T15:39:04.5+00:00

    Hello there,

    Have you tried any third-party tools like Systool or EaseUS Server Migration Software for the migration?

    To insert into values in One database table into another database table running on the same SQL Server

    insert into dbo.onedatabase.FolderStatus
    (
    [FolderStatusId],
    [code],
    [title],
    [last_modified]
    )

    select [FolderStatusId], [code], [title], [last_modified]
    from dbo.Twodatabase.f_file_stat

    Transfer data between SQL database servers securely by end-to-end service https://learn.microsoft.com/en-us/answers/questions/578717/transfer-data-between-sql-database-servers-securel.html

    Transfer logins and passwords between instances of SQL Server https://learn.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances

    ----------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept it as an answer–

    0 comments