Sage 100

 View Only

  • 1.  Linked Server setup

    Posted 03-21-2019 12:38
    I have been working with Jim Woodhead on re-setting up linked servers (path to Sage has changed). He gave me directions to create the linked servers, but it is not working, and he is unavailable until this afternoon, and the customer is down until I get this corrected.

    The old linked servers are still connecting, but to the old Sage install.

    The new one I setup gives the following error:



    Can anyone help me troubleshoot this?

    Sorry for the urgent plea, TIA

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: Linked Server setup

    Posted 03-21-2019 12:47
    If you are in SQL Server Mgt Server (SSMS), Go to Server Objects -> Linked Servers
    Find the old linked server
    Right - Click on it
    Select: Script Linked Server As -> Create To -> New Query Editor Window

    In the Query Editor window you will see the paths to the old server.  You can change those here.  Then, rename all the references to your Linked server, (Ctrl-H for find and replace), so that you have new LinkedServer name for the new version.  

    Check the syntax
    Execute the code
    Refreshed the Linked Servers
    Right-click on your new linked server and Test Connection


    ------------------------------
    Chris St. Amand
    Arizona Accounting & Information Systems
    ------------------------------



  • 3.  RE: Linked Server setup

    Posted 03-21-2019 12:48
    Edited by Kevin Moyes 03-21-2019 12:49
    64-bit SQL requires a silent 64-bit DSN.  I copy / paste the provider string from the DSN, but understand it might be OK to leave that blank in your Linked Server...

    Setting Up Linked Server Between SQL Server 2008 R2 and MAS90 Database
    MSSQL Nuggets "Kitchen of a SQL DBA" remove preview
    Setting Up Linked Server Between SQL Server 2008 R2 and MAS90 Database
    In this post, I would like to discuss how to setup a linked server between SQL Server 2008 R2 and MAS90 server database. The first step before setting up the linked server is to install the MAS90 driver and then configure the system DSN. Below are the screenshots that will guide a user to setup/configure...
    View this on MSSQL Nuggets "Kitchen of a SQL DBA" >


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Linked Server setup

    Posted 03-21-2019 12:49
    Does this help https://blog.sqlauthority.com/2016/06/11/sql-server-fix-linked-server-error-7399-invalid-authorization-specification/

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 5.  RE: Linked Server setup

    Posted 03-21-2019 13:15
    Awesome @Chris St. Amand that worked. Thanks so much!​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 6.  RE: Linked Server setup

    Posted 03-21-2019 13:07
    Another possible issue is the location of your Mas90 folder relative to your SQL Server instance.  If the old version of Sage was located on the same Server as SQL Server, but the new version of Sage is not, you will likely run into a double-hop issue.  If that's the case, I would suggest you discuss with Jim.

    ------------------------------
    Chris St. Amand
    Arizona Accounting & Information Systems
    ------------------------------



  • 7.  RE: Linked Server setup

    Posted 03-21-2019 20:56
    Thanks everyone, all good information! Appreciate the education.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


Related Content