Solved

Creating sessionstate DB- -Some how Urgent

Posted on 2015-02-03
9
44 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

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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

It’s a strangely common occurrence that when you send someone their login details for a system, they can’t get in. This article will help you understand why it happens, and what you can do about it.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

773 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