administer sqlexpress with ssms, Standard Edition license covers?

  • my organization have a number of Standard Edition SQL Servers licensed per CPU plus some SQLEXpress instances, is it supposed to be permitted to deploy SSMS on desktop workstations and/or servers to administer both? have found it dfifficult to find clarification, although one post on the web quoted a MS representative as affirmative on this.

    another point that I would like to clear up is if it is permitted to schedule jobs on Express using a Standard Edition Agent, which works quite well technically.

    THanks for your experiences /opinion

    Harvey

  • About the licensing issue I'm also not really a 100% sure, but I think that it's ok to manage your Express editions from SSMS which is covered by any other license.

    About the SQL Agent jobs run from another server I would say that to the Express instance it's just an incoming connection like any other and shouldn't be a problem at all. It makes no difference if the connection is made by a user or a windows service.

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

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