Updating 4.2.1733 to 5.0.2860.0

I have an old sitefinity setup that is still on version 4.2.1733.  I see you can do an update straight into 5.x from 4.3 or 4.4 and 3.7 but not from 4.0-4.2.  I can't find any of these older Sitefinity Program Managers in my software downloads so i can take my 4.2 to 4.4 and then upgrade to 5.  I tried running 5.0.2860.0 and upgrading the old site but it creates an error saying:

Hi WebGuy,
I have corrected myself about sitefinity version numbers in my next reply, while my instance on your error is the same as i mentioned earlier that it looks like DB error so you better consider the version of your db you are updating to and from.
Regards.

Hi WebGuy,
First of all let me appologise and correct myself on my point that any of the sitefinity 4.x version can be upgraded to 5.x. Sitefinity only support an upgrade from last 2 versions and those are 4.3 and 4.4 so by going stiefinity upgradation track, 4.1 version should be upgraded to 4.3 and than from this point it can be upgraded to 5.0. I am also going to upgrade a 4.1 site to 5.0 and obviously have to move on to 4.3 first and than from that point will take it to 5.0.
Let me know if you have any luck with your problem?
Regards

Yes, that's what i was saying.  I need to know where i can find a project manager of 4.3 or 4.4 so i can run that update first and then finish into 5.  Where do you find these older Sitefinity Project Managers at?

I assume you or your company has a sitefinity account so if you go to the Sitefinity download and other resources, you will find the previous versions of Sitefinity Project Manager.
P.S. I am upgrading from 4.1(SP2) to 4.2 and getting Telerik.Openaccess.Runtime error. Tried everthing but it looks like as my upgraded project still referencing to the older version of Open Access. Any idea about how to resolve this problem?
Regards

Sadly I haven't messed with the OpenAccess yet so I couldn't even guess at to what it might be.

Thanks for pointing the older version area out.  The link was sitting there in plain sight yet I couldn't find it.  I attached a screen shot in case anyone in the future comes across this thread.  I did update the project to 4.4 and then to 5.0.  I'm getting a new error which i'll have to hunt down and fix on the SQL Express side it looks like:

Cannot open user default database. Login failed.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Which can be fixed by:

1- Login to SqlExpress via SQL Server Management Studio

2- Go to the "Security" directory of the database

3- Right-click the Users directory

4- Select "New User..."

5- Add 'NT AUTHORITY\NETWORK SERVICE' as a new user

6- In the Data Role Membership area, select db_owner (see Settings.gif)

7- Click OK

Waseem,

Hi WebGuy,
you can try ammending your connectionstring in App_Data->Sitefinity->Configuration->DataConfig.config file. Just look at this location what's your connection string reffering to. Otherwise, just comment the current connection string and than add a new one with the DB settings of the system where your sitefinity DB resides.
P.S. thanks for the reply to my Open Access issue. I have the same error as of the link you supplied in your reply. I am already been through all the posts on sitefinity forum regarding to this issue but still no luck. Thanks once again.
Regards!

Thanks for the help.  I'm knocking out these errors one by one and now am on the same error you may be seeing:

You are welcome :)
I am on this error since friday and doesn't look like that easy to be get rid off.
I'll advise you to look at all of your reference carefully and update them accordingly in all of your reference folders. I am currently stuck with Telerik.OpenAccess.SDK and funny thing is, I dont have an access to the 4.2.1733 SDK libraries and currently trying to get hold on to that particular SDK version.
By the way is there any chance if you can look into you project and see if you may have Telerik.OpenAccess.SDK libraries for Sitefinity 4.2.1733.0.
Wish you good luck and let me know when you fix it.
Regards!

I ended up doing two things which got me by this error.

1- make a backup of your project.

@WebGuy,
I have successfuly upgraded to 4.2.1733.0. Though it was a nerve-wracking process but at the end, it was really a good learning. My project has 9 additional modules and their build was not getting updated in my WebApp\bin directory. On Build Solution, everything was bang on but it was throwing exceptions at run time. Most common exceptions were of Telerik.Sitefinity, Telerik.OpenAccess and Telerik.OpenAccess.Runtime can't find the older version .DLL's. By chaning the output path of all the modules to the WebApp\Bin directory solved my problem.
Now have to move on to the next phase i-e. 4.3.
Regards!

Glad you are getting it working.  Yes, you could update to either 4.3 or 4.4 and then do the final upgrade to 5 like i did.  The main different between us is that I didn't have any custom modules... yet.  

Perhaps one day this update (and module registration) will all be done through the admin page much like WordPress and other CMS solutions.  Sitefinity still requires a lot of manual tweaking to get it happy.

Thanks for all of your help!

just change the assembly version number in web.config to be

  <add assembly="Telerik.OpenAccess, Version=2013.1.418.2, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342"/>