title: SQL Server session in CLUSTER
body: <p>Can anyone help me with this ...</p>
  
  <p>I have a 3 node sql server cluster lets say N1, N2 and N3. The name for the three node cluster is SQLCLUS.
  The application connects to database using the name SQLCLUS in connections strings name.</p>
  
  <p>The application uses SQL Server session manangement. So I remote desktopped to N1 (which is active while N2 and N3 are passive)  and from the locaiton </p>
  
  <p>C:\Windows\Microsoft.NET\Framework64\v2.0.50727</p>
  
  <p>I executed the following command</p>
  
  <p>aspnet_regsql.exe -S SQLCLUS -E -ssadd -sstype p</p>
  
  <p>The command executed successfully. I could then login into SQLCLUS and see ASpState database created with 2 tables.</p>
  
  <p>I then tested the applciation which uses the SQL Server session and it also works fine.</p>
  
  <p>Now my question is ...</p>
  
  <ol>
  <li><p>If there is a fail over to node N2 or N3 will my application still work ?. I did not execute the above command (aspnet_regsql.exe ) from N2.</p></li>
  <li><p>Should I execute the command , aspnet_regsql.exe -S SQLCLUS -E -ssadd -sstype p , in N2 and N3 too ?</p></li>
  <li><p>What changes happens in a sql server after executing the above command ?. I mean , is there any kind of service ot settings changes that can be seen ?.</p></li>
  </ol>
  
  <p>Greatly apprecite any in puts regarding this....</p>
  
  <p>Thanks in advance...</p>
  
  <ol>
  3. 
  </ol>