How to configure SQL Server for ASP.NET SQL Server Session State <sessionState mode="SQLServer" ../>

On your prompt (doesn’t matter if you’re on the SQL server machine or not), run the below command:

”system root”\Microsoft.NET\Framework\”version number”>aspnet_regsql.exe –S “server” -U sa -P “Password” -ssadd -sstype p

for eg:

C:\Windows\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S MySQLServerInstanceName -U sa -P password -ssadd -sstype p

OR

C:\WINNT\Microsoft.NET\Framework\v4.0.21006>aspnet_regsql.exe -S MySQLServerInstanceName -U sa -P password -ssadd -sstype p

Now you have ASPState database on your servers with the tables, stored procedures, jobs needed to handle SQL server mode session state.

My mentor profile on #ImagineCup updated!

Mohamed Samy has been tweeting a lot lately about ImagineCup, asking people to sign up as mentors & support the Egyptian teams. So, I’m posting this to let you know that I’ve just updated my profile there. So if you’re looking for a mentor (I guess I won’t be useful except in software design competition) look for my profile under the name “Shady M. Najib”.

Along the way, I’m inviting you too, to join ImagineCup both as mentors and competitor, it was & will be a great experience, that one thing you should be sure of.

One last thing I should says here, is that I realized while updating my profile that I set my “Notify me of new private messages” status to “No” which kept a couple of messages off my radar. So please guys & gals, pardon me, that wasn’t intended! :$ I’ll be more attentive next time :)

PS.: remember to check Egypt Local website: http://imaginecupegypt.com/