Is there an alternative to using SA account when configuring the Safe X3 management console

Question

I am working with a new customer whose internal security policies will not allow the entry of the SQL SA password into the console. Is there an alternative to using the SA account? This will be a version 7 product update 9 install.

Elaine Pigott · Accepted Answer

We were not able to use an account other than SA. The client's SQL team changed the SA account password to a temporary value which they provided to us for the duration of the configuration then changed it back. X3 transactions function fine. When you need to create a folder the SA password has to be changed back to the same temporary value. The copy of users from one folder to another does not work you have to create the users in each folder. There may be other admin type functions that have issues but we have not run into them for this client.

Delamater · Answer

Hi Elaine, 
 
You can create an account equivalent to the SA and use that instead if you like. 
 
Sage has never published a minimum set of permissions required for SQL Server to complete an installation that I've seen, so that will be out of reach if that is your next question. Some of the things we do execute during the console database set up include database creation, alter database commands, bulk copy (BCP) and other things like that. You can see the scripts inside the installation folders that the console uses, just search for *.sql. Sage Support will only support the officially documented approach. If you really must avoid the sa account, you can go through all the activities in the console with SQL profiler turned on and distill all the commands and reason out the best SQL Server role to provide it, which is a lot of work by the way. 
 
Another approach could be to use an equivalent account to the SA, configure X3 with the console, then disable that account inside SQL Server until you are ready to make another configuration within the console, at which point you re-enable the quasi SA account. 
 
Hope this helps. 
Bob

Sage X3

Is there an alternative to using SA account when configuring the Safe X3 management console

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING