Azure VM with SQL Server linked server connection to AWS RDS Oracle database

K M 1

We'll have a Azure VM with SQL Server 2022 (not managed instance) and we would like to create a linked server connection to Amazon (AWS) RDS Oracle database. If this is possible, please provide detail steps. Thanks

ShaktiSingh-MSFT 15,301 Reputation points

2023-11-08T10:08:54.22+00:00

Hi K M •,

Welcome to Microsoft Q&A forum.

Please refer to this documentation https://aws.amazon.com/blogs/database/create-a-heterogeneous-linked-server-from-amazon-rds-for-sql-server-to-an-oracle-database/.

Also, do let us know more on the requirement so that we can help you with options of connection.

For instance, do you have an Azure SQL Database, do you want data to be copied from Source to Target, other relevant requirement if any?

Thanks
K M 1 Reputation point

2023-11-08T22:38:06.2533333+00:00

No this is incorrect. Your link is for AWS RDS SQL server Linked server. My question requirement is how to create linked server FROM Azure VM with SQL Server TO AWS RDS Oracle. Please help
ShaktiSingh-MSFT 15,301 Reputation points

2023-11-10T06:44:19.7233333+00:00

Hi K M •,

I am checking with the internal team about the possibility. Will get back here once I get a reply.

Thanks
ShaktiSingh-MSFT 15,301 Reputation points

2023-11-13T05:22:49.7433333+00:00

Hi K M •,

I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks
K M 1 Reputation point

2023-11-13T10:56:21.5266667+00:00

Hi, we can raise MS ticket but is it possible to do linked server per my requirement?
ShaktiSingh-MSFT 15,301 Reputation points

2023-11-14T04:31:44.7166667+00:00

Hi K M •,

The following documentation may be of help:

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/linked-servers/set-up-troubleshoot-linked-server

You might try contacting the support case to get more up to date information. Thank you.

3 answers

Vinodh247 20,141 Reputation points

2023-11-08T07:28:42.4433333+00:00

Hi K M,

Thanks for reaching out to Microsoft Q&A.

If you say you have azure VM with SQL 2022 that would be a managed instance. Pls confirm if yours is Azure SQL database, or a database hosted under managed instance.

If it is azure sql database then you won't be having linked server option, you can use pipelines from azure data factory after creating a linked service inside it.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.
Please sign in to rate this answer.
Jordan Hays 85 Reputation points Microsoft Employee

2023-11-10T19:48:56.58+00:00

Hi @Vinodh247 ,

If you say you have azure VM with SQL 2022 that would be a managed instance. Pls confirm if yours is Azure SQL database, or a database hosted under managed instance.

This is incorrect. Azure SQL Managed instance is a separate offering from SQL Server on Azure VM.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
K M 1 Reputation point

2023-11-08T08:07:07.67+00:00

I will have SQL Server on Azure Virtual Machine as mentioned in my question post. Can I know how to create linked server to AWS RDS Oracle database. See this https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql
Please sign in to rate this answer.
Vinodh247 20,141 Reputation points

2023-11-08T09:48:06.04+00:00

what error do you get when you try the below to create linked server

EXEC master.dbo.sp_addlinkedserver @server = N'LinkServerName', @provider = N'SQLNCLI', @srvproduct = 'MS SQL Server', @provstr = N'SERVER=serverName\InstanceName;User ID=myUser'
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
K M 1 Reputation point

2023-11-08T21:25:01.4366667+00:00

Can someone please understand my requirement in initial question and provide steps accordingly please
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure VM with SQL Server linked server connection to AWS RDS Oracle database

3 answers

Your answer