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.


[D](T0056) How do I change my sa password?

Would you like to...

Print this page
Email this to a friend

ServiceLedger provides a default sa password of sldemosl.  It is suggested that if your server is connected directly to the internet without a firewall, or if you have ports forwarded to your server that you alter the password.  You should choose a secure password.  Serviceledger advises that:

  • You do not use any word by itself that appears in the dictionary
  • You mix upper and lower case
  • You do not use spaces or control characters
  • You mix letters and numbers

Once you have selected your password:

  • Log into your server as the Administrator
  • Go to Start->Run and type OSQL -E (case matters, so type it exactly)
  • When you receive the 1> prompt type sp_password 'sldemosl', 'newpassword', 'sa' (they are all single quotes) and press enter
  • When you receive the 2> prompt type go and press enter
  • You will receive a message stating that the password was changed
  • Now for each workstation that connects to this server you must update HKLM\Software\ServiceLedger\ServiceLedger\3.0\DBPassword to the new value.  That process is covered at: http://support.serviceledger.com/kb/Default.asp?ToDo=view&questId=36&catId=5

Related Questions:

Attachments:

No attachments were found.


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