Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO
I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO

I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO

I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Open File - Security Warning

The publisher could not be verified. Are you sure you want to run this software?
This is my first SSIS package and the first for my employer. Under DTS we run some overnight tasks that bin with a .Net console application that downloads data. Several of these run in parallel.

Looked to me that the Execute Process Task was a good fit for the requirements. When I executed the step, the program did begin to execute in that a DOS window opened. But when, I clicked the run button on the warning dialog, the task step ended.

Questions:
1.- How to tell the Execute Process Task not to open the Security Warning dialog?
2.- Have you any suggestions about my approach?

Thanks,
IanO
I am having a very similar issue actually. Any solution will be highly appreciated. I have even tried setting up the group policy and set the batch files/exe file extension to low risk, but that has not helped much either :(|||

Still trying to get past this error! Does anyone have a way to set this up so that the package doesn't ask if we really want to run this program?

Any help would be appreciated,

Dave

|||And what happens when the .Net console application is run from the command line without using SSIS?|||

I have seen this occur also, but only when being run from a network path such as \\myserver.mydomain.slacker.net\f$\MyBatchFile.bat. I found info stating this was because it is being run within the Internet Zone security. (This is because anything with a "." in the name becomes Internet Zone by default - no joke). Had luck changing it to a netbios name like \\myserver\f$\MyBatchFile.bat. I am not saying this is a complete solution but something to consider if you are running from a network path.

On a separate note, if your command line application is a .NET executable it may also need rights assigned via CASPOL (or the Microsoft .NET Framework Configuration Tool) to have enough access to resources.

-David R. K. DeLoveh

|||

It's an attribute of the file. Right click on the file you trying to run, got to properties, click on the Unlock button at the bottom of the dialog.

If you cannot see the unlock button, then this is not the problem

Had the exact same issue a while back.

Only see my local server in my parter server list

Hello,
I'm trying to enable Subscribers to synchronize with alternate publisher,
I go to the properties of the publication and then to sync partners, then I
enable the Allow Subscribers to synchronize with other partners than the
Publisher from which the subscription was created, but the only server that
I see is my local server. Do I have to do something else in order to make
my two SQL servers partners?
Thank you very much in advance,
Marlene A. Roman
Register the other server in Enterprise Manager.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||you also have to run sp_addmergealternatepublisher on your subscriber and
configure your merge publication to allow synchronization with alternate
sync partners by setting @.allow_synctoalternate to true on
sp_addmergepublication.
"Michael Hotek" <mhotek@.nomail.com> wrote in message
news:uG5KSPmLEHA.4052@.TK2MSFTNGP11.phx.gbl...
> Register the other server in Enterprise Manager.
> --
> Mike
> Principal Mentor
> Solid Quality Learning
> "More than just Training"
> SQL Server MVP
> http://www.solidqualitylearning.com
> http://www.mssqlserver.com
>