Missing from this procedure is one additional required step. You will need to create a SQL Login machine account (DOMAINMACHINENAME$) on the new back-end database server, and a Database User account in the SUSDB database that is assigned to the webService database role.

See original here: Create SQLLogin and Database user in SQL Server for front-end server

Link to this post!