14,494 questions
Linked Servers are not edition dependent. You can create a Linked Server between different versions and editions of SQL Server with no isues.
SQL Server Standard edition license support linked server feature?
![](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(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tan Wei Yean
116
Reputation points
- Does MSSQL server standard edition support server link feature?
- I need to create a server link between 2 database server in the cloud.
- if one server is on enterprise edition and another is on standard edition, can the server link be created.
SQL Server Other
{count} votes
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-02-03T06:46:15.53+00:00 Hi @Tan Wei Yean ,
Did the reply could help you? If the response helped, do "Accept Answer". If not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
Accepted answer
2 additional answers
Sort by: Most helpful
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2021-02-02T07:32:04.757+00:00 Hi @Tan Wei Yean ,
> Does MSSQL server standard edition support server link feature?
Yes, it is supported. You can create linked servers in all the editions, but linked server is not supported by SQL Server Compact Edition. Refer to this similar thread.
> if one server is on enterprise edition and another is on standard edition, can the server link be created.
Yes, it can be created.
If the response is helpful, please click "Accept Answer", thank you.
-
![](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(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com 4,316 Reputation points2021-02-02T11:25:10.257+00:00 Regarding Q2, we would need more info exactly how your database is in the cloud.
If it is Iaas (a VM), then it work just as a regular SQL Server.
If it is PaaS (some managed solution) then your options are likely limited since stuff are abstracted away from you (the OS and possibly the instance). For instance Azure's SQL Database and Managed Instances do not support linked servers. OTOH, they don't have editions either so I doubt that you refer to them.