Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dinesh
Starting Member
10 Posts |
 Posted - 2004-10-18 : 14:16:23
|
| I'm trying to execute a Ms-DOS Batch file with XP_CMDSHELL with non System login ID. I'm getting the following errorCould you please suggest me way to overcome this errorMsg 50001, Level 1, State 50001xpsql.cpp: Error 997 from GetProxyAccount on line 472.Din |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-18 : 16:27:18
|
| Open up SQL Server Books Online. Go to Index tab. Type in xp_cmdshell, hit enter. Take a look at the section about the proxy account. Also see the permissions section.Tara |
 |
|
|
Dinesh
Starting Member
10 Posts |
Posted - 2004-10-19 : 08:17:12
|
quote:
Originally posted by tduggan
Open up SQL Server Books Online. Go to Index tab. Type in xp_cmdshell, hit enter. Take a look at the section about the proxy account. Also see the permissions section.Tara
Thanks Tara!!!I apologize, that my question was wrong, I'm unclear about the Proxy account, why SQL server is not using login details, which was used to start SQL Agent service.It is an thought, is it wrong?I will greatly appreciate your comments in this regardDin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-19 : 12:19:35
|
| You must not have sysadmin on the database server. You need to use the proxy account when this is the case.Tara |
|
|
|
|
|
|
XP_Cmdshell