Creating LS from IaaS to Paas using MFA

• gkramer 23701

  Ten Centuries

  Points: 1383

  More actions

  December 2, 2024 at 6:33 am

  #4491974

  Guys - I need your help on this....

  I like to create an linked server from an IaaS (VM) to a PaaS managed instance but when I heve to loging to the MI using MFA I have to respond using mij GSM ( entering a code to confirm it is me ).

  How can I create a Linked Server to do the same automaticly (when opening the connectiong through the LS)?

  I use this script (in basic)

  where I set the TIME-OUT on de IaaS server to 0 (zero) iso 600 and Named-pipes = Enabled.

   

  EXEC master.dbo.sp_addlinkedserver @server = N'Bla-Bla-server.123456789.database.windows.net', @srvproduct=N'', @provider=N'SQLNCLI11', @datasrc=N'Bla-Bla-server.123456789.database.windows.net', @catalog=N'tempdb'

  EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'Bla-Bla-server.123456789.database.windows.net',@useself=N'False',@locallogin=NULL,@rmtuser=N'TEST-LS-GK',@rmtpassword='########'

  EXEC master.dbo.sp_serveroption @server=N .....

  EXEC master.dbo.sp_serveroption @server=N .....

  EXEC master.dbo.sp_serveroption @server=N .....

  EXEC master.dbo.sp_addlinkedsrvlogin

  @rmtsrvname = 'Bla-Bla-server.123456789.database.windows.net',

  @locallogin = NULL ,

  @useself = N'False',

  @rmtuser = 'TEST-LS-GK',

  @rmtpassword = N'########'

   

  Hope someone can help me out on this...

  Regards,

  Guus Kramer