Unable to connect to SQL Server session database. The connection string
(server=”, database=’SharedServices1_DB’) was returned by an
instance of the IPartitionResolver type
Microsoft.Office.Server, Version=, Culture=neutral,

1. On my SQL Server 2005 Management Studio,
2. Goto Security –> Logins –> you can find the user that represents web server, DOMAIN\MACHINE$.
2. Right-click the DOMAIN\MACHINE$, choose User Mapping.
3. Map the SharedServices1_DB. check the roles db_owner and public.
4. Click OK.

This would be better solution to resolve the issue.