Creating Web Application for Web Farm

[karthi84]

Hi,
I was asked to create a web application which is going to be running on a web farm. Now my questions are
1. I was asked to use windows authentication for connecting to SQL database, will this work when i am running my application in a web farm?
2. What are the settings i should make to make my application work fine in a web farm environment?
3. I have planned to use a SQL persistant state for sessions, is this the best one or is there any other for web farm environment.
4. What are the other things that i should consider while deploying my application in a web farm.

Thanks & Regards
Karthikeyan

[Frinavale]

Seems like you already know what needs to be done :)

I'm not sure how the Windows Authentication will work in your web farm environment. It's probably best you look into how this will work in an web farm environment.

You've already addressed the main problem I can see when running an ASP.NET application in a web farm environment: make sure that, if you're using session, it is configured so that it can span across the multiple web servers.

There are a couple of options that you can use.
Check out this article on Sessions for a bit more information.

Cheers!

-Frinny

[karthi84]

Hi Frinny,
Thanks for the reply. But the link you have given for the sessions article is no longer available. can you update me on this

[ThatThatGuy]

windows authentications won't do....

is you're using sql 2005 or later then a user name or passowrd is a must

[Frinavale]

I don't know why the link is no longer working.
The article can be found in the .NET articles section....and it still exists.
Here's a new link to the article on Sessions.

-Frinny

[karthi84]

Hi Frinavale,
Thank you for the updated link

[karthi84]

Hi ThatThatGuy,
Thanks for the reply. now my question is if i want to use windows authentication to connect my sql 2005 database which is on a different server (not in the application server) what are the settings i have to make on both the servers. as my client is more specific on the application to be on a web farm and the database connections are to be made with windows auth.