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

[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

 

[vbnetdev]

verify account it is running under has permissions to perform this
operation.

 

[mike]

Hi,

running in SQL QA as sysadmin

verify account it is running under has permissions to perform this
operation.

 

[aaron.kempf]

WTF are you trying to do?

send mail? make an appointment?

using the outlook object model is just ridiculous I think

-Aaron

 

[David Browne]

Hi,

running in SQL QA as sysadmin

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

 

[Dan Mitchell]

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.

I don't know enough about SQL server to be sure here, but is this trying
to run Outlook from the SQL server process itself? If so, then you
probably can't do it:

http://support.microsoft.com/kb/237913/en-us

-- dan