Weekly updating of Database on DiscountASP.Net

I have a hosted site here as well as a 2005 hosted SQL Database.

I also have a local SQL 2005 database that hosts some of the dynamic data that needs to update the DiscountAPS.Net database on a scheduled basis.

Before 11/2008 I was able to schedule an SQL Job that did this, but now I am getting Link Errors like the following:

OLE DB provider "SQLNCLI" for linked server "sql2k503.discountasp.net" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 7344, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "sql2k503.discountasp.net" could not INSERT INTO table "[sql2k503.discountasp.net].[SQL2005_246081_eteams].[dbo].[CustomerStaging]" because of column "CustomerID". The user did not have permission to write to the column.

This happened via a linkedserver. I can still use the linkedServer to see data, but the inserts / updates are not working.

Is this still possible to do?

Is there any documentation on doing this specifically with DiscountASP.net?

Thanks,

Rog

 

Since it is a permissions issue, did you try and explicitly assign the user permission to perform the INSERT? i.e.

USE MyDB;
GRANT INSERT ON MyTable TO MyUser; --OR
GRANT INSERT ON MyTable TO MyRole;
GO

If this is failing when running as a local SQL Agent scheduled job, the user account in use by the SQL script / job is probably the user account that SQL Agent service uses.