• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

Creating sessionstate DB- -Some how Urgent

Dear Expert,
I have SQLServer 2008R2 and Server already has 3 sessiondb which are using for different site and now I need one more sessionDB in SQLServer2008R2.

Please  provide the Steps to create Session database.(Which server I need start Creating database).

Thanks in advance
Regards,
0
GK GK
Asked:
GK GK
  • 3
  • 2
2 Solutions
 
GK GKAuthor Commented:
Thanks for Update..... Expert... Aaron,

I Will create Database and  will verify with below link:
https://technet.microsoft.com/en-us/library/cc738919%28v=ws.10%29.aspx

I will change Connecting string in Application as well using

http://www.codeproject.com/Articles/104082/Configuring-ASP-session-state-on-SQL-server

Please provide me other inputs if any ?


Regards,
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
GK GKAuthor Commented:
Thanks GK,

It is working for us.

1.Created empty database and login in SQL Sever and provided Sysadmin to login  and ran the "Using custom database and SQL security" from " http://www.codeproject.com/Articles/104082/Configuring-ASP-session-state-on-SQL-server".

It working for me.

Thanks a lot.
0
 
GK GKAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for GK GK's comment #a40609368

for the following reason:

We are aware of how create Sessionstate database.
after the help from GK it is works for us.

Thanks Code project as well.
0
 
Aaron ShiloCommented:
it seems that my solution was used and i was thanked for it.

so i think i should get the credit for it.

Aaron
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now