locked
.NET Application Development using SQL Server Services and Databases RRS feed

  • Question

  • This is a general question relating to a .NET app we are building that processes data contained within SQL Server 2008 R2 databases. 

    Originally, we were anticipating distributing our app to our user base, requiring that our users install the free version of SQL Express 2008 R2 Edition.  Unfortunately, our app cannot live with the 1 GB of memory limitation or the 10 GB database size limitation of the SQL Express Edition.  The Standard Edition of SQL Server 2008 R2's limitations, however, will work perfectly for the app.   

    The question is, how do we distribute the app to the user base without requiring them to purchase a full version of SQL Server 2008 R2 Standard Edition (at a hefty price)? 

    I think I recall that earlier versions of SQL Server provided a SQL Server distributable runtime version that could provided to the users of a .NET app that accessed SQL databases and services, without requiring the user to purchase a full blown edition of SQL Server.  I could not find anything like that, however, related to the SQL Server 2008 R2 Standard Edition. 

    I might mention that the app is a standalone app, which runs only on a user's desktop system (not in a server environment).  The app and the SQL databases are all contained on the user's desktop.

    Thanks in advance for any help and assistance.   Much appreciated!

    • Moved by Bob Beauchemin Tuesday, November 15, 2011 8:47 PM Moved to the SQL Express forum (From:.NET Framework inside SQL Server)
    Tuesday, November 15, 2011 12:59 AM

Answers

  • Hi SentinelSQL,

    >> The question is, how do we distribute the app to the user base without requiring them to purchase a full version of SQL Server 2008 R2 Standard Edition (at a hefty price)?

    I think it’s better for you  to purchase full version of SQL Server 2008 R2. For the earlier versions of SQL Server that could support .NET application access SQL databases and services, which also require SQL Server license. That means you still need to purchase.

    For the license issue, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. You can also visit the following site for more information and support on licensing issues: http://www.microsoft.com/licensing/mplahome.mspx.

    Additional, SQL Server is available in an Evaluation edition for a 180-day trial period. After this period, you still need to buy it.
    More information, please refer to Features Supported by the Editions of SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Regards, Amber zhang
    • Marked as answer by amber zhang Tuesday, November 22, 2011 1:24 AM
    Wednesday, November 16, 2011 3:50 AM

All replies

  • This is a general question relating to a .NET app we are building that processes data contained within SQL Server 2008 R2 databases. 

    Originally, we were anticipating distributing our app to our user base, requiring that our users install the free version of SQL Express 2008 R2 Edition.  Unfortunately, our app cannot live with the 1 GB of memory limitation or the 10 GB database size limitation of the SQL Express Edition.  The Standard Edition of SQL Server 2008 R2's limitations, however, will work perfectly for the app.   

    The question is, how do we distribute the app to the user base without requiring them to purchase a full version of SQL Server 2008 R2 Standard Edition (at a hefty price)? 

    I think I recall that earlier versions of SQL Server provided a SQL Server distributable runtime version that could provided to the users of a .NET app that accessed SQL databases and services, without requiring the user to purchase a full blown edition of SQL Server.  I could not find anything like that, however, related to the SQL Server 2008 R2 Standard Edition. 

    I might mention that the app is a standalone app, which runs only on a user's desktop system (not in a server environment).  The app and the SQL databases are all contained on the user's desktop.

    Thanks in advance for any help and assistance.   Much appreciated!

    • Merged by amber zhang Wednesday, November 16, 2011 4:23 AM same thread
    Monday, November 14, 2011 11:20 PM
  • Hi SentinelSQL,

    >> The question is, how do we distribute the app to the user base without requiring them to purchase a full version of SQL Server 2008 R2 Standard Edition (at a hefty price)?

    I think it’s better for you  to purchase full version of SQL Server 2008 R2. For the earlier versions of SQL Server that could support .NET application access SQL databases and services, which also require SQL Server license. That means you still need to purchase.

    For the license issue, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. You can also visit the following site for more information and support on licensing issues: http://www.microsoft.com/licensing/mplahome.mspx.

    Additional, SQL Server is available in an Evaluation edition for a 180-day trial period. After this period, you still need to buy it.
    More information, please refer to Features Supported by the Editions of SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Regards, Amber zhang
    • Marked as answer by amber zhang Tuesday, November 22, 2011 1:24 AM
    Wednesday, November 16, 2011 3:50 AM