it's active directory user

yes user I am trying does have login credential has rights to other domain server.

We have jobs that run get text files or drop text files over the server and those fail. even if I have sa.

How do you create these triggers? and add alert to that trigger?

Thanks

somehow the port is not 1433 that it is listening to

Got the probelm solved i needed to openup the sql browser port

Do you have data mirroring? one sql server mirrors data on primary server.

When I click on advanced tab under SQL Server Integration Service Package it shows No options for this command type

under Step ID it shows 0 and that is message it shows.

Yes they are open to firewall

It's the same error that I posted in the question. Using Remote Login.

I checked Fire wall, It's not that Issue either.

Do you have SQL database installed on machine?

Here is my function and stored procedure

Create Function getCalcvalue

(@Param1 as integer,

@Param2 as integer ) returns integer

Begin

declare @setVal as integer

-- select techVal from Pt101Tbl where col1 = @param1 and col3 =...

Found a solution provder ->MSDASQL->allow inProcess

Thank you. I am looking into it. And trying to figure how to run vb and powershell scripts from command prompt. As I am new to powershell script.

I am learning...

I also found other way to display report in PDF

Dim ReportDisp As Byte()

ReportDisp= ReportViewer1.ServerReport.Render("PDF", Nothing, Nothing, Nothing, "Pdf", Nothing, Nothing)

Works really nice it displays directly in PDF and user...