468,110 Members | 1,540 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

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

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
Milind
Jul 15 '07 #1
0 1188

Post your reply

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

Similar topics

8 posts views Thread by shandain | last post: by
1 post views Thread by Likhith Areekkal | last post: by
1 post views Thread by Brad Isaacs | last post: by
4 posts views Thread by Brad Isaacs | last post: by
reply views Thread by SOI_0152 | last post: by
2 posts views Thread by hcaptech | last post: by
1 post views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.