COMMUNITY FORUM

hi,
 
There seemed to be number of similar questions on the forum, but I could not find clear answer.
In case if SQL Server and GP, eConnect libs and SmartConnect are installed on 2 different boxes (box A  – SQL Server, box B – GP, eConnect, SC) – what needs to be additionally installed on SQL Server in order for SC to be able to work in MS SQL Realtime data sources?
 
I have enabled CLR in SQL Server, but in order to register MS SQL realtime data sources with SC maps I must run this sql script in SQL Server as sa:
 
USE master
GO
CREATE ASYMMETRIC KEY SmartConnect_Realtime_Key from EXECUTABLE FILE = ‘C:\Program Files (x86)\eOne Solutions\SmartConnect\eOne.SmartConnect.MSSQLServerRealTime.dll’
GO
CREATE LOGIN SmartConnect_Realtime_Login FROM ASYMMETRIC KEY SmartConnect_Realtime_Key
GO
GRANT UNSAFE ASSEMBLY TO SmartConnect_Realtime_Login
GO
USE [CompanyDB]
GO
CREATE USER SmartConnect_Realtime_User FOR LOGIN SmartConnect_Realtime_Login
GO
CREATE ASSEMBLY [eOne.SmartConnect.MSSQLServerRealTime.dll] FROM ‘C:\Program Files (x86)\eOne Solutions\SmartConnect\eOne.SmartConnect.MSSQLServerRealTime.dll’
WITH PERMISSION_SET=UNSAFE
GO
 
However, the DLL eOne.SmartConnect.MSSQLServerRealTime.dll is not located on SQL Server box and hence the script fails.
 
What is the correct component(s) that must be installed on SQL Server machine in order for this to work?
 
 
Thanks!