Post reply

SQL Admin Tool to resolve the SQL Server typical permisisons

  • August 4, 2011 at 1:45 am

    #255163

    Hi,

    Is there any tool available called as - 'SQL Admin Tool' which helps to solve the SQL Server security related issues for Logins/service accounts, etc?

    I thought it is the SSMS which is the SQL Admin tool, but looks there is a typical tool as 'SQL Admin Tool' which has the ability to restrict permisions for Logins to run SQL Server, SQL Server Agents and Jobs with specific and limited permission settings.

    Any thoughts?

    The below URL doesn't seem to be too valid for Cluster Environment -

    http://technet.microsoft.com/en-us/library/ms143504.aspx#Review_NT_rights

    Pls suggest.

    Thanks.

  • August 4, 2011 at 5:10 am

    #1363540

    Never heard of that. It's SQL Server Management Studio and has been for quite some time. That's where you administer your server, including security. Although, you can do most of it through TSQL or SMO as well.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 4, 2011 at 5:24 am

    #1363550

    There are a number of tools that help perform Admin activities overall ( including backups and audits etc) there are some even specific to SQL Server security but I haven't come across anything called SQL Server Admin tool.

    I think the closest thing to yoor post is the policy and facet features in sql 2008.

    Jayanth Kurup[/url]

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

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