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
  • 0
    Have you altered the security in Sage 50 for the user sysadmin to allow access to the database from third-party programs?

    Both userid and password are case-sensitive and passwords cannot be longer than 7 characters, so if you think you have used sysadmin as the sysadmin password, you should use sysadmi.
  • 0 in reply to Richard S. Ridings
    I have modified the sysadmin user and changed the password to a 7 character password, I also made sure the rigths with third-party products is set to read/write access but I still can't seem to get passed that opendatabase function in the code.
  • 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.
Reply
  • 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.
Children