linked server use to connect to azure sql database(cloud)

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'
August 30th, 2015 7:21am

Duplicate thread.

linked server to connect to azure sql database

Free Windows Admin Tool Kit Click here and download it now
August 30th, 2015 7:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics