Limitations of SQL Server 2005 Developer Edition

  • Hi Guru's

    I want to find out what limitations there are for SQL Server 2005 Developers Editions, Does it have restrictions of the number of sessions and is there any others, I have looked at the MS website but failed to locate this information

    Cheers

    Peter

  • Developer Edition has the same features as Enterprise Edition..and the only difference is in licensing policy.

    You are not supposed to use developer edition for prodcution.

    SQL Server 2005 Features Comparison

    http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

     

    MohammedU
    Microsoft SQL Server MVP

  • one limitation is you can't upgrade from SQL 2000 Enterprise. We have it in QA and I had to uninstall and install SQL 2005 from scratch. Good thing is that it allowed us to clean up some junk in QA.

  • If you are talking about Ent Edtn --> Dev Edtn.

    I think that is called downgrade not upgrade.

    MohammedU
    Microsoft SQL Server MVP

  • Hi

    Thanks for the info, I know some products in the past have had restrictions on number of sessions or similtaneous connections in the developer editions. I have a client who has it installed as a production server, they are rectifying ASAP. They are getting unexplained application failures with errors like "SQL Server does not exist or access denied". This application is a Dotnet 1.1 app which is working fine at plenty of other sites. As they are running a 1GB backbone with 100MB from local switches to the PC's where the application is installed, it had me needing to find out if a limitation of Developer Edition is causing the connection errors"

    Cheers

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply