Accpac CRM installation error

Posted on 2009-04-17
Last Modified: 2012-05-06
Hi all,

I am getting error "There was a problem running osql please check that the program location is in the system path" while installing sage accpac crm.

Version of Sage Accpac Erp : 5.5
Version of sage Accpac CRM: 6.1

Please Help.


Question by:kavinagpur
    LVL 11

    Expert Comment

    OSQL.exe is a command line utility for submitting statements and scripts to SQL Server. Sounds like the path where OSQL.exe is installed is not part of the system path and the AccPac installer does not fully-qualify the path.

    The usual location of OSQL.exe is in the ...\nn\Tools\Binn folder where SQL Server is installed, where nn is the version number, for example 80 or 90.

    Author Comment

    OSQL.exe is in C:\Program Files\Microsoft SQL Server\90\Tools\Binn

    Please help
    LVL 11

    Accepted Solution

    Now that you know the correct path it must be added to the system search paths so when AccPac tries to execute "OSQL.EXE" without a path specified, the operating system will search the system paths.

    In the System Properties dialog on your server, on the Advanced tab, you will see a button named Environment Variables.  From there, find a setting named Path and you'll see a semicolon delimited list of file paths: add the SQL Binn path to the list.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now