Issue for selecting data from Azure SQL database by linked server - SQL Server 2016-2017

_{Thursday, May 3, 2018 8:49 AM}

Hi,

I'm working with SQL Server 2017 Developer Edition on my machine and an Azure SQL database (as a service).

I've created a SQL Server linked server on SQL Server instance on my machine in order to point to the Azure SQL service, specifying a remote account (login and password). I've tested the linked server connection successfully.

When I try to run a SELECT on a certain table of a certain database I've this error message:

Reference to database and/or server name in 'db_name.sys.sp_tables_info_90_rowset_64' is not supported in this version of SQL Server.

Any suggests to me to solve this issue, please? Thanks

_{Thursday, May 3, 2018 10:42 AM ✅Answered}

Hi,

your suggested article seems useful as this:

https://stackoverflow.com/questions/16403129/cannot-get-linked-servers-to-work-in-sql-azure

I've solved the issue, thanks.

_{Thursday, May 3, 2018 9:19 AM | 1 vote}

see if this helps

http://yasqlsb.blogspot.ae/2014/07/sql-azure-linked-servers.html

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh

My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page