Solved

Creating sessionstate DB- -Some how Urgent

Posted on 2015-02-03
9
52 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
9 Comments
 
LVL 27

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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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

Report: Liquid Web beats Amazon, Rackspace & More

A study by performance analyst firm Cloud Spectator finds that Liquid Web beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance.

Question has a verified solution.

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

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Viewers will learn how the fundamental information of how to create a table.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

739 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