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" <be*****@hotmail.comwrote in message
news:On**************@TK2MSFTNGP06.phx.gbl...

>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

[mike]

Hi,

running in SQL QA as sysadmin

"vbnetdev" <ad***@kjmsolutions.comwrote in message
news:Ov**************@TK2MSFTNGP06.phx.gbl...

verify account it is running under has permissions to perform this
operation.
"mike" <be*****@hotmail.comwrote in message
news:On**************@TK2MSFTNGP06.phx.gbl...

>>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

[aaron.kempf]

WTF are you trying to do?

send mail? make an appointment?

using the outlook object model is just ridiculous I think

-Aaron
mike wrote:

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

[David Browne]

"mike" <be*****@hotmail.comwrote in message
news:#6**************@TK2MSFTNGP03.phx.gbl...

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]

"mike" <be*****@hotmail.comwrote in
news:On**************@TK2MSFTNGP06.phx.gbl:

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