September 24, 2014 at 12:01 pm
Is it possible to create 2 linked servers in 2 different domains that are not in the same forest? If it is, how can I do that?
Thanks to anyone
September 25, 2014 at 2:16 am
certainly using SQL Server auth, using Windows auth will require assistance from a domain administrator
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2014 at 7:53 am
Well that's what we tried but doesn't seem to work. One SQL Server is SQL 2012 and the other one is SQL 2008 R2. We configured the linked servers with SQL auth with SA login but it's not working. We are configuring the linked server with the other source (provider SQL Native Client 11), not SQL server option.
Here's the script: (don't bowther the remarks, it's in french)
USE [master]
GO
/***** supprimer référence aux travaux effectués sur Portail à partir du serveur local ***/
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'pub', @optvalue=N'false'
GO
/****** Object: LinkedServer [PORTAIL] Script Date: 2014-09-25 09:35:55 ******/
EXEC master.dbo.sp_dropserver @server=N'PORTAIL', @droplogins='droplogins'
GO
/****** Object: LinkedServer [PORTAIL] Script Date: 2014-09-25 09:35:55 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'PORTAIL', @srvproduct=N'Portail', @provider=N'SQLNCLI11', @datasrc=N'sql-portail4', @catalog=N'EDU_GROUP'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'PORTAIL',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='########'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'collation compatible', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'dist', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'pub', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'sub', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'PORTAIL', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply