| Author |
Topic |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2012-07-10 : 10:07:52
|
| What is service account?shall we connect sql server through service account? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-10 : 10:19:04
|
| service account is account using which a particular service runs in server. We should not use service account to connect to sql server. For our purpose we will make use of domain user account/sql authentication account created------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-10 : 10:41:47
|
| how to run a job using proxy account in production server? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-10 : 10:45:03
|
| how to run a job using proxy account in production server? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-10 : 12:31:26
|
| did you see what i posted?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-11 : 07:03:16
|
| batch file is compulsoray for executing a job? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-11 : 10:27:50
|
| nope...are these some interview questions?batch file is just one way of executing automated script. you can even run t-sql scripts, ssis packages etc from job.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-11 : 10:55:17
|
| Thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-11 : 11:33:09
|
quote:
Originally posted by sravanim
Thank you
welcomei was expecting next question  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 10:04:24
|
| can w run scheduled job using service account?how service account is configured to run as service account? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 10:07:39
|
| it should be other way around. scehduled job is configured to use service sccount. you've that option to select service account when you create job through wizard------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 10:17:53
|
| No I don't have that option but i have seen a scheduled job running under service account |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 10:21:08
|
| Sorry wrongly posted the previous one.with out giving that option how job will run? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 10:26:34
|
| you can use a proxy account you created instead for running the job too instead of mapping to default service sccount------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2012-07-16 : 10:30:58
|
| How to map a job to run under default service account? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-16 : 11:27:20
|
| Have a look at create job wizard on sql server agent and you can see for yourself in create job step page under Run as option dropdown------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Service account