Hi friends,
i Need some small help on azure sql.
I am trying to create the linked server which is used to pull the data from AZURE SQL.
i have used the below query to created the linked server..
but it is throwing in the error.
shall you please any one let me know who to create a linked server.
---
i want to know what are all the setting we have to change in the SYSTEM DNS to access the AZURE SQL db
EXEC master.dbo.sp_addlinkedserver @server = N'Azure_ODBC1', @srvproduct=N'Any', @provider=N'MSDASQL',---'MSDASQL', @datasrc=N'myazuredb' --,@catalog='myDatabase' GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'Azure_ODBC1' ,@useself=N'False' ,@locallogin=NULL ,@rmtuser=N'MyAzuredb' ,@rmtpassword='4'