DPE Error on Report Server

We have created a DPE that returns data from a Web Services and uses it as
the datasource in the reports. We have changed the config files and added
the code group also added the name to the data section of the
rsreportserver.config file. We have strong named the dll and added it to the
GAC. The report runs fine in debug designer mode but will not run through
the report server or report manager. We get the following error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
An attempt has been made to use a data extension 'ISIS WS Data' that is not
registered for this report server. (rsDataExtensionNotFound) Get Online HelpCheck the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We have created a DPE that returns data from a Web Services and uses it as
> the datasource in the reports. We have changed the config files and added
> the code group also added the name to the data section of the
> rsreportserver.config file. We have strong named the dll and added it to the
> GAC. The report runs fine in debug designer mode but will not run through
> the report server or report manager. We get the following error.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> An attempt has been made to use a data extension 'ISIS WS Data' that is not
> registered for this report server. (rsDataExtensionNotFound) Get Online Help
>|||I did all that I'm now getting a 401 unauthorized error.
"Jerry" wrote:
> Check the documentation about how to deploy a similar DPE.
> [WebService Data Processing Extension]
> http://www.rdlcomponents.com/DTE/default.aspx
> Thanks
> Jerry
> "Deb Taylor" wrote:
> > We have created a DPE that returns data from a Web Services and uses it as
> > the datasource in the reports. We have changed the config files and added
> > the code group also added the name to the data section of the
> > rsreportserver.config file. We have strong named the dll and added it to the
> > GAC. The report runs fine in debug designer mode but will not run through
> > the report server or report manager. We get the following error.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> >|||Generally this error message means you need to log on (enter a valid user ID
and password) somewhere first. If you have just entered these and then
immediately see a 401 error, it means that one or both of your user ID and
password were invalid for whatever reason (entered incorrectly, user ID
suspended etc.).
Jerry
--
[Call a WebService from SQL Server 2000]
www.rdlcomponents.com
"Deb Taylor" wrote:
> I did all that I'm now getting a 401 unauthorized error.
> "Jerry" wrote:
> > Check the documentation about how to deploy a similar DPE.
> >
> > [WebService Data Processing Extension]
> > http://www.rdlcomponents.com/DTE/default.aspx
> >
> > Thanks
> > Jerry
> >
> > "Deb Taylor" wrote:
> >
> > > We have created a DPE that returns data from a Web Services and uses it as
> > > the datasource in the reports. We have changed the config files and added
> > > the code group also added the name to the data section of the
> > > rsreportserver.config file. We have strong named the dll and added it to the
> > > GAC. The report runs fine in debug designer mode but will not run through
> > > the report server or report manager. We get the following error.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> > >

Domain user can't hit SQL Server

Hello,
I have a user on Windows 2000 running an application written in VB.net
that uses a config file with a connection string to hit a SQL 2000 DB
running on a Windows 2000 Server box. The connection string looks
something like this:
Provider=SQLOLEDB;Server=MyServer;Databa
se=MYDB;Persist Security
Info=False;User Id=shipio;
When the user tries to perform a task that requires a DB connection, a
message pops up saying that Domain\UserAccount does not have permissions
to access the SQL server. However, there is a sql server username and
password in the connection string. Why doesn't it user it?
The application works fine when it's installed on Win XP PCs, but it
doesn't work on a win 2000 PC. Does Win2000 have a different need for
connection strings? Or does it by default send the domain account to
the sql server?
Any thoughts are greatly appreciated.
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Connection strings that pass a username are for Standard SQL
Authentication. Not Windows Authentication.
Check the Authentication Mode of SQL. It appears to be set to Windows Auth
only. I you intend on using Standard SQL Security, then your
Server settings for SQL need to be changed to allow both.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||This is actually only a problem on the Windows 2000 pc. The sql server
is set up for windows and sql server authentication. We have 20 other
users on Windows XP where this works fine. It's just the 2000 box that
gets the error.
Does the connection string maybe need some additional properties for it
to work on 2000?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Try connecting from the Windows 2000 client using Query Analyser or OSQL
with a Trusted Connection.
OSQL -SserverNameHere -E -Q"Select @.@.version"
Do you receive the same error?
Try using Standard Security.
OSQL -SserverNameHere -Uuserid -Ppassword -Q"Select @.@.version"
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Does the rsreportserver.config file update in realtime?

for example, if i was to change my smtp server within the rsreportserver.config file, does it automatically update in realtime the second i save it or do i need to refresh something?

any insight on this would be grateful before i do anything.

thanks!

No. When you save the config file the server will automatically restarts itself.

|||

Teo Lachev wrote:

No. When you save the config file the server will automatically restarts itself.

so just to clarify before i start editing the xml file, if i change any value and save the xml file, the reporting server will restart itself?

so basically after saving, i just need to wait a couple of minutes for the changes to take effect once the server restarts?|||No need to wait. As you would see the first request after the config change will take much longer because the server needs to initialize itself.