By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,993 Members | 1,984 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,993 IT Pros & Developers. It's quick & easy.

Help Required regarding Creation of SQL 2005 Jobs and Exec them by using Non-SysAdmin

P: 1
Currently I am working on MSN Project which has been developed in ASP.Net 2.0 and Backend is SQL Server 2005.

Right now our application requirement is that we have to create the Job at runtime through WINDOWS UI which earlier we were doing using ‘sysadmin’ database user and for running the ‘SQL Job’ (which internally uses ‘xp_cmdshell’), we have created the Credential with ‘Windows LogOn account’who is admin on the SQL machine. Thus everything was working fine.

But due to PRODUCTION Security Constraints, so our system will fail thus please let us know immediately of how we can create the SQL Job at runtime by just using the ‘Non-sysadmin’ User.

Also let us know how can we execute the SQL 2005 job by creating the SQL Service Account (which is basically the standard MSN SQL Service Account) whose password is sql service password but not the Windows Domain Password. Currently when we are trying to create the job then it is giving the error “Bad Username or Password”.

Please let us know how can we proceed to create the Job at runtime and executing it through xp_cmdshell with the following PRODUCTION environment limitation:

1] Sys-admin login’s will not be allowed on the PROD Sql Server.

2] There will be no sharing of Windows Domain Password so on CREATE CREDENTIAL command we have to use only ‘MSN SERVICE ACCOUNT’ which is basically the standard MSN SQL Service Account.

Do let us know your response at the earliest.

With Thanks and Regards
Jul 15 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.