vb.net app error when running in master..xp_cmdshell

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I created a VB.NET app that uses Outlook's COM object.

I get an error when I run master..xp_cmdshell 'myprogram.exe' in SQL query
analyzer.



The error occurs on this line "oOutlook = New Outlook.Application"



Unhandled Exception: System.Runtime.InteropServices.COMException
(0x80080005):



Server execution failed at WindowsApplication3.Main.ProcessInbox(String
FolderName, String WhichFolder, String DateTimePicker1) in C:\Documents and
Settings\user1\My Documents\Visual Studio
Projects\WindowsApplication3\Main.vb:line 80

at WindowsApplication3.Main.main() in C:\Documents and Settings\user1\My
Documents\Visual Studio Projects\WindowsApplication3\Main.vb:line 20
 
WTF are you trying to do?

send mail? make an appointment?

using the outlook object model is just ridiculous I think

-Aaron
 
mike said:
Hi,

running in SQL QA as sysadmin
Click to expand...

sysadmin is a SQL Server Server Role. xp_cmdshell spawns processes using
the windows identity of the service account. That's the relevant security
principal to check.

David
 
Back
Top