Dropped support for SQL 2000

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
11/5/2010 12:51:34 AM
Gravatar
Total Posts 4

Dropped support for SQL 2000

Dropped support for SQL 2000 :-(

Hi everyone, I'm really sorry it should perhaps drop mojoportal for it is a server 2003 I have my domain to provide ease Plesk 10 as hosting system and is fully updated.
But Joe has chosen to remove support for SQL 2000 and after the time it is impossible to upgrade or create new-installing without this error message.

----------------------------------------------------------------------------------------------------------------------------------------------

Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
MSSQL database connection ok.

mojoSetup has detected that the database user does not have permission to alter the database schema. You need to correct this or provide a connection string with sufficient permission.

database initial schema needs to be created.
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.
------------------------------------------------------------------------------------------------------------------------------------------------

Have talked to hostmaster where I have my domain, he says all other portals can be installed without problems, Joe how about making support for SQL 2000 again saw them sitting with the old can still use your system, and Form Wizard Pro from,Event Calendar Pro from that I have purchased.

I hope anyone can help me to set the correct write permissions to the user in the database everything else can run without problems, but lacks support for SQL 2000


Best Regards

Frank

Danmark

11/5/2010 10:20:21 AM
Gravatar
Total Posts 2187

Re: Dropped support for SQL 2000

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

11/6/2010 1:34:54 AM
Gravatar
Total Posts 4

Re: Dropped support for SQL 2000

Hi Joe :-)

My post should not be construed as an attack because I fully understand the decision taken, but it is more a cry for help if there was anyone had a solution how to do without changing hosting company.

Best Regards

Frank

Danmark
 

11/6/2010 3:28:24 PM
Gravatar
Total Posts 2187

Re: Dropped support for SQL 2000

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.
 

 

 

 

11/6/2010 3:28:28 PM
Gravatar
Total Posts 2187

Re: Dropped support for SQL 2000

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.
 

 

 

 

11/7/2010 5:14:23 AM
Gravatar
Total Posts 18439

Re: Dropped support for SQL 2000

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

You must sign in to post in the forums. This thread is closed to new posts.