I am setting up an environment with the databases stored on Amazon RDS. I am running into a problem with using SQL Session State. I get the YSOD with this error:
Parser Error Message: Synonym 'Applications' refers to an invalid object. Source Error: Line 354: <sessionState mode="Custom" customProvider="mssql" cookieless="false" timeout="20"> Line 355: <providers> Line 356: <add name="mssql" type=" Sitecore.SessionProvider.Sql.SqlSessionStateProvider, Sitecore.SessionProvider.Sql" connectionStringName="session" pollingInterval="2" compression="true" sessionType="private" /> Line 357: </providers> Line 358: </sessionState>
Which I have seen before. I have solved this by re-running the sql boost scripts on the session database. BUT, on RDS, I dont seem to be able to run this script. Even as the SA I dont have permission to alter Synonyms or add SPROCs. Has anyone else run into this and come up with a workaround?