AZR-SQL101 Linkend server from regular MS-SQL server to AZURE

USE [master]
GO

EXEC master.dbo.sp_addlinkedserver
@server = N'<<Friendly Name>>'
, @srvproduct=N''
, @provider=N'sqlncli'
, @datasrc=N'<<AzureSqlServerName>>.DATABASE.WINDOWS.NET'
, @catalog=N'<<databasename>>'

EXEC master.dbo.sp_addlinkedsrvlogin
  @rmtsrvname=N'AZR_RSZK_STG'
, @useself=N'False'
, @locallogin=NULL
, @rmtuser=N'<<LocalAccount>>'
, @rmtpassword='<<VeryStrongPassword>>'

Till Next Time

Reacties

Een reactie posten

Populaire posts van deze blog

AZR-SQL101 Create External Data Sources

DROP EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>]; CREATE EXTERNAL DATA SOURCE [<<ExternalDatasourceName>>] WITH ( TYPE=RDBMS, LOCATION='<<SQL-ServerName>>.database.windows.net', DATABASE_NAME='<<DatabaseName>>', CREDENTIAL=  <<CrendentialName>> ); Till Next Time
Meer lezen

AZR-SQL101 Create Master Key

-- Drop master key IF EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') DROP MASTER KEY; -- Create master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<<ReallyStrongPassword>>'; GO Till Next Time
Meer lezen