deployment - Error code 40 when running SSRS reports from Internet Explorer (run as administrator) -

-

we deployed vb.net application on customer's computer contains ssrs reports.

the application connects sql server database in app without problems. installed sql server data tools deploy reports (rdl) , data source (rdl) files report server. these deploy without problems.

in sql server data tools can "preview" reports without problems well.

we run problem when attempting view report internet explorer (run administrator).

we following error:

cannot create connection data source 'datasourcereports'  (this name used targetdatasourcefolder)  error:40 - not open connection sql server

we same error when app deployed runs reports.

please let know not set correctly on sql server side.

a possibility experiencing double hop authentication problem. it's not clear explanation, sql server database on separate server report server? if so, credentials allow connect report server windows integrated security not pass credentials on sql server database if using ntlm on report server. report server tries use kerberos on network authenticate way of ticketing sql server database, must have configured correctly on network. see article if want use kerberos: http://technet.microsoft.com/en-us/library/ff679930(v=sql.100).aspx.

another (easier) solution open data source on report server , change authentication use stored credentials. make sure credentials use have read permission on sql server database. downside of approach cannot use row-level security in report user unless design report capture user information , set query or filter on dataset restrict data user. if that's not concern, stored credentials easy set , maintain - , you're going have anyway if want use caching, snapshots, or subscriptions. more information on stored credentials, see http://msdn.microsoft.com/en-us/library/ms159736.aspx.


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