Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 31, 2012 05:48 AM by caligeesey
Dec 31, 2012 05:08 AM|LINK
exec master..xp_cmdshell 'D:\Outosms\tester.exe'.
it is not working
3. i have also used the following code to run it inside asp.net/vb.net code
Dim myProcess As New System.Diagnostics.Process
Dim myInfo As New System.Diagnostics.ProcessStartInfo
myInfo.FileName = Server.MapPath("OutoSMS\Release\Tester.exe")
myInfo.RedirectStandardOutput = True
myInfo.UseShellExecute = False
myProcess.StartInfo.CreateNoWindow = False
myProcess = System.Diagnostics.Process.Start(myInfo)
but unforgunately none of both step3 and 4 solutions solved my problem that is why i am requesting urgent help if there is any help.
Dec 31, 2012 05:15 AM|LINK
for xp_cmdshell to work in sql server, u will need to put the exe on database server system's (not local) path... that means, if sql server is remote machine, then u have to put exe on d:\ drive of sql server system
also, the vb.net code u r using to run the seprate process (.exe) has the myProcess.Start() method commented
hope this helps...
Dec 31, 2012 05:17 AM|LINK
Try to connect database with windows authentication and user must have permission to run exe file. Generally you can run xp_cmdshell with Local box administrator account. Assuming sql server and exe file on same box.
Dec 31, 2012 05:48 AM|LINK
i have did whatever related to authentications but nothing has changed.