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

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

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


"mike" <bethere@hotmail.com> wrote in message
news:On9oBZxHHHA.1264@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
>
>
>
>

Hi,

running in SQL QA as sysadmin

"vbnetdev" <admin@kjmsolutions.com> wrote in message
news:OvdTzCyHHHA.1008@TK2MSFTNGP06.phx.gbl...
> verify account it is running under has permissions to perform this
> operation.
>
>
> "mike" <bethere@hotmail.com> wrote in message
> news:On9oBZxHHHA.1264@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
>>
>>
>>
>>
>
>

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

"mike" <bethere@hotmail.com> wrote in message
news:#67tZMyHHHA.4760@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

"mike" <bethere@hotmail.com> wrote in
news:On9oBZxHHHA.1264@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