Versions Compared

Version Old Version 6 New Version 7
Changes made by

Rakesh

Rakesh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To create an extended stored procedure to call the NLINK Server (running on the same machine as SQL Server or different machine). With NLINK Server version

4.2.0.116

5.x or later use the sp_NLINK.sql script which is available from Junot Systems.

With older version of the NLINK Server, see the corresponding documentation for the NLINK SQL eXtender.

 

  

DCOM Settings to Prevent auto-start of NLINK Server          

When SQL Trigger calls the NLINK Server and the NLINK Server is not in a running state, by default, the operating system tries to start the NLINK Server. This can cause problems. Auto-starting of the NLINK Server can be prevented using the following steps:

  1. Run “dcomcnfg” from the command line.
  2. Navigate to “Component Services->Computers->My Computer->DCOM Config->NLINK”
  3. Open the Properties window for the NLINK application.
  4. Select the “Security” tab.
  5. In the “Launch and Activation Permissions” section, choose “Customize” and click the “Edit…” button.
  6. For “Group or user names” listed, in permissions window, uncheck “Allow” and “Deny” for “Local Launch” and “Remote Launch”.

Now NLINK can only be started from the Service Control Manager (SCM) or the NLINK Management Module (NMM).

  

...