Post reply

Configuration Manager - setting alias when not a local admin

  • May 3, 2010 at 9:45 am

    #138902

    This seems overly restrictive. Whenever a developer needs a new alias he has to log off and have a sysadmin account set up an alias. Isn't there a way around this? I've poked around the forums a little and haven't seen this addressed before.

    TIA.

  • May 5, 2010 at 12:20 am

    #1162252

    SqlServerAlias is managed through wmi. You could assign permissions for your developers to this name space. It's not perfect since you have to assign permissions to the entire namespace and not to the specific class...

    This article explains how to set permissions. http://support.microsoft.com/kb/325353

    The namespace will be root\Microsoft\SqlServer\ComputerManagement10 for sql2008 or root\Microsoft\SqlServer\ComputerManagement for sql2005.

    -Jeremy

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

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