• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 1523 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

on

joshua fellers
over 6 years ago

We have been using this tool with no issues until we tried to authenticate to SQL using a Windows account vs SQL Server account. Is there a hidden or special syntax required to use windows authentication for the SQL (/Conn) connection to use windows accounts? We have tried user@domain and domain\User with no luck.

  • 0 over 6 years ago

    The title got wiped? odd... I am referring to the DBTransporterCMD.exe tool.

  • 0 over 6 years ago

    Joshua,

    The following command works for me:

    .\DBTransporterCmd.exe /File="<filepath>" /Conn="Data Source=<DB Server/Instance>;Initial Catalog=<DB Name>;Integrated Security=True;Pooling=False" /Auth="Module=DialogUser;User=<System User>;Passwor<Passwrod>" -L

    The Conn is just a standard SQL connection string using windows authN.

    Regards,

    Craig