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.Administration.SqlSessionStateResolver,
Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c’.
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.