Major problem today last day of the project and couldnt get group chat installed it was right to the wire…

all we were getting was Error 121 after the setup was ran for the group chat server and it invoked the configuration tool…

now we rechecked the database permissions , accounts, membership everything

reviewed various technet documentation and blogs and nothing at all!

anyway…. sql and kerberos turned out to be our problem and we exposed it with UAC in windows

basically when the installer was invoking the configuration tool it was doing under system and tried to authenticate to the sql server (as kerberos is in use) with the machine account and not the account we invoked the installer under!

very annoying! so the obvious thing was to add the machine account to sql 2008 but guess what you cant!…. well not directly! 🙂

to get around the problem we created a group, added the machine account to the group and then added it to the sql security and gave it SA permissions with DBO on the relevant database…

after this group chat installed with no errors……

Advertisements