title: asp.net session state mode "SQLServer"
body: <p>"My website is LIVE. And this problem is related to configure session timeout on LIVE server and not in localhost."</p>
  
  <p>I have a problem with session expiring too soon. link in 2-5 minutes only. I tried lot of things and at last decided to store the session in "SQL Server" mode</p>
  
  <p>in my web.config file i have following coding:</p>
  
  <pre><code>&lt;sessionState mode="SQLServer" cookieless="false" timeout="45"
  sqlConnectionString="data source=xxx.xx.xx.xxx;uid=xxxxxxx;pwd=xxxxxxxx"/&gt;
  </code></pre>
  
  <p>and i have all the tables required in ASPState table on server. You can see it from the image below.</p>
  
  <p><img src="https://i.stack.imgur.com/j04dr.png" alt="enter image description here"></p>
  
  <p>But i when i run my application, its throws the below error:</p>
  
  <p>"Unable to use SQL Server because either ASP.NET version 2.0 Session State is not installed on the SQL server, or ASP.NET does not have permission to run the dbo.TempGetVersion stored procedure. If the ASP.NET Session State schema has not been installed, please install ASP.NET Session State SQL Server version 2.0 or above. If the schema has been installed, please grant execute permission on the dbo.TempGetVersion stored procedure to either the ASP.NET application pool identity, or the Sql Server user specified in the sqlConnectionString attribute."</p>
  
  <p>Image of the error:</p>
  
  <p><img src="https://i.stack.imgur.com/rlL5o.png" alt="enter image description here"></p>
  
  <p>I am not able to understand the exact problem and how i can solve it. Any help will be appreciated.</p>
  
  <p>Thank You</p>