It turned out I setup the email account correctly.  The issue was making the profile public.

I found this code provided by microsoft.  It did the job.

EXECUTE msdb.dbo.sysmail_add_profile_sp ...

• This reply was modified 4 years, 8 months ago by  Steve Jones - SSC Editor. Reason: code formatting

I did post this on the vendor blog.   They stopping offering technical support for ws-ftp pro and are forcing us to use their user community.   This is more than annoying. ...

I took a look at mapping drives and granting service account permissions.     I use the default service accounts.  After years mucking around with creating custom domain accounts, I've gotten...

Thanks Jeffrey.  You idea also has Merit.     I'll do some homework.

I like your idea.     Are you saying run the backup on the original server and store it on the new one using a mapped drive?

we fixed this.   After leaving the Domain and rejoining, the problem went away.     Further!

I gave up on Bulk Insert.   Used the SQL Import function.   In a few hours, my life was fulfilled once again.    My camper is happy.

I have tried mapped drives and the full unc path.   Life continues to be unkind.   I am considering trying BCP after my root canal without nova Caine.

I installed the driver on a Windows 10 and windows  7 pc.  It blew up with a typically cryptic error message.

Good to know but it is not supported on current windows server releases.

Thanks.  I'll do some research

It appears the firewall is off.  The browser service is not running.   Should it be activated?
After I tried all this, I used .\sqlexpress for the server name.  It worked!   ...

I contacted SAP.  They said this error happened because our maintenance agreement had expired.   So to use a test environment for our SQl Server migration, we have to pay.
The...

it is definitely the same server.   I'm also certain the service is running.  Since both sql and integrated security failed, I'll check the server address.
Thanks.

Here are some details.  In our SQL 2008 installation we have 2 relatively simple DTS tasks that extract data from 2 tables, convert all the extracted data to strings and...