How to find log in credentials for Sage 50 database

I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try they code. Any idea where I can find the credentials and/or reset them?

Specifically its the SDKInstanceManager.Instance.OpenDatabase() function where I run into the issue with username/password and looking through the c# example code.

Parents Reply Children
  • 0 in reply to krissyj05
    Sorry, I am not sure I can help further. I don't program in C# and don't use the SDK for the programming I do with Sage 50. The last things I can suggest you check are:

    1) Can the sample program open your database? If not, there may be something wrong with the userid and password you enter as you are running the sample file.

    2) Can you open the file in Sage 50 on that computer ok? Means the Connection Manager is running properly and not blocked by the firewall for example.

    3) Can your program open the file when Sage 50 is running? Means the program you are working on may not be accessing the Connection Manager properly or there may be a problem with the firewall.

    Otherwise, I don't know what else to help with but someone else may know. It might be worthwhile to post the error message so someone who uses the SDK can see what you see and may be able to provide some help.
  • 0 in reply to Richard S. Ridings
    I can open the company file no problem in Sage 50 and the username and password work with Sage 50 as well. It also doesnt return an error message. Also the connection manager shows that it is running.
  • 0 in reply to krissyj05
    Do you have your app set up as a single instance application?

    sagecity.na.sage.com/.../59532