Post reply

Executing a Job in SQL Server Management Studio without being Administrator in that Server

  • August 19, 2009 at 9:00 am

    #203979

    Hi,

    I will first explain the senario.

    The client has given me SQL Server Authentication by creating a login in that server through SQL Server Management Studio. He has also given me sysadmin Server Role. But I am not the Administrator in that system, I mean which can be given clicking the properties of My Computer and then clicking on Manage.

    I am trying to execute the job in that server with my SQL Server Authentication. But it is giving me the error that login failed for the user that is me.

    I tried changing the protection level to DontSaveSensitive. Running the package through the Config files which stores all the connection strings. But still I am getting the same error.

    I believe untill I become the Administrator in that server I wont be able to execute the job.

    Can you guys put some more inputs into that and also correct me if I am wrong.

    Thanks

  • August 19, 2009 at 9:36 am

    #1041659

    I answered you in the thread below and you did not come back, if your data is from one SQL Server to another is no requirement for admin permissions you just need to ask your client to create a proxy account from an admin account. You need to go step by step to find out the point of error so you can resolve it.

    http://www.sqlservercentral.com/Forums/Topic770010-324-1.aspx

    Kind regards,
    Gift Peddie

  • August 20, 2009 at 5:57 am

    #1042040

    Thanks a lot. There is 1 more issue related to this topic only but I want to start new topic for this

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

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