Azure SQL Database
An Azure relational database service.
5,924 questions
How to setup Linked servers in SQL server using Managed Service accounts
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chakraborty, Sarmistha
6
Reputation points
Need to setup ADSI linked server for running LDAP queries using gMSA.
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini 4,226 Reputation points Microsoft Employee2021-01-30T01:04:11.88+00:00 Can you please confirm type of SQL Server you are using and all other details with regards your architecture to take this forward.
Regards
Navtej S -
Chakraborty, Sarmistha 6 Reputation points
2021-01-30T17:57:04.177+00:00 I am using SQL server 2017 Azure IaaS servers. Trying to setup linked server connection between 2 sql servers (both SQL 2017 Azure IaaS) under the same subscription using the option: 'Be made using the login's current security context'. SQL services for both servers are running under MSA. Both linked server connections between 2 sql servers and ADSI are failing.
-
Navtej Singh Saini 4,226 Reputation points Microsoft Employee
2021-02-01T22:59:53+00:00 I have corrected the tags for this question so that you get the correct help.
Regards
Navtej S
Sign in to comment
Sign in to answer