sql server - SQLServer 2008R2 Replication, Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied -


i trying create replica of database running on server act publisher following configuration:
windows server 2008
microsoft sql server r2
subscriber windows server 2008 sql server 2014
according page:
https://docs.microsoft.com/en-us/sql/relational-databases/replication/deprecated-features-in-sql-server-replication
should not problem.
followed instructions on tutorial microsoft: https://docs.microsoft.com/en-us/sql/relational-databases/replication/replication-tutorials
setup replication. did not run error or issue until lesson 2 of tutorial
view synchronization status of subscription. synchronization status window shows several scripts runs fine , error message appears following text:

replication-replication distribution subsystem: agent org-database-data-passdatatrans-org-test-7 failed. ad hoc access ole db provider 'microsoft.jet.oledb.4.0' has been denied. must access provider through linked server.

the error happening on job automatically created when create subscription.
have tried solution found in page:
https://support.microsoft.com/en-ca/help/327489/how-to-use-the-disallowadhocaccess-setting-to-control-access-to-linked

there several other pages on internet suggest same solution. have tried setting disallowadhocaccess=0 on registry providers available on publisher on subscriber no avail.
have tried creating subscription ssms on subscriber server, connecting publisher same result. since both server 64 bits , sql server on both machines 64 bits , taking account microsoft jet oledb 4 deprecated microsoft x64, find odd jet oledb4 being used job.
misleading error message?
i've tried installing ace x64: microsoft access database engine 2010 redistributable , delete , recreate subscription keeps trying use jet oledb.
on how solve issue appreciated.
thanks.


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more