Solved

Creating sessionstate DB- -Some how Urgent

Posted on 2015-02-03
9
47 Views
Last Modified: 2015-02-18
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
Comment
Question by:GK GK
  • 3
  • 2
9 Comments
 
LVL 26

Expert Comment

by:Zberteoc
ID: 40589361
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 200 total points
ID: 40589421
0
 

Author Comment

by:GK GK
ID: 40590277
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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Accepted Solution

by:
GK GK earned 0 total points
ID: 40609368
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
 

Author Comment

by:GK GK
ID: 40611474
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
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 40610528
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
The viewer will learn how to count occurrences of each item in an array.
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question