calling vbscript from xp_cmdshell

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

calling vbscript from xp_cmdshell

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-23 : 09:03:45

Tom writes "I'm trying to call vbscript from sql1 via:
exec master..xp_cmdshell "c:/test/file.vbs",no_output
but that hangs.
if I try
exec master..xp_cmdshell "c:/test/file.cmd"
where file.cmd is
cscript //B c:/test/file.vbs,no_output
I get
c:/test>cscript //B c:/test/file.vbs
CScript Error: Loading your settings failed.: Access is
denied.(0x80070005)
These commands run fine from the command line on the SQL7
server where the logged in user used is the same as that for xp_cmdshell
c: cscript //B c:/test/file.vbs
runs fine!!
Any ideas how to do this?
Tom"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources