Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing a Job in SQL Server Management Studio without being Administrator in that Server Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 9:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 18, 2013 12:23 PM
Points: 195, Visits: 82
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
Post #773609
Posted Wednesday, August 19, 2009 9:36 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:22 AM
Points: 3,433, Visits: 14,428
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
Post #773672
Posted Thursday, August 20, 2009 5:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 18, 2013 12:23 PM
Points: 195, Visits: 82
Thanks a lot. There is 1 more issue related to this topic only but I want to start new topic for this
Post #774131
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse