| Author |
Topic |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2006-07-07 : 12:51:13
|
| Hello Experts, I am connecting to the SQL server as a client.I am executing few jobs.I do not have the Permission to the Windows server on which SQL server is installed.Just having the permissions to the SQL Server.How can I get the SQL Agent Service Account through Management Studio?I don't have the permissions to see the MMC.Thanks!Raju |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-07 : 13:05:13
|
| Not sure what you want to do. Find out what the account is?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-07-07 : 13:08:42
|
| Right..just to find out what the account is? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-07 : 13:12:48
|
| What can you do?It sounds like you can only run queries and start jobs?Can you create jobs? Can you run xp_cmdshell?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-07-07 : 13:17:13
|
| Yeah..I can run xp_cmdshell...I can create the jobs also. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-07 : 13:22:57
|
| Does xp_cmdshell run under the sql server service account? You will probably find you can do whatever you wish if it does using osql.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-07-07 : 13:33:40
|
| xp_cmdshell is running under the sql service account.i am not sure what account the agent runs.I donno how to find out what account the agent runs using the osql or T-SQL.Thanks a lot for your quick response.Thanks!Raju |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-07 : 13:54:48
|
| It's probably easier to just ask the DBA who administers the system this question.CODO ERGO SUM |
|
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-07-07 : 14:27:29
|
| Thanks..Finally I asked the System Administrator to get the SQL Agent Service Account.Still I would like to know how to find out through Management Studio or OSQL..If any one knows how to do that,That would be great.Thanks!Raju |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-07-07 : 14:50:08
|
| [code]-- In SQL 2000select nt_domain, nt_username, loginamefrom master.dbo.sysprocesseswhere program_name like 'SQLAgent%'[/code]CODO ERGO SUM |
|
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-07-07 : 16:34:52
|
| Thanks!Raju |
|
|
|
|
SQL Agent Service Account