I performed a Bigfix Server Migration last night, and it failed. A migration is basically a new install, but you copy key directories from the old server, and point to the old database during the install. I use a remote DB, and the Bigfix version being installed is 9.5.13.
I was worried during the install that things were not going correctly when I was prompted to change the SA password during the install. Then at the end, the following error appeared.
The database appears to be in an inconsistent state. Please contact your support representative.
Database Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission. (37000:15,151)
Is this error because of inadequate DB permissions?
I am using a service account to perform the install. The account has DBO permissions. I know the instructions say use ‘sa’ equivalent permissions. What exactly does that mean? It would be nice to have pictures in the instructions. Does it mean that the role has to be sysadmin, as well as, DBO?