Unable to use SQL Server because ASP.NET version

Question

Unable to use SQL Server because ASP.NET version

Bhuvnesh

SSC Guru

Points: 59351
More actions
August 16, 2009 at 11:43 pm

#134864

i have made a new Sql instance , while conecting it with application , i am getting following error :
----ERROR ----------------------------------
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.
-----------------------------------------
can anybody help me out ???
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Newton SSCommitted Points: 1894 More actions · Answer 1

You probably already realise this but your app is configured to store state in your SQL Server database. As this is a new SQL Server you will need to configure it to do so. I recall having to run ASPNET_REGSQL.EXE a very long time ago but I am sure you can find something on google which gives step by step instructions.

Anyone already got this to hand?

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

Only the data was refreshed from other server, so the settings\configuration of server was same as earlier

although i tried , by starting it with aspnet_regsql.exe with required parameter btu problem remained same

but after doing some tweaks , i found that LOGIN which application was using to connect with Aspstate DB, didnt have required rights\permission.

I modified it and it WORKED for me.

but it is a strange that inspite of giving login related error description , why it was throwing this error ??

but end of the day , i found the solution.

anyways thanks for all the guys , who looked into it

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Steve Newton SSCommitted Points: 1894 More actions · Answer 3

Sounds like bad error handling to me. Can't connect to it, therefore it mustn't be there! We all work with Microsoft products day in day out so shouldn't be too surprised at red herrings really!

cppprogrammer Right there with Babe Points: 797 More actions · Answer 4

I'm suddenly getting the same error too... figure the same (that it is a user/role permission issue) but it was working perfectly for 3-4 days.