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.