asp.net setup doubts

RAVI 896 Reputation points
2023-02-03T11:07:51.19+00:00

Hello
We Have developed one small web application which has aspx page and cs file c# as a code behind. We use database as sql express 2008 R2 Microsoft SQL Server Express Edition with Advanced Services ( sql server management studio SQLEXPRWT_x86_ENU.exe)

We Config aspx page in IIS and will install database as Microsoft SQL Server Express Edition with Advanced Services (sql server management studio SQLEXPRWT_x86_ENU.exe) in multiple clients each client will have its own computer. Is SQL Server Express Edition with Advanced Services(SSMS) Is Free. Can we install in client site?

Thank You

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,251 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
Accepted answer
  1. Seeya Xi-MSFT 16,436 Reputation points
    2023-02-06T06:37:39.0833333+00:00

    Hi @RAVI,

    Yes, you can. Please refer to this document: Editions and supported features of SQL Server 2022

    User's image

    All versions of Express edition are the same, I'm just using SQL Server 2022 as an example. By the way, your SQL Server 2008R2 is so old that it is not supported.

    SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS is a free tool: Download SQL Server Management Studio (SSMS)

    Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2023-02-03T12:45:50.6966667+00:00

    MS SQL Server Express Edition is free for use, also for commercial, see Microsoft® SQL Server® Express License Terms for Redistribution and Hosting

    But version 2008 R2 is very old and out-of-support, you should better use the latest versions like 2019/2022.

    0 comments
  2. Bruce (SqlWork.com) 55,601 Reputation points
    2023-02-03T17:14:44.19+00:00

    sql express is free for private and commercial use. will only use 1 processor, max 1 gb memory and max 10 gb database storage.

    0 comments
  3. Naimish Makwana 170 Reputation points
    2023-02-06T06:56:27.4433333+00:00

    Hello Ravi,

    Yes, Microsoft SQL Server Express Edition with Advanced Services (SSMS) is a free edition of SQL Server that can be installed on client sites.

    It provides limited functionality compared to the full version of SQL Server, but is sufficient for many small to medium-sized applications and is commonly used for development and testing purposes.

    NOTE : it's important to check the license agreement to ensure that it meets the specific requirements of your organization and usage scenario.

    Thanks

    Naimish Makwana

    0 comments