December 2, 2024 at 6:33 am
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
December 3, 2024 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy