Changing SQL SA password on Unity Server

[robertdaniel]

Hi - My group is preparing to upgrade Unity to 4.0(4) at one of our locations. The intial install & config was done by a vendor and none of the guys at that site know what the sa password was set to.

Would there be any ill effects, or considerations, from changing the password prior to the upgrade so that we can complete that step during the process?

Thanks

[lindborg]

We recommend that you install the system such that NT authorization/security is used, not hard coded SA password access (which is not as secure - this is the same recommendation MS gives). The account associated with the local Unity services (in particular AvCsMgr) should be a member of the local admins group (or the builtin group if it's a DC) and that group will, by default, have RW access to the UnityDB and ReportDB databases in SQL.

Assuming the folks followed these instructions for their Unity install then you shouldn't have to worry about this.