---
title: "How do I setup web farm session state to use SQL Server?"  
description: "How do I setup web farm session state to use SQL Server?"  
author: "Amit Singh"  
published: 2010-12-11  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/286/how-do-i-setup-web-farm-session-state-to-use-sql-server  
category: "asp.net"  
tags: ["asp.net"]  
reading_time: 1 minute  

---

# How do I setup web farm session state to use SQL Server?

Run the ASP.NET Session State SQL Script to create the appropriate tables within a SQL Server database. Then modify your application's web.config file to point to this database. ASP.NET will then, under the covers, handle serializing your state from the Session intrinsic to/from the database.\

## Answers

### Answer by Amit Singh

Run the ASP.NET Session State SQL Script to create the appropriate tables within a SQL Server database. Then modify your application's web.config file to point to this database. ASP.NET will then, under the covers, handle serializing your state from the Session intrinsic to/from the database.\


---

Original Source: https://www.mindstick.com/interview/286/how-do-i-setup-web-farm-session-state-to-use-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.