Hi Black ViX,

Perhaps this blogpost can help you a step further.

http://www.saotn.org/configure-sqlserver-sessionstate-for-umbraco/

Hope this helps,

/Dennis

Hi Dennis.

Thank you for the information, looks like I will be able to do it, but I don't have access to my database on the ISP server.

WIll I have to ask them to create a backup, restore it on my side, make the changes and FTP a new backup for them to restore?

We went this route last night because of other changes (by changes I mean adding content in a table), and once I send them a new copy they couldn't restore it.

I am having issues with sessions being drop minutes after loggin in on the back office, So now I want to setup a session state and see if I can get this issue solved.

So if I can't sent them a DB they can't restore, I can't setup session state then.

So out of ideas.

Thank you Dennis,

Kind regards,

There is a small section in the documentation here in the context of load balancing.

Hi Jeavon,

Thank you for the information, unfortunately it didn't help much, but much appreciated.

Kind regards,

No problem, did you follow the link through to Microsoft?

Hi Jeavon,

Sorry... Yes I did and the information is extremely helpful, but I think the issue is with my ISP.

I wanted to setup a session state in my database, so I asked the ISP to send me a .bak copy, restore it to my local machine, did the changes for session state, made a .bak and FTP it back to the ISP, but they are having issues in restoring my .bak database.

Then I wanted to create a SQL Compact DB, setup that as a session state DB, but from what I understand this cannot be achieve with SQL Compact.

And I can't create a second DB just for session state, my package only allows one DB.

Last night my website went down while busy loading content and media, 503 error.... the application pool stopped because of errors.

The ISP restarted the AppPool and told me errors was responsible so I asked for a copy of the log file.

The errors are: 

1. Cannot open database "db" requested by the login. The login failed. Login failed for user 'user'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection... (and this is a username and password they gave me.)

2. This is an invalid script resource request. at System.Web.Handlers.ScriptResourceHandler.ProcessRequest(HttpContextBase context, VirtualFileReader fileReader, Action`2 logAction, Boolean validatePath) Error occurred during a cryptographic operation. at System.Web.Security.Cryptography.HomogenizingCryptoServiceWrapper.HomogenizeErrors(Func`2 func, Byte[] input) at System.Web.UI.Page.DecryptString(String s, Purpose purpose) at System.Web.Handlers.ScriptResourceHandler.ProcessRequest(HttpContextBase context, VirtualFileReader fileReader, Action`2 logAction, Boolean validatePath)

ScriptResource.axd?d=nv7asgRUU0tRmHNR2D6t1H99MxATO
_SausxOvoiDRY54Aa7IVKLEPSxp8R2wnDApwnZVI8lz6oEndrs
Dd73LCpvFCghbsUE203ErE4fx3GIV2BUDm50m1cM70n2fgiHNZU8yqclpgyH5rNLsVyF1Rg2&t=ffffffff93df46e6
/ScriptResource.axd

3. The AppPool crashed.

Help me if I am wrong, but this looks like login issues on the DB side of the ISP which keeps dropping, creating errors becuase no other files can be accessed what they need. Building a error log in the AppPool causing it to stop working.

SO what I want to do is get another ISP and see if they are able to cope with this, I have been at this for 3 weeks now, so I want things to work without issues.

Any Information would be greatly appreciated!

Kind Regards,

Hi, Is your ISP load balancing your website or moving it from one server to anther frequently, there is no other reason to require you to change from "InProc"? That first log entry is definitely a db server issue or your credentials are wrong (seems unlikely).

I would suggest trying it somewhere else, I know you might need somewhere more local but with Heart Internet in the UK you can get a full Win2012R2 VPS for only £22 per month, you can install SQL Express on it and your all set with RDP access. https://www.heartinternet.uk/vps

Jeavon

Hi, not as far as I know, maybe I should find out, if they are doing load balancing (which I think they might because of shared hosting, not sure) then I should setup my CMS for load balancing. I will send them a e-mail.

I am waiting for a another ISP to get back to me with some questions I had, but unfortunately I will have to find someone local, makes it a bit easier for me when comming to support and I live in South Africa, things here are a bit behind.

Jeavon, truly appreciate your help in this regard, thank you

Kind Regards,

You're welcome.

If you can, I would try to get a VPS service rather than shared hosting.

Good luck!

Thank you Jeavon.

Will post the info, hopefully I will succeed this time.

Kind regards,

is working on a reply...