Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 9th, 2007, 02:51 PM
Authorized User
 
Join Date: Feb 2007
Location: Binghamton, NY, USA.
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to toddw607 Send a message via Yahoo to toddw607
Default Using Session State with SQL Server Express 2005

I am transferring the Database from SQL Server 2005 to a client laptop with SQL Server 2005 express. Session States are a large part of the program. If I am using a database called upsizedCandidate on the local server of the laptop called LT091, how can I enable the session state on the local machine?

Reply With Quote
  #2 (permalink)  
Old December 18th, 2007, 05:12 PM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you didn't get the answer already, you can refer to the following:

General sql server session state setup info: http://msdn2.microsoft.com/en-us/library/ms229862(VS.80).aspx

Specific thing you need to do if setting it up for SQL Server Express:
http://msdn2.microsoft.com/en-us/library/ms178586(VS.80).aspx



The pertinent information about SQL Server Express from the second link above is (note where it says "By default, you...":

Installing the Session State Database Using the Aspnet_regsql.exe Tool

To install the session state database on SQL Server, run the Aspnet_regsql.exe tool located in the systemroot\Microsoft.NET\Framework\versionNumber folder on your Web server. Supply the following information with the command:

    *

      The name of the SQL Server instance, using the -S option.
    *

      The logon credentials for an account that has permission to create a database on SQL Server. Use the -E option to use the currently logged-on user, or use the -U option to specify a user ID along with the -P option to specify a password.
    *

      The -ssadd command-line option to add the session state database.

      By default, you cannot use the Aspnet_regsql.exe tool to install the session state database on SQL Server Express Edition. In order to run the Aspnet_regsql.exe tool to install a SQL Server Express Edition database, you must first enable the Agent XPs SQL Server option using T-SQL commands like the following:

      EXECUTE sp_configure 'show advanced options', 1
      RECONFIGURE WITH OVERRIDE
      GO

      EXECUTE sp_configure 'Agent XPs', 1
      RECONFIGURE WITH OVERRIDE
      GO

      EXECUTE sp_configure 'show advanced options', 0
      RECONFIGURE WITH OVERRIDE
      GO

      You must run these T-SQL commands for any instance of SQL Server Express Edition where the Agent XPs option is disabled.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remoting and SQL Server 2005 Express Bob Bedell C# 2005 15 January 3rd, 2008 12:52 AM
SQL Server session state latency planoie ASP.NET 2.0 Professional 4 July 18th, 2007 09:47 AM
SQL SERVER 2005 STANDARD (not express) proslambano BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 8 January 8th, 2007 07:55 PM
SQL Server 2005 Express Problem asped_man BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 3 November 29th, 2005 04:07 AM



All times are GMT -4. The time now is 08:20 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.