Tuesday, January 27, 2009

Unable to connect to SQL Server session database. The connection string (server='', database='SharedServices1_DB') was returned by an...

1. On SQL Server 2005 Management Studio, below Security - Logins
locate the user that represents your 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 and you're set!

MASHINE - your mashine name

1 comment:

subhash reddy said...

THANK YOU VERY MUCH.IT SAVED MY TIME :)