Hi...
Never done this before, and Sage does not support this, has anyone changed a SQL sa password while Premium installed and running? I'm sure the database connection would disconnect, but it sounds like we would need to install the program again as the Premium install asks for the SQL password. I'm thinking the Crystal Reports wouldn't work either as that is using the SQL connection previous.
Has anyone ever done this? They're forcing me to change the password...
Thank you...
B
I found the utility in the Sage Programs and that lets you change the passwords. That is great. Thanks so much.
B
Hi B,
You should be working with your Reseller on this as they have the familiarity and expertise to answer these questions. That being said, when you install Sage 100 Premium it creates 2 users in SQL…
The "sa" password is used during the initial install to create the databases and SQL logins (MAS_Reports / MAS_User). After that, the only time you need the "sa" password is for updating these…
