By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.


(T0218) Using SLDBConf.exe to Configure ODBC

Would you like to...

Print this page
Email this to a friend

If you move your database to another server, or inadvertently perform a full install on a workstation, you can use SLDBConf.exe to point the workstation to another location.

For 32-bit machines, use the following path:

  • C:\Program Files\ServiceLedger\ServiceLedger\SLDBCONF.exe

For 64-bit machines, use the following path:

  • C:\Program Files (x86)\ServiceLedger\ServiceLedger\SLDBCONF.exe

Important: You may need to run SLDBConf.exe with Administrative privileges (right-click on the file and select "Run as Administrator")

Unless you have a non-default ServiceLedger configuration, you should only need to perform the following two steps:

  1. Enter in Host Name or IP Address of the ServiceLedger Server
  2. Click either OK or Save & Close, depending on your version of ServiceLedger
  3. If you get an error message, such as "Failed to set data for ServiceLedgerSQL", verify that you have run SLDBConf.exe with Administrator privileges

If the program closes without error, you have successfully configured your workstation to point to the ServiceLedger server


For non-default installations:

If you are using a non-default installation, you may need to configure additional parameters. Press <Alt><F8> to enable changes to those fields. Important: You should not make any changes to these fields unless directed to do so by your Network Administrator!

  • Server: This is usually the only field required. Specify the computer / machine / network name, as seen in Control Panel > System of the ServiceLedger server.
  • Instance: You should generally not need to modify this field. The default instance is SERVICELEDGER.
  • DB: You should generally not need to modify this field. The default DB name is ServiceLedger.
  • NT Authentication: You should generally leave this box unchecked unless instructed to do so by your network administrator.
  • User: The default user is sa.
  • Password: The default password is either s1d#m0*1S1Sl or sldemosl.
  • Network Library: You should generally not modify this field unless instructed to do so by your network administrator.
  • Once the settings are correct, press (depending on your version of ServiceLedger) either OK or Save & Close.

    Note: Versions of this file prior to 2009 have a 3 state "NT Authentication" box.  There is checked, unchecked, and gray checked.  A gray check is the same as unchecked, so if you wish to use NT authentication, ensure it is checked and is not gray.


Related Questions:

Attachments:

No attachments were found.


ServiceLedger KnowledgeBase Copyright © 2019 support.serviceledger.com
Powered by AcitveKB Knowledgebase Software