SQL Server Setup was unable add user user@domain.com to local group - while installing SP in SQL 2005

SQL 2005 Service pack setup may fail with the below message:

MSI (s) (48!C0) [15:00:19:089]: Note: 1: 2262 2: Error 3: -2147287038

MSI (s) (48!C0) [15:00:19:089]: Product: Microsoft SQL Server 2005 -- Error 29512. SQL Server Setup was unable add user sqlserver_service@domain.com to local group Domain\SqlServer_service.

While installing Service pack – if you get the above message –

1. Check the service account for the SQL, SQL Agent, FT accounts – you can see the service account would be in a sqlserver_service@domain.com format

2. We need to change that to domain\sqlserver_service format

This will help resolve the issue.