none
SQL Server licensing question RRS feed

  • 問題

  • 關於license 問題, 請各位高手請幫幫忙, 俾d意見

    而家有d 咁o既 configuration:
    web server (web services hosted)
    SQL server 2005 std

    - 會有 d hardware device (估計1000個) 定期會回傳d data 返黎會經 web service 寫落 database)
    - 會有大約 10 個 user 用 client application 連到 web server 去存取資料
    - database 裡邊只手動增加了一個user (SA 級), 而所有的 web service 是用這個 user 來存取 database

    現在問題有以下:
    - 那些 hardware device (1000個)要不要霸佔 license? 因為它們並不會直接存取 database.
    - 那些 user 要不要霸佔 license?

    • 已編輯 eiknarf 2009年4月6日 上午 04:38
    2009年4月6日 上午 04:18

解答

所有回覆

  • Hi, provided this ENG version just in case you don't understand Chinese characters.

    Given the following scenario:

    System Configuration:

    Web server (web services hosted on it)
    SQL Server 2005 std

    - There are about 1000 hardware devices that will transmit health status back to the webserver on a regular basis, and through the web services hosted on web server, it will update the database accordingly.

    - There are around 10 users which will use a client application that connects to web server to have access to the system's functionalities.

    - In database server, there is only one user which is manually added, let say app_admin which is an SA and all the web services use this user to access database


    Here comes my question:

    - Do I need CALs (client access license) for the 1000 devices? I'm asking this because theoretically it's always the  'app_admin' user retrieves / updates the database
    - Do I need CALs the users who use the client application?

    Thanks!
    2009年4月6日 上午 04:38
  • I believe you need per processor license in this case.
    2009年4月6日 下午 02:57
  • The answer is yes, you need both the 1010 CAL.

    This is the multiplexing scenario.
    http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx
    • 已標示為解答 eiknarf 2009年4月8日 上午 01:33
    2009年4月7日 上午 01:55
  • The answer is yes, you need both the 1010 CAL.

    This is the multiplexing scenario.
    http://www.microsoft.com/sqlserver/2005/en/us/special-considerations.aspx

    Thanks all for the answers.

    Or maybe let me simply put it in this way.

    If I am going to host a web site which uses SQL server 2005/2008 as backend database server,

    - Web server (IIS). This is the front-end web server provides 1 web service which will have access to the database server , which allows access from all over the world

    - Microsoft SQL Server 2005/2008 Standard Edition

    Is the 'per processor' the only license option for me? (Given that I will not know how many ppl will visit it)

    2009年4月7日 上午 04:57
  • Need per processor license if sql is used as backend of web service as I know. By the way, 1010 cals may much expensive than per processor license.
    2009年4月7日 下午 01:26