sql server - How can we overcome double authentication for sp_linkedserver? (Already set up through DB authentication) -

-

so we've set sp_linkedserver on sql server connect remote access database.

assume path database w:/breakfast/pancakes/secretpancakes/pancakedb.accdb

we know username , password actual database

password: ally0urpancakearebelongtous!

the problem is, there authentication "secretpancakes" directory.

this authentication is

username: superchef

password: ilovesf00d

here code making sp_linkedserver...

/****** object: linkedserver [pancakedb] script date: 06/13/2012 10:08:21 ******/ exec master.dbo.sp_addlinkedserver @server = n'pancakedb', @srvproduct=n'access 2007', @provider=n'microsoft.ace.oledb.12.0', @datasrc=n'w:/breakfast/pancakes/secretpancakes/pancakedb.accdb ', @provstr=n';pwd=ally0urpancakearebelongtous' /* security reasons linked server remote logins password changed ######## */ exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname=n'pancakedb',@useself=n'false',@locallogin=null,@rmtuser=null,@rmtpassword=null

the rmtuser , rmtpassword database though correct? thing is, if go on actual computer , open protected directory (secretpancakes) , ask windows remember credentials, it'll work fine on computer, not on others'.

i'm trying fix don't have objnetwork.mapnetworkdrive(driveletter, remotepath, false, userid, userpwd) thing, pain. (objnetwork = microsoft.visualbasic.createobject("wscript.network"))

so question is: how pass along credentials folder access within linkedserver?

update: screen shot may help...? enter image description here

also, change these credentials credentials used folder right? enter image description here

the sql server service account needs have access folder access file is, should work. said, user name , password access db have nothing whether or not has permissions on file system.

ideally, should not use drive letters here , use unc path instead, avoid drive mapping issue. way allow sql server read file make sure has appropriate share , ntfs permissions so.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more