SQL Server Performance

SQL Licensing

Discussion in 'Performance Tuning for DBAs' started by hooperdba, Jan 17, 2007.

  1. hooperdba New Member

    I am migrating from serverA to ServerB. Server A has 'per_seat'
    license, qty=50. ServerB has 'per_seat' license qty=5. I went into
    control panel/sql licensing and increase qty to 50 on server B.
    Only now when I query select 'serverproperty('NumLicenses')' I'm still getting 5. Did this change not take.

    Any help would be appreciated.

    thanks
  2. Luis Martin Moderator

    You have to stop and restart sql server.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page