Hi Frank,

Support for SQL 2000 was dropped due to the amount of time and complexity required to keep maintaining support for it. There are a lot of new feature and enhancements that have been added to SQL Server since SQL 2000 and mojoPortal benefits from those. The decision to drop support wasn't made easily and the community was asked for feedback well before the decision was made.

Can you not change to a different host or server at your current host that has SQL 2005 or newer? Regardless of Operating System updates, your hosts' server is not completely up-to-date if they are using SQL 2000 because Microsoft ended support for it ended in 2008.

Thanks,
Joe

Hi Frank,

Unfortunately, the permission issue is just one thing that will not work correctly and if you find a way around it, you will run into many more issues because mojoPortal uses data types and routines that are not available in SQL 2000.

I understand how frustrating it can be to switch hosts but if they don't have a SQL 2005 or newer database server that you can use, I am afraid your only choices are to move or keep using an old version of mojoPortal.

If you are willing to switch hosts, I can offer you a discount on hosting at i7MEDIA. Just send me an email at joe (at) i7media (dot) net so we can work out the details.

Thanks,
Joe D.
 

Hi Frank,

Joe D. is correct, there is no way to use SQL 2000 anymore because of the data type changes. The only way forward is to migrate the database to SQL 2005 or SQL 2008 by backing it up from the current SQL 2000 database and restore it on SQL 2005 or SQL 2008.

You mentioned that you have Plesk, maybe your version of Plesk only supports SQL 2000, but if you have control of the server you can install SQL 2008 Express on the same server even if you have SQL 2000 running on there because you can install multiple instances of MS SQL.

I asked for feedback from people using SQL 2000 way back in March 2010 and while a few people said they were using it they also said they could migrate to a newer version.

http://www.mojoportal.com/anyone-still-using-sql-2000-with-mojoportal.aspx

then we finally did drop support for SQL 2000 as of mojoPortal version 2.3.4.8 in July 2010

http://www.mojoportal.com/mojoportal-2348-released.aspx

So we tried to give a lot of advanced notice to avoid troubles such as you are having now, but ultimately it was in the best interest of the project to drop support of SQL 2000 so that we could have a single data layer that does support SQL 2005/2008/SqlAzure.

SQL 2000 is legacy technology no longer supported by Microsoft and most hosting companies have offered newer versions of MS SQL for a very long time. If your current host does not offer SQL 2005/2008 then the only solution is to migrate to new hosting.

Best,

Joe