Problem In Configuring ASPState DB For .NET 2.0

May 16, 2007

Hi,

In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.

Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error

Exception: System.Web.HttpException
Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.



Appreciate your help.



Thanks,

Siva



PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.



Result Log:


Run 'aspnet_regsql.exe -?' for details.
--------------------------------------------------

---------------------------------------------------
Completed execution of UninstallPersistSqlState.SQL
---------------------------------------------------


------------------------------------------------
Starting execution of InstallPersistSqlState.SQL
------------------------------------------------

--------------------------------------------------
Note:
This file is included for backward compatibility
only. You should use aspnet_regsql.exe to install
and uninstall SQL session state.

Run 'aspnet_regsql.exe -?' for details.
--------------------------------------------------
The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'.
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.

(1 row(s) affected)

Type added.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @name ('[Uncategorized (Local)]') already exists.

-------------------------------------------------
Completed execution of InstallPersistSqlState.SQL
-------------------------------------------------

View 3 Replies


ADVERTISEMENT

ASPState DB Permissions

Apr 12, 2007

I need to find out what the 'Required' permissions on on the ASPState database? We have been granting dbo to the login. Thanks.

View 4 Replies View Related

Mirroring ASPState

Nov 6, 2006

Hello Does any one have any information on how to mirror the ASP.NET 2 ASPState database we have set the connection string to allow custom DB and failover partner but this is still not working.



Regards Matt.

View 3 Replies View Related

ASPState And Windows Vista

Jul 18, 2007

There is no ASPNET account on Windows Vista. Wich account do I need to use on ASPState database ?



Thanks

View 1 Replies View Related

ASPState Select Permission Denied

Nov 19, 2006

I've been scouring the 'Net and I'm surprised to not find any info on this. Apparently I've screwed up something that nobody else has managed to screw up.

Using Win03EE and SQL2005.

I created the ASPState database using "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Aspnet_regsql.exe" using "-sstype p" to put the data in ASPState instead of tempdb.

During the creation I used an admin SQL login (let's call it "MyAdmin") that has full admin permissions. (MyAdmin is a SQL login, not a domain account.) I then created an "ASPState" SQL login (not domain) and gave it full permissions within the ASPState database.

I should probably note that the Win03EE server is also a domain controller even though the SQL logins I'm using are non-domain. This is because, currently, the development workstations are not part of the server's domain. Since the entire environment is strictly for research and development, optimum security is not the first concern at this point.

When I run the ASP.NET 2.0 web application with the connection string set to use the MyAdmin account, everything works fine. I can even poke around in ASPState with SSMS and see the session entries being inserted in the tables.

When I run the application with the connection string set to use the "ASPState" login, I get "SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'".

If I give ASPState sysadmin priviledges, it works. Of course, I don't want to give ASPState sysadmin priviledges.

I have seen non-ASPState issues posted on the 'Net involving permission denied and mssqlsystemresource. From those I've come to understand that this likely has to do with the changes made to SQL2005 that are probably not anticipated by the current version of aspnet_reqsql.

So... can anyone help me save what's left of my hair from being pulled out any further? I've been clicking various permission settings on and off all day long with no results. The lack of correlation between mssqlsystemresource and what permission setting is needed where is pretty frustrating.

In addition to the solution to this problem, I'd really appreciate any info anyone has on a great place to go read about security setting adjustment considerations in light of the changes made in SQL2005. In particular, what changes from SQL2000 to SQL2005 impact the operation of existing SQL2000 code and what an admin should know about adjusting security settings.

Thanks!

View 1 Replies View Related

Cannot Open Database Requested In Login 'ASPState'

Jan 6, 2006

I am getting the following error and cannot figure out why it does not work.
I know the USER is has access to the SQL Server Database and I have tried turning on
<identity impersonate="true" />
 
Nothing works.  Any help would be great.
Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'DOMAINXXXBATWOW'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'DOMAINXXXBATWOW'.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException: Cannot open database requested in login 'ASPState'. Login fails.
Login failed for user 'DOMAINXXXBATWOW'.]
System.Data.SqlClient.ConnectionPool.CreateConnection() +402
System.Data.SqlClient.ConnectionPool.UserCreateRequest() +147
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +384
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +92

[HttpException (0x80004005): Unable to connect to SQL Server session database.]
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +190
System.Web.SessionState.SqlStateClientManager.GetConnection(Boolean& usePooling) +98
System.Web.SessionState.SqlStateClientManager.SetAsyncWorker(String id, SessionStateItem item, Byte[] buf, Int32 length, Boolean inStorage) +44
System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.Set(String id, SessionStateItem item, Boolean inStorage) +147
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +465
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

View 1 Replies View Related

Configuring 2GB RAM For SQL

Oct 30, 1998

Dear all

Problem and symptoms

We have recently added 1GB Ram to our systems and now we are trying to optimally configure 2GB of RAM for SS6.5 SP4 and we are getting the fllowing error INFREQUENTLY

"Not enough memory for pss allocation"

We have to restart the SQL server/ (recover databases) to get out of this. Since it is a heavily loaded production environment you can imagine the impact!!.

SPECS

OS-- NT4/sp3
H/W -- Dual Processor Alpha 4100
MEM -- 2GB
SQL PArameters:
memory--819200
Worker Threads -- 255
Proc cache -- 12%

Work done so far

There is a recommendation to reduce the memory or stack size parameters ref:Q160683!!

Question

1. I would like to know if anyone has got around a similar problem, and how. 2. As in NT Virtual Memory Manager AUTOMATICALLY brokers the allocation of physical memory between the requesting applications (e.g. sqlsrvr.exe) and the page file and no application can write directly to RAM, what does the memory parameter in SQL config control? Also then how is the above KB article relevant?

I look forward to your response

Thanks and regards

Arun

View 3 Replies View Related

Configuring SQL Cache

Apr 25, 2007

Hi all,
     I have a question regarding SQL caching.
     I want to use SQL caching for my pages.I've gone through http://msdn2.microsoft.com/en-us/library/e3w8402y(VS.80).aspx article on msdn, where in step by step procedure is explained for this. But I have a slightly different situation. In the article, we need to configure our application from web.config by following...
<!-- caching section group --><caching>  <sqlCacheDependency enabled = "true" pollTime = "1000" >    <databases>      <add name="Northwind"          connectionStringName="NorthwindConnectionString1"         pollTime = "1000"      />    </databases>  </sqlCacheDependency></caching>
 
Where in "NorthwindConnectionString1" is the SQLdatasource connection string. But I'm not using SQLDatasource, and have my own classes to build a connection datasource and get a dataset, and then bind it to my control.So in this case what should I write for the above "connectionstring"  attribute. My connection string is in web.config only with a section defined. and in my application i'm reading from web.fing only.The connection section i'm using is as follows...
<ConnSettings>
<add key="ConnString" value="server=serverName;database=dbName;uid=dbuser;Pwd=password"/>
</ConnSettings>
I want to know how to configure my sql cache in this situation.
 
Thanks,
Mehul Mistry

View 2 Replies View Related

Configuring SQL Datasource

May 29, 2008

Hi
When I try to configure a SQL datasource and I use a Microsoft SQL Server datasource I get a blank drop down list for server name.  My aspnetdb is available in SQL Server 2005 and I can log into it through management studio, and the service is started.  I am also using Vista Ultimate.
Is there any other configuration I need to do for Visual Studio 2008 to see the SQL Server instance?
Thanks
 Kwis

View 2 Replies View Related

Configuring SQL Mail - Help Please

Jun 18, 2001

Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).

Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..

View 5 Replies View Related

Configuring SSRS On Win XP

Apr 4, 2008

Hi All,

I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.

Thank's in advance..

View 2 Replies View Related

Configuring User In SQL

Sep 26, 2007

I new to SQL 2005 and have couple of questions regarding configuring the user. Let me start by saying what I need to be achieved.

1. Create a new user which will be user by couple of people to create and execute stored procedures
2. Deny all permissions for this user to access data from certain tables.
3. Configure the role and permissions for this user so that the above two is possible.


I was able to do the first two steps and when the users uses a query, ( select * from 'that table' ) the result in a permissions error. Also that user cannot view the table in SQL manager

The problem now is that that user can create a stored procedure that has the SQL statement Select * from 'that table' and execute the stored procedure to view the table.

The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?

I am trying to resolve this issue for a while now and any help is greatly appreciated.

Regards,

View 7 Replies View Related

Configuring SQL MAIL

Aug 4, 2005

Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V

View 1 Replies View Related

Configuring SQL With Sp_configure

Jan 7, 2008


Can someone help? I am new to Visual basic programming and have down-loaded Visual Basic Express. I followed the instructions for creating my first database but when I got to making the SQL database I got the following error message. " Generating user instances in SQL server is disabled, use sp_configure "user instances enabled" to generate user instances" Where do I find sp_configure and how do I start it.

View 1 Replies View Related

Error While Configuring

Mar 28, 2007



While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"



Can anyone help me resolve this issue?



Thanks,

Vijay

View 5 Replies View Related

SQL Mail - Configuring

Sep 27, 2006

wasnt sure which forum to put this in - so i'll attempt here!

i have been trying to setup SQLMail in SQL2000 but have been having a few problems

i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account 

i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.

so i assumed that was all thats needed??

through Query Analyzer i run a simple test

EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'

i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent

i also checked the SQL account permissions to make sure it could access the Exchange Server using the

EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success

so now im stumped!

is there anything else i can check to see where or what its supposedly sending??

any help greatly appreciated.
Cheers,
Craig

View 1 Replies View Related

Configuring Roles/Membership SQL To Not Use DBO?

Aug 26, 2006

I have a site with roles/membership working fine on my local machine, but I am having serious trouble deploying it to a shared host.  My hosting provides a sql 2000 database, but the user created for it that I use is not dbo.  I am errors when I try to access my site such as Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'The procedure was created under my user, so it's there, but it's full name ia myusername.aspnet_CheckSchemaVersionHow can I tell the asp.net membership/role provider to use my username instead of dbo when it looks for objects? Thanks   

View 6 Replies View Related

Configuring SqlDataSource At Runtime

Oct 31, 2007

In a web site the user has to choose one out of several sql tables to deal with.
He will then be allowed to view the selected table data through a GridView, to insert a new row into and to update a row in the selected table by means of an array of TextBoxes created dynamically on the base of the selected table.
I think it is possible to solve the problem fully by properly configuring at run time an SqlDataSource.
I have solved the issue of data display by declaring in the code behind within the OnPageLoad sub the following:
SqlDataSource1.SelectCommand = "Select * FROM " & selectedTable
While for the  GridView1 I have added the selected table columns to the columns collection as follows:
for i=0 to ColumnCount-1 Dim cac As BoundField = New BoundField
cac.HeaderText = HeaderNamesArray(i)
cac.DataField = ProductNamesArray(i)Me.GridView1.Columns.Add(cac)
next
I have difficulty on how to do similar declarations for the insertcommand and update command.

View 2 Replies View Related

Configuring Dynamically An SqlDataSource

Jan 4, 2008

I have several Sql Tables, each containing more than 100 fields, on which I need to perform display operation through GridView, Insert and Update through an array of dynamically created and databound TextBoxes.
I would like to use a single page to manage all Sql Tables on the basis of the name of the specific one invoked by the user.
In order to achieve that, I need to  dynamically configure the SqlDataSource Web Control present on the page for each Sql Table. In particular I need to generate at runtime the InsertCommand and the UpdateCommand.
On how to do it I have no idea.
Federico

View 2 Replies View Related

Urgent Configuring Sql Server

May 29, 2008

hi all i try all date convertion  function that u imagen   in my asp.net project to insert a date  to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00"
how can i fix that from sql server
plz

View 8 Replies View Related

Error While Configuring XML Support In IIS With IIS 6.0

Dec 22, 2003

Hi,

I've two servers on which there is the SQL 2000 Server and the IIS 6.0.

I installed the SQL Server Client Tools on web server.

And created the nwind as told in booksonline.

I declared the SQLXML extention and allowed it using IIS 6.

But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.

The web server shows the following error.


ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings



Thanks for any suggestions.

View 2 Replies View Related

Configuring A SQLDatasource Control

Feb 26, 2006

When I configure a SQLDataSource control I want the following where clause...
WHERE     (RegionID = @RegionID AND DistrictID IS NULL AND CampusID IS NULL) OR (DistrictID = @DistrictID AND CampusID IS NULL ) OR(CampusID = @CampusID AND UserRole = 'CampusAdmin') OR (CampusID = @CampusID)but it gets reformated as....
WHERE     (RegionID = 'Region10') AND (DistrictID IS NULL) AND (CampusID IS NULL) OR                      (DistrictID = 2) AND (CampusID IS NULL) OR (CampusID = '999999103') AND (UserRole = 'CampusAdmin') OR                       (CampusID = '999999103')I don't think these are functionaly equivelant, are they?If not how do I stop the 'wizard' from reformatting the SQL where clause?Thanks

View 3 Replies View Related

Problem Configuring Workstation

Apr 14, 1999

How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.

Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.


Can anyone helps?

View 1 Replies View Related

Configuring DISK Sub System

Mar 2, 2006

Hi all,

Need some help with configuring the Disk Sub system using Raid 10

1. What shud be the disk configuration to have 4000 inserts per second on a RAID 1+0 ?
2. What is the best way to maintain a Hot Stand by Server for a very high OLTP system ( say for a day Trading Database ).


Thx
Venu

View 3 Replies View Related

Configuring SQL Database To Access It From Web DB

Jul 7, 2007

hi,

I need to connect my Local Database from SQL Server to the Web Database.
I need to know what all things to be done for completing this process. Some one please please help me with this.

Ad if this information is not enough, please do ask me any question regarding this and iam ready to answer them.

One more thing, iam not that familiar with SQL Server 2000 but i can manage to do things.

So please do help me on this.



Clever_Idiot

View 4 Replies View Related

Configuring Locks In Awe System

Jul 20, 2005

I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Editionon Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPUand 8GB of RAM. I have AWE enabled, /pae /3gb switch is on inboot.ini, In my errorlog I have noticed few times error messages as"The SQL Server cannot obtain a LOCK resource at this time. Rerun yourstatement when there are fewer active users or ask the systemadministrator to check the SQL Server lock and memory configuration.." I haven't modified anything in sp_configure 'locks', so i amassuming SQL server is dynamically managing the lock memory. Runningperfmon for few days I observed that Lock Requests/sec are usually few100,000 most of the times and sometimes goes to 2+ million. However Ihaven't seen Lock Memory (KB) going more than 40MB. So i wonder why amI seeing the Error: 1204 in my sql log ? And any advise on how toprevent it.ThanksAswinee

View 1 Replies View Related

Configuring A Database In Sqlserver?

Jun 9, 2006

I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is 'ASPNET' in "SELECT @s = @@servername + 'ASPNET'"
Also what is 'webuser'



---Configure Doctors
USE doctors

GO

DECLARE @s varchar(50)
SELECT @s = @@servername + 'ASPNET'
EXECUTE sp_grantlogin @s

EXECUTE sp_grantdbaccess @s, 'webuser'

GO

GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser


GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser

GO


Can anyone help me how to solve my problem?
Your help would be very much appreciated

Thanks and Regards

Kavitha

View 1 Replies View Related

Configuring Sql Express On Installation

Nov 10, 2006

Can someone explain to me what SQLACCOUNT=<domainuser> is or should be set to? I get an error telling me to specify a built in account or give a username domain and password for each service. How do I specify these things I didnt see those in the 1 msdn page that explains this. I asked this before but I still cant figure it out. Thanks.

View 1 Replies View Related

Need Help Configuring SQL Server Express

May 11, 2007

I have Visual Studio 2005 Professional installed and SQL Server Express installed. In following along with the Microsoft Visual C# Step by Step book, there is a procedure on page xxi to get access to SQL Server Express. At the 2> prompt, however, when I type in go and then press enter, I get the following message:



Msg 15247 Level 16, State 1, Server MyServerNameSQLEXPRESS, Procedure sp_grantlogin, Line 13



User does not have permission to perform this action.



The computer is my own personal computer, with Window Vista installed and no previous versions of MSDE installed. I also have administrator persmissions. The only guidelines in the procedure regarding what to do in the event of an error message is to ensure that the commands were typed in correctly. What could be causing this message, since I do have administrator permissions?

View 9 Replies View Related

Configuring Environment For First Time

Feb 8, 2006

Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".

I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.

Any suggestions on how to resolve?

View 4 Replies View Related

Configuring 2 Nodes As Failovers For Each Other

Mar 22, 2007

We have a number of databases in our company and we recently had to buy a second SQL server. What I would like to do is have both SQL Servers act as failovers for each other. They both are the exact same hardware configuration (dell blades poweredge 1855) and we have a RAID array with Melio clustered file system for our web servers. I haven€™t found any documentation on if this is even possible. Am I completely wrong in thinking this can be done or is there a better solution to spread the load but provide failover support with out buying 2 new machines?

View 1 Replies View Related

Configuring Dataset Dynamically

Apr 16, 2007

HI ,



I am using SQL Server 2005 Reporting Services. I have many parameters to pass to the dataset. Is there a way to change the dataset dynamically based on the parameters selected?



Suppose If param1 is selected, I want to use dataset1 and if param 2 is selected. I want to use dataset2 and so on... in my reports.



Any help is greately appreicated!



Thanks in advance!

View 8 Replies View Related

Configuring Reporting Services

Apr 26, 2007

Hello Experts,



I have this problem when i go to http://<servername>/reprots



"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "



I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.



i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....



would be great if someone suggests.



regards,

lakshman.









View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved