2

After adding SQL Server private sessions storage I get this error:

Synonym 'Applications' refers to an invalid object

Here is the relevant web.config section:

<sessionState mode="Custom" customProvider="mssql" cookieless="false" timeout="20">
    <providers>
        <add name="mssql" type=" Sitecore.SessionProvider.Sql.SqlSessionStateProvider, Sitecore.SessionProvider.Sql" connectionStringName="session" pollingInterval="2" compression="true" sessionType="private" />
    </providers>
</sessionState>

UPDATE

After changing to using SQL Session as per Sitecore's Instructions, I received the error. The only difference between the site working and not working was the above config change. As soon as I made the change and loaded the site, I got the YSOD with the error.

Improve this question
3
  • can you try to restart sql server and run boost sql script again?
    – Vlad Iobagiu
    Sep 20, 2017 at 19:23
  • can you check if tempDB is created on sql server
    – Vlad Iobagiu
    Sep 20, 2017 at 19:24
  • Ethan, take a look at this post I wrote, it includes some info on testing tempdb and the setup steps: flux-digital.com/blog/…
    – Adam Seabridge
    Sep 20, 2017 at 21:15

1 Answer 1

Reset to default
1

This came down to permissions. I could not find anything about this in the Sitecore Installation Guide, but my SQL login needed access to the tempdb in order to run the session boost scripts or use the session dbs.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.