Solved

Creating sessionstate DB- -Some how Urgent

Posted on 2015-02-03
9
40 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Read about why website design really matters in today's demanding market.
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now