check with your exchange server team, is it allowed to use SMTP server to send mail from your server IP.

Yes I have configured the same package to run from sql agent.

It was executing successfully before last two days.

Create new SQL Server Login and map that login to your required database.

After mapping you need to assign db_datareader role to user.

Thanks Koen Verbeeck,

I just re-entered the passwords into connection manager.

That's really work for me.

Thanks for your all prompt reply. 🙂

Thanks Koen Verbeeck for your reply and

Thanks SQLCJ for your helpful link.

Now I have changed protection level of package to "EncryptSensitiveWithPassword"

It is working fine on some of my packages, but...

Hi,

thanks for your prompt reply,

I have used "EncryptSensitiveWithUserKey" as protection level

Hi Lowell,

It is giving me following error,

TITLE: Microsoft SQL Server Management Studio

------------------------------

The linked server has been updated but failed a connection test. Do you want to edit the linked server...

Thanks for your reply,

My issue got solved ,I just updated my host file from drives\etc folder,

I added IP address and host name into the file in both server. :-):-):-)

I have one server in domain and another is in workgroup.

The one which is in Domain on that server i am executing the query and the procedure is on server...

I tried it like

Inser into #tmp

Exec linkedserver.db.dbo.mysp

Then it is giving me error but when I directly run following statement then it gives me output

linkedserver.db.dbo.mysp

No it is not.

I have also tried to execute other sp using same linked server but it is giving me same error.

Hi,

I have tried it like setting first recovery option for service --> run program

and there I have specified file location for windows task to send mail.

But it is asking...

Hi Matthew,

I have tried this but it is giving me error.

Thanks for your reply ,:-)

Thanks for your reply it worked on sql server 2008, but

on sql server 2005 it is giving me following error

Msg 195, Level 15, State 10, Line 4

'CONNECTIONPROPERTY' is not a...