Skip to content
+1-888-319-3663

COMMUNITY FORUM

MSSQL Realtime Datasource registration – GP and SQL Server are on different boxes

Eugene asked 3 years ago
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!
 
Eugene replied 3 years ago

I really wish this would be covered in documentation!

Answers
Lorren Zemke answered 3 years ago
Eugene,
Install just the SmartConnect User Interface on the SQL server to get the correct DLL’s on that machine. You don’t have to use the application on that machine.
Eugene replied 3 years ago

Thank you! I have actually just copied DLLs without full product install and it worked!

Jeremy replied 3 years ago

Lorren,

Can you advise on where we can find the SmartConnect User Interface for our SQL Server?


If you would like to submit an answer or comment, please sign in to the eOne portal.