Post reply

sql server user authedication modify

  • December 21, 2011 at 12:28 am

    #248421

    I want Change windows authendication user to sql server windows authentication user..because that user is main user. this user only create db and maintenace plan and jobs.pls steps

  • December 21, 2011 at 12:45 am

    #1424054

    Coolroof (12/21/2011)

    I want Change windows authendication user to sql server windows authentication user..because that user is main user. this user only create db and maintenace plan and jobs.pls steps

    What is your question? How to change the authentication, or what priviliges the user needs to create maintenance plans and jobs?

    Change Authentication (first Google result for "sql server change to sql server authentication windows"):

    http://msdn.microsoft.com/en-us/library/ms188670.aspx

    According to this MSDN page (first Google result for "sql server permissions maintenance plan"):

    http://msdn.microsoft.com/en-us/library/ms187658(v=SQL.105).aspx, the user will need to be a sysadmin to create and manage maintenance plans.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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