Linked Server to SQL Azure Database

Error:

OLE DB provider “SQLNCLI11” for linked server “xxxxx” returned message “Unspecified error”.
Msg 40515, Level 16, State 2, Line 1
Reference to database and/or server name in ‘xxxxx.sys.sp_tables_info_90_rowset_64’ is not supported in this version of SQL Server.

Fix:

Create linked server to SQL Azure Database using script.

EXEC master.dbo.sp_addlinkedserver @server = N'MYDB1', @srvproduct=N'', @provider=N'sqlncli', @datasrc=N'mydb01.database.windows.net', @catalog=N'database01' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'MYDB1',@useself=N'False',@locallogin=NULL,@rmtuser=N'user01',@rmtpassword='password01'

Sources:

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