Deploying a database to multiple servers - smooth sailing?

Hello,
I need to copy a database to multiple servers, all of this using SQL Server
2000. -- this will enable the testing of an application with identical
databases. I'm concerned here with the original installation of the database
on the target servers and subsequent updates using restoration of the
database from the master server
I'm contemplating having the master database on one server and using data
management objects to make a database backup on that machine. That backed-up
database would be placed in a share with some scripts that would perform the
restore on the target servers - to be initiated by the users.
This works well on my master server but can I expect a smooth distribution
using this approach or is there a better approach. I like this method as
it's simple. The target servers will all be SQL Server 2000, possibly with
different service patches. The target servers would has the same local
administrators account.
Is there anything internal to the back up or the target server that would
prevent this operation? There's no dependencies such as a database can only
be restored to a server it was backed up on, is there?
TIA,
Rod> This works well on my master server but can I expect a smooth distribution
> using this approach or is there a better approach. I like this method as
> it's simple. The target servers will all be SQL Server 2000, possibly
> with
> different service patches. The target servers would has the same local
> administrators account.
Your servers should all be at the same patch level. Occassionally, there
are differences in the structure of the backup that are not backward
compatible.
> Is there anything internal to the back up or the target server that would
> prevent this operation? There's no dependencies such as a database can
> only
> be restored to a server it was backed up on, is there?
No.|||Thank you
"Scott Morris" wrote:
> > This works well on my master server but can I expect a smooth distribution
> > using this approach or is there a better approach. I like this method as
> > it's simple. The target servers will all be SQL Server 2000, possibly
> > with
> > different service patches. The target servers would has the same local
> > administrators account.
> Your servers should all be at the same patch level. Occassionally, there
> are differences in the structure of the backup that are not backward
> compatible.
> > Is there anything internal to the back up or the target server that would
> > prevent this operation? There's no dependencies such as a database can
> > only
> > be restored to a server it was backed up on, is there?
> No.
>
>

Deploying a database to multiple servers - smooth sailing?

Hello,
I need to copy a database to multiple servers, all of this using SQL Server
2000. -- this will enable the testing of an application with identical
databases. I'm concerned here with the original installation of the databas
e
on the target servers and subsequent updates using restoration of the
database from the master server
I'm contemplating having the master database on one server and using data
management objects to make a database backup on that machine. That backed-u
p
database would be placed in a share with some scripts that would perform the
restore on the target servers - to be initiated by the users.
This works well on my master server but can I expect a smooth distribution
using this approach or is there a better approach. I like this method as
it's simple. The target servers will all be SQL Server 2000, possibly with
different service patches. The target servers would has the same local
administrators account.
Is there anything internal to the back up or the target server that would
prevent this operation? There's no dependencies such as a database can only
be restored to a server it was backed up on, is there?
TIA,
Rod> This works well on my master server but can I expect a smooth distribution
> using this approach or is there a better approach. I like this method as
> it's simple. The target servers will all be SQL Server 2000, possibly
> with
> different service patches. The target servers would has the same local
> administrators account.
Your servers should all be at the same patch level. Occassionally, there
are differences in the structure of the backup that are not backward
compatible.

> Is there anything internal to the back up or the target server that would
> prevent this operation? There's no dependencies such as a database can
> only
> be restored to a server it was backed up on, is there?
No.|||Thank you
"Scott Morris" wrote:

> Your servers should all be at the same patch level. Occassionally, there
> are differences in the structure of the backup that are not backward
> compatible.
>
> No.
>
>

deploying a database

Hi, do you know how to deploy a database (along with all the tables and data
in them etc.) from a development machine to the target machine? Can I just
copy the dabase file? (Assume the SQLServer application is already
installed on the target machine)
Thanks!Backup/restore,
Detach/Attach.
Either should work just fine
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!

deploying a database

what is the easiest way to deploy a database for a webapp? i have create table scripts but waht is the easiest way to go about inserting data into lookup tables? would i have to write insert statements or is there some other way to do it

I use two different methods when I create lookup tables.

1) Manually type into the table the data

2) Create a script file which I run in query analyzer. Here is a sample of one the scripts I write:

create table [tbl_LookupCategory]

([int_CategoryID] int NOT NULL Primary Key,
[str_Category] nvarchar(20) Not NULL)

/* Insert the data into the table */

INSERT INTO [tbl_LookupCategory]
( [int_CategoryID],
[str_Category]
)

VALUES
( 1, 'Shirt' )

INSERT INTO [tbl_LookupCategory]
( [int_CategoryID],
[str_Category]
)
VALUES
( 2, 'Hat' )

|||

You can also use copy database wizard to copy your database to other servers.

deploying a database

Hi, do you know how to deploy a database (along with all the tables and data
in them etc.) from a development machine to the target machine? Can I just
copy the dabase file? (Assume the SQLServer application is already
installed on the target machine)
Thanks!
Backup/restore,
Detach/Attach.
Either should work just fine
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!
|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Ido" <Ido@.discussions.microsoft.com> wrote in message
news:29EA6106-1D43-4B19-89F5-B2A438DA6B8F@.microsoft.com...
> Hi, do you know how to deploy a database (along with all the tables and
> data
> in them etc.) from a development machine to the target machine? Can I just
> copy the dabase file? (Assume the SQLServer application is already
> installed on the target machine)
> Thanks!

Deploying a Database

Hi,
I am creating an application that will use msde, and I would like to know
how to create a sql server in the server application in a straight forward
way to the final user?
any tutorials are appreciated
Thanks in advance
hi Diogo,
Diogo Alves - Software Developer wrote:
> Hi,
> I am creating an application that will use msde, and I would like to
> know how to create a sql server in the server application in a
> straight forward way to the final user?
>
as regard the engine distribution, you can perhaps have a look at
http://www.microsoft.com/downloads/d...displaylang=en ,
a toolkit by Microsoft I'm not confortable with, as I usually use a
companion home built application that provides a visual interface to the
standard MSDE setup.exe boostrap installer, where all desired parameters can
be visually edited by the end user, then "shelling" to the actual installer
providing all parameters...
as regard database deployment, you can have a look at
http://msdn.microsoft.com/msdnmag/is...aseinstaller/, the
best article I know about that stuff, supporting versioning, updates and the
like..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Deploying .Net / SQL Server 2005 replication

Hi,

I am experiencing a problem with deployment of a VB .Net application which carries out merge replication, and would greatly appreciate any assistance. I am currently struggling to find stuff about my problem on the net, which probably means either (a) I'm missing something really simple or (b) I shouldn't be trying to do this in the first place. :)

The story so far:
1. I added the SQLMergXLib.dll COM to my Visual Studio project, allowing me access to SQL Server merge replication functionality from my code, and wrote a procedure for synchronising a given pull subscription. This worked beautifully and with minimal fuss.
2. I tried to deploy the project to a different machine. I received an error to the effect of, "Couldn't create object, it's a COM object and it's not registered correctly." I have encountered this problem a few times before when trying to use Interop, so I called myself a few names, went back to the deployment project, and specified that the object should be registered. Still no joy. I tried this a couple of different ways round but then...
3. ...found an article on MSDN suggesting that I should consider using the managed Microsoft.SqlServer.Replication, Microsoft.SqlServer.Management, Microsoft.SqlServer.RMO interfaces instead. I reasoned that this would eliminate the registry issue altogether as everything would become native to the .Net framework, and this seemed infinitely preferable anyway, so I promptly substituted the SQLMergX DLL for these, rehashing my code to match. Again, this built and ran OK on my development machine.
4. I tried to deploy the project to a different machine. I received the following error: "Could not load file or assembly 'Microsoft.SqlServer.Replication, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect."

Now it's worth pointing out that I think I know what the problem might be here: No SQL Server of any kind is installed on the target machine. However, SQL Server is not required to deploy standard database solutions in .Net, and I am hoping this is also true with the Microsoft.SqlServer... namespaces, as it is a requirement that the subscription database can be located anywhere (not necessarily the target machine), and therefore that SQL Server need not be present on the target machine. However, if this is simply impossible, please let me know so that I can look at other alternatives.

Other than that, I don't mind what method I use to get the synchronisation working as long as it works (I've been at this a good few days now...), so if anyone has done this before and can offer any assistance (any registering/files I need to include etc, I am hoping it is something that simple), it would be appreciated.

Thanks,

Steve.

Hi, Steve,

You may find following SQL Server 2005 Books online topic helpful to your case:

Requirements for Deploying Replication ActiveX Controls

When deploying the Microsoft ActiveX replication controls independently of Microsoft SQL Server 2005, you must include additional files in the installation kit that you use to distribute your application. If you deploy your application using these ActiveX replication controls on a computer where Microsoft SQL Server 2005 Express Edition or SQL Server 2005 client software is also installed, these files will already be present.

This topic describes how to deploy native code applications that use the replication ActiveX controls to access SQL Server 2005 functionalities. To obtain all of the benefits provided by the Microsoft .NET Framework, you should consider updating native code applications to managed code using Microsoft Visual Studio 2005. From managed code applications, you can access the same replication ActiveX functionality using classes in the Microsoft.SqlServer.Replication namespace.

If you use Microsoft Visual Studio and the Deployment Wizard to prepare your installation kit, the wizard will recognize that the files from the Referenced Libraries column in the following table are needed, and will include them in the installation kit. The wizard will also indicate that dependency information for these files is not available. Include the files from the Dependent Libraries column of the table in your installation kit (click the Add button on the Included Files page of the wizard). The paths shown in this table assume SQL Server 2005 was installed to the default location.

Replication Control Referenced Libraries Dependent Libraries

Microsoft SQL Distribution Control 9.0

Sqldistx.dll

Replerrx.dll

C:\Program Files\Microsoft SQL Server\90\COM\Rdistcom.dll

C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL.1\Binn\Sqlrepss.dll

$(WinSysPath)\Sqlwoa.dll

|||

Thank-you for your response.

I had followed this article with regard to the ActiveX deployment and experienced the problem discussed above. Does anyone know if there are any articles describing the requirements of this further?

The article also implies that moving over to managed code provides the same functionality but with less fuss, so I would rather do it this way if at all possible. The files Visual Studio included when deploying my implementation (which required access to the SynchronizationAgent, MergePullSubscription and ConnectionInfo classes, I think) were:

Microsoft.SqlServer.BatchParser.dll
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.RegSvrEnum.dll
Microsoft.SqlServer.Replication.dll
Microsoft.SqlServer.Rmo.dll
Microsoft.SqlServer.ServiceBrokerEnum.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SmoEnum.dll
Microsoft.SqlServer.SqlEnum.dll
Microsoft.SqlServer.WmiEnum.dll

Are there other files I need to include with any of these for their classes to work correctly?

Thanks in advance for any help, still struggling with this a bit. :)

Steve.

|||

Hi, Steve,

I got more information from our developer where it seems the best way to deploy RMO based application is to install a SQL Server instance on the client machine (like SQL Server Express which is freely available).

Here is the quote from our developer:

We don’t really have a good story for developers who want to deploy an application based on RMO as the synchronization agents in RMO are just wrappers of the existing controls which are in turn wrappers of the agent components. As a result, anyone who wants to deploy an RMO application would need to include most of everything in 90\COM + resources\1033\replres.rll. To make matters worse, all of our components depend on sqlncli.dll and the 80 CRT which is deployed as a WinSxS component. The snapshot agent itself also depends on the SMO assemblies which are deployed in the GAC. Given the external dependencies, the simplest way to deploy an RMO application is probably to install some version of SQL Server (Express should be sufficient for most types of applications).

Hope that help,

Zhiqiang Feng

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Yeah, I spent a lot of yesterday introducing myself to the delights of DLL Hell (having begun my career as a .Net programmer, it's my first time... :)), with regards to both scenarios I described, and ultimately plumped for doing exactly what you suggest: Deploying SQL Server Express on the target machine.

I thought that it seemed excessive but it seems to be the best way forward.

Thanks for all your help,

Steve.

Deploying - credentials required

I'm stumped, i've notice a couple have had this issue on this group, have
anyone had success in solving it.
Basically when I attempt to deploy to a remote server I'm propted to login
to SRS located at http://<servername>/reports no amount of credentials
sent work.
I've checked IIS and i'm runnning both web sites with windows integeration.
Can anyone tell me what is going on?
Thanks.I am having the same issue, anyone have a solution?
Thanks,
Geoff
"Namshub" wrote:
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows integeration.
> Can anyone tell me what is going on?
> Thanks.
>
>|||I saw in another post that this was sometimes caused by sharepoint
integration. However, I am not using sharepoint, any ideas?
other thread
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=893df211-dee7-4e99-9fb4-fda8c47585fd&cat=en-us-msdn-enterprise-sqlserver&lang=en&cr=US&sloc=en-us&m=1&p=1
"Namshub" wrote:
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows integeration.
> Can anyone tell me what is going on?
> Thanks.
>
>|||Are you set up for the right role to deploy? If you can be included in the
local admin group on the server where RS resides, that will put you in the
correct role automatically.
The other point to check is sharepoint as the other poster mentioned.
Finally, I once had a weird thing that turned out to be caused by having the
server running DHCP (it was a test server) and that for some reason caused
this symptom for me. I changed it to a fixed IP address and the problem went
away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>|||Thanks for your responses, unfortunatly none of the issues relate to what my
problem is, so it looks like I have a new one.
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>|||Incdentally I had an issue with the black Preview with the reports when in
design mode (SQL 2005 sp2 caused this) after requesting the hotfix located
here
http://support.microsoft.com/kb/935356
I have installed it on my development machine, and now have no problems
uploading to the server.
HTH
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>

deploying - but where to?

Hi,
when I deploy a report - where does it go? As in, are each of the
individual reports sent to some folder somewhere, or are they bundled
into some dll or something? All I know is I've set my deploy location
to http://<machinename>/reportserver - but can't see the reports in
that folder...
Any ideas?
GearóidThey are being stored in the database used by RS. That is why you don't see
anything.
Bruce L-C
"Gearoid" <gearoid_healy@.yahoo.com> wrote in message
news:3d6ebe80.0409280203.3aaed82b@.posting.google.com...
> Hi,
> when I deploy a report - where does it go? As in, are each of the
> individual reports sent to some folder somewhere, or are they bundled
> into some dll or something? All I know is I've set my deploy location
> to http://<machinename>/reportserver - but can't see the reports in
> that folder...
> Any ideas?
> Gearóid

Deployement to a local machine

Hi,

I have developped a program with VB 2005 with a DB using sql server and I would like to know if I use this program on another computer what's the minimum requirement.

Dotnet 2.0 and sql server? But do I have to install the full sql server version or just a patch to be able to run that kind of program?

Thx in advance

I do think that to deploy a VB.NET 2005 application, the client computer must have the .NET 2.0 framework installed.

If the application will access a remote SQL Server that is all that is necessary.

If the application will require that a SQL Server be also installed, then a 'licensed' edition of SQL Server must also be installed. Depending upon the requirements, the 'free' SQL Server 2005 Express may be sufficient. Check here for information about which SQL Server edition may best fit your needs.

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
Thanks
Hi
"malek_che" wrote:

> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
ThanksHi
"malek_che" wrote:

> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Erro
r:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR
[IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Erro
r:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR
[IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
ThanksHi
"malek_che" wrote:
> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John

Deployed reports not being overwriting existing reports

Hi,
I am trying to deploy a new set of report to the Reporting server, but these
new versions of the reports do not seem to appear in the Report Manager.
There is no errors reported within VS.Net when deploying. Will it help to
either restart the web server or restart the database server in order to get
the new versions available in the manager.Make sure you are not getting errors from the deployment in VS.NET...
Ensure the deployment target location is correct.
Refresh the IE page, and ensure no page caching is occuring
Try to deploy from the Reporting Services Manager, and see if that is
working for you...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
news:0F7B9869-E10F-4C10-86A3-343EFDFA38A5@.microsoft.com...
> Hi,
> I am trying to deploy a new set of report to the Reporting server, but
these
> new versions of the reports do not seem to appear in the Report Manager.
> There is no errors reported within VS.Net when deploying. Will it help to
> either restart the web server or restart the database server in order to
get
> the new versions available in the manager.|||You can delete the reports in the Report Manager manually.
If you have the reports moved to subfolders in the report manager. They will
not be replaced. Instead they modified reports are published in the root
folder and the previous versions are remaining in the subfolder.
"Wayne Snyder" wrote:
> Make sure you are not getting errors from the deployment in VS.NET...
> Ensure the deployment target location is correct.
> Refresh the IE page, and ensure no page caching is occuring
> Try to deploy from the Reporting Services Manager, and see if that is
> working for you...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
> news:0F7B9869-E10F-4C10-86A3-343EFDFA38A5@.microsoft.com...
> > Hi,
> > I am trying to deploy a new set of report to the Reporting server, but
> these
> > new versions of the reports do not seem to appear in the Report Manager.
> > There is no errors reported within VS.Net when deploying. Will it help to
> > either restart the web server or restart the database server in order to
> get
> > the new versions available in the manager.
>
>|||On Wed, 2 Feb 2005 02:41:03 -0800, MicroMoth
<stephen.adams@.forvus.co.uk> wrote:
>Hi,
>I am trying to deploy a new set of report to the Reporting server, but these
>new versions of the reports do not seem to appear in the Report Manager.
>There is no errors reported within VS.Net when deploying. Will it help to
>either restart the web server or restart the database server in order to get
>the new versions available in the manager.
I had this problem, too, when deploying from within VS.NET. Drove me
nuts, until I simply restarted VS.NET IDE.|||Be sure to close IE and reopen it. That has always resolved seeing the most
recent version of a report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Usenet User" < @. . > wrote in message
news:bfo401tgdsaiobnseo7qt0mpuf4n24bade@.4ax.com...
> On Wed, 2 Feb 2005 02:41:03 -0800, MicroMoth
> <stephen.adams@.forvus.co.uk> wrote:
> >Hi,
> >I am trying to deploy a new set of report to the Reporting server, but
these
> >new versions of the reports do not seem to appear in the Report Manager.
> >There is no errors reported within VS.Net when deploying. Will it help to
> >either restart the web server or restart the database server in order to
get
> >the new versions available in the manager.
>
> I had this problem, too, when deploying from within VS.NET. Drove me
> nuts, until I simply restarted VS.NET IDE.

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports fail

Help!
I have created some reports in the Visual Studio client, here they work ok
and I can preview the output. But when I deploy them to the reportserver
although the client reports all is well...
Deploying data source '/IODINE Reporting Project/Projectserver'.
Deploying report '/IODINE Reporting Project/Official Milestones - Drill Down'.
Deploying report '/IODINE Reporting Project/Official Milestones - Matrix'.
Deploy complete -- 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 1 succeeded, 0 failed, 0 skipped ========== ... I can see them on the server, but when I try to run them I get...
An error has occurred during report processing.
Cannot create a connection to data source 'Projectserver'.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors
Anybody any ideas?Hi,
This might be because the data source credentials are not persisting
in the reportserver. Enter the credentials in the data source using the
report manager or set the option to persist the user name and password
by selecting "allow saving password" in the datalink screen.|||Hi Raghu,
Thanks, but we are using Windows Authentication (Integrated Security)
Cheers,
Geoff
"Raghu" wrote:
> Hi,
> This might be because the data source credentials are not persisting
> in the reportserver. Enter the credentials in the data source using the
> report manager or set the option to persist the user name and password
> by selecting "allow saving password" in the datalink screen.
>

deployed report, reverting to old report

I have since modified a deployed report by putting a pie chart on it. I run
the report on my develpoment PC and it shows fine, i deploy the new reoprt
and it is not showing the updated information. I have tried deleting the the
old report and uploading the new report, but still i get the old report
format.
I have uploaded the report to another directory and it shows the updated
report. I have tried moving the report from this directory to the directory i
want it in but still it does not show the updated format.Close(exit) IE and open up a new one.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> I have since modified a deployed report by putting a pie chart on it. I
run
> the report on my develpoment PC and it shows fine, i deploy the new reoprt
> and it is not showing the updated information. I have tried deleting the
the
> old report and uploading the new report, but still i get the old report
> format.
> I have uploaded the report to another directory and it shows the updated
> report. I have tried moving the report from this directory to the
directory i
> want it in but still it does not show the updated format.|||If using URL access you can also append the following to the URL to force RS
to render the report with session:
&rs:ClearSession=true
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OL%23OUwy9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
>> I have since modified a deployed report by putting a pie chart on it. I
> run
>> the report on my develpoment PC and it shows fine, i deploy the new
>> reoprt
>> and it is not showing the updated information. I have tried deleting the
> the
>> old report and uploading the new report, but still i get the old report
>> format.
>> I have uploaded the report to another directory and it shows the updated
>> report. I have tried moving the report from this directory to the
> directory i
>> want it in but still it does not show the updated format.
>|||thanks that worked.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>|||I get the same issue when trying to deploy from VStudio...Sometimes I have to
delete the reports and deploy 4 or 5 times before the change appears
Regards,
Dean Nero
Momentum Healthware Inc.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>

Deployed report with custom assembly fail when calling web service

Hi,
I'm developing a report that calls a web service using a custom assembly.
I've got the code working in VS.NET, but when I deploy to my local Report
Server, I get this:
System.Security.SecurityException: Request for the permission of type
System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed
I have added the following to RSReportServer.config:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execute"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
In rssrvpolicy.config, I have changed the PermissionSet for
Report_Expressions_Default_Permissions to FullTrust and added the following:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="ReportServer-cmcs.msrs.webserviceclient"
Description="Codegroup generated by the .NET
Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program
Files/Microsoft SQL Server/MSSQL/Reporting
Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
</CodeGroup>
It works to call a HelloWorld method returning a string from the custom
assembly, so there is no total failure, but calling the method to invoke the
web service fails.
Please help, I feel that I'm totally stuck!
JonasBy moving my CodeGroup in rssrvpolicy.config to right under the first
default CodeGroup, it I got it to work ...
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="Nothing">
<IMembershipCondition
class="AllMembershipCondition"
version="1"
/>
***** RIGHT UNDER HERE *****
It seems like my CodeGroup wasn't used by ReportServer until the move. We'll
just have to see how long time it will work before it breaks again ;-)
Jonas" <Jonas@.nospam.pl> wrote in message
news:u$YVj30IGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm developing a report that calls a web service using a custom assembly.
> I've got the code working in VS.NET, but when I deploy to my local Report
> Server, I get this:
> System.Security.SecurityException: Request for the permission of type
> System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed
> I have added the following to RSReportServer.config:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execute"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
> In rssrvpolicy.config, I have changed the PermissionSet for
> Report_Expressions_Default_Permissions to FullTrust and added the
following:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
>
Name="ReportServer-cmcs.msrs.webserviceclient"
> Description="Codegroup generated by the .NET
> Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program
> Files/Microsoft SQL Server/MSSQL/Reporting
> Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
> </CodeGroup>
> It works to call a HelloWorld method returning a string from the custom
> assembly, so there is no total failure, but calling the method to invoke
the
> web service fails.
> Please help, I feel that I'm totally stuck!
> Jonas
>

Deployed Report Fials with Multiple Pages

Using SQL RS 2000
My report runs fine in the designer but when deployed to the server it will
only display the first page. When move to page 2 or the last page it gives
the error:
"An unexpected error occurred in Report Processing. (rsUnexpectedError) "
Also, the report calls a subreport and if I remove the subreport it works
fine.
Any ideas?
ThanksI am having a very similar problem in RS 2005.
When I include a subreport, the main report will only display the first page
(correctly) but gives me the same error when navigating to another page.
This is occurring on one particular report only so far - a reasonably
complex report.
I have raised a technical support issue with Microsoft but they have not yet
been able to solve it.
Colin
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:O$Ek5eGgGHA.3996@.TK2MSFTNGP03.phx.gbl...
> Using SQL RS 2000
> My report runs fine in the designer but when deployed to the server it
> will only display the first page. When move to page 2 or the last page it
> gives the error:
> "An unexpected error occurred in Report Processing. (rsUnexpectedError) "
> Also, the report calls a subreport and if I remove the subreport it works
> fine.
> Any ideas?
> Thanks
>

Deployed report fails to start

VS2005 project with imbedded SQL Server reports works fine in VS IDE going agianst a network SQL Server 2005 or the local SQL Server 2005. However, when the application is deployed (to another computer). the application starts and connects successfully to the network SQL Server 2005. Everything works until the user tries to produce a report. Then the following error is generated:

Named Pipes Provider, error: 0 - No process is on the other end of the pipe (the verbose part of the error message is left out). SQL Server agent is running both on the file server and the local computer. Also, named pipes and shared memory are enabled in file server and local computer (TCP and VIA protocoles are disabled). Same is done for Client protocoles.

Any suggestions are greatly appreciated.

Go to SQL Surface are configuration -&gt; Surface Area configuration for services and connections -&gt;; Datsbase engine -&gt; remote connections and check if remote connections using TCP/IP and named pipes is enabled.gatharia|||

Have you enabled remote network connections?

http://codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx

|||

Tks for suggestion. Both on the file server and the local computer I have set the Surface Area ... to TCP/IP and Named Pipes. Please note that the access to and use of the SQL server database engine is not a problem. Everything works. The problem is related to the SSRS. That is the problem occurs when the report program tries to access the database.Maybe in the way the report dataset or datasource is defined. But then why does it work from within IDE?

|||

Yes I have. Connecting to database engine is no problem. Failure occurs when the report function tries to access the database.

|||Are you using integrated security for your datsets? I recommend using sql login.

Deployed Report

Hello,

When I run Build=> Deploy , where does the report go, I check Virtual Directory of ReportServer which is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer in my case and I do not see any file related to my report.

Thanks,

It depends on the Target URL specified under project in VS.Net

Deployed files reduced size

I am wondering why deployed packages are so much smaller than built packages. What is removed and why isn't it removed when the packages are built?

I have a package that goes from 3Mb to 1.5Mb

Any answers|||We don't remove anything from package during deployment. The things that may affect package size:
1) XML encoding. UTF-16 (usually called just "Unicode") may take twice as much as UTF-8. I think we use UTF-8 in most places, but not sure.
2) Encryption. If you encrypt the whole package (instead of just sensitive information) it may noticeably increase package size.
How you do deploy, and to what location?|||

You're spot on with the unicode, which concerns me.

The package file in the bin folder is unicode with no directive in the xml clause i.e. <?xml version="1.0"?>, the deployed file is utf-8 but with the same xml directive.

The file is deployed by double clicking on the deployment manifest and selecting "file system".

Surely this is a problem if the package contains unicode, whats more it means the file being deployed isn't the file that is built. Thats not common practice

|||Interesting. Did you do anything special with the package?

I always get utf-8 encoded DTSX files (you are right, without encoding specified in XML clause): both the project folder and bin folder contain utf-8 encoded files. I don't know a way to make designer save utf-16 files.

Deployed custom assembly doesn't call web service

Hi,
I've got a custom assembly used in Rptsvcs that calls a web service on the
local host. When run in Report Designer, it works as planned, but when run
in Report Server, it doesn't call the web service. I have a
HelloWorld-method in the custom assembly that works, so the assembly is
working but it can't call the web service.
I have modified RSReportServer.config as follows:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1">
<ConnectAccess>
<URI uri="$OriginHost$"/>
</ConnectAccess>
</IPermission>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
And the policy file rssrvpolicy.config is also modified:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="cmcs.wsclient"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program Files/Microsoft SQL
Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
</CodeGroup>
Any tips?
JonasI forgot to mention that I make an assert in code before the call to the web
service:
WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
webPerm.Assert();
TIA
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've got a custom assembly used in Rptsvcs that calls a web service on the
> local host. When run in Report Designer, it works as planned, but when run
> in Report Server, it doesn't call the web service. I have a
> HelloWorld-method in the custom assembly that works, so the assembly is
> working but it can't call the web service.
> I have modified RSReportServer.config as follows:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1">
> <ConnectAccess>
> <URI uri="$OriginHost$"/>
> </ConnectAccess>
> </IPermission>
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
>
> And the policy file rssrvpolicy.config is also modified:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
> Name="cmcs.wsclient"
> Description="Codegroup generated by the .NET Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program Files/Microsoft SQL
> Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> </CodeGroup>
> Any tips?
> Jonas
>
>|||After some more investigation, I found out that it is the following
statement
ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
I need this to get the web services to use the callers identity. The
exception thrown is:
Request for the permission of type
System.Security.Permissions.EnvironmentPermission
As before, it works in Report Designer so the code is alright, it is the
security configuration that fails somewhere.
/Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> I forgot to mention that I make an assert in code before the call to the
web
> service:
> WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> webPerm.Assert();
> TIA
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've got a custom assembly used in Rptsvcs that calls a web service on
the
> > local host. When run in Report Designer, it works as planned, but when
run
> > in Report Server, it doesn't call the web service. I have a
> > HelloWorld-method in the custom assembly that works, so the assembly is
> > working but it can't call the web service.
> >
> > I have modified RSReportServer.config as follows:
> >
> > <CustomAssemblies>
> > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> > PublicKeyToken=xxx">
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution, Assertion"
> > />
> > <IPermission class="System.Security.Permissions.WebPermission"
> > version="1">
> > <ConnectAccess>
> > <URI uri="$OriginHost$"/>
> > </ConnectAccess>
> > </IPermission>
> > </PermissionSet>
> > </Assembly>
> >
> > <Default>
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution"
> > />
> > </PermissionSet>
> > </Default>
> > </CustomAssemblies>
> >
> >
> > And the policy file rssrvpolicy.config is also modified:
> >
> > <CodeGroup class="UnionCodeGroup"
> > version="1"
> > PermissionSetName="FullTrust"
> > Attributes="LevelFinal"
> > Name="cmcs.wsclient"
> > Description="Codegroup generated by the .NET Configuration
tool">
> > <IMembershipCondition class="UrlMembershipCondition"
> > version="1"
> > Url="file://C:/Program Files/Microsoft SQL
> > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > </CodeGroup>
> >
> > Any tips?
> >
> > Jonas
> >
> >
> >
>|||I've finally gotten the report to run in Report Server, but it took a while
and a nasty config to do it. It seems that the only way to get this to work
is to change the PermissionSet for Report_Expressions_Default_Permissions in
rssrvpolicy.config to FullTrust. I've tried to create a custom PermissionSet
with CASPOL where I ended up adding all permissions and setting them to
Unrestricted="true" thinking that I could then remove one at a time to
finally get a lower priviliege permission set, but the only thing that works
is FullTrust.
Is there someone else that have experienced the same thing?
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
> After some more investigation, I found out that it is the following
> statement
> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
> I need this to get the web services to use the callers identity. The
> exception thrown is:
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission
> As before, it works in Report Designer so the code is alright, it is the
> security configuration that fails somewhere.
> /Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> > I forgot to mention that I make an assert in code before the call to the
> web
> > service:
> >
> > WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> > webPerm.Assert();
> > TIA
> >
> > Jonas
> >
> > "Jonas" <Jonas@.nospam.pl> wrote in message
> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've got a custom assembly used in Rptsvcs that calls a web service on
> the
> > > local host. When run in Report Designer, it works as planned, but when
> run
> > > in Report Server, it doesn't call the web service. I have a
> > > HelloWorld-method in the custom assembly that works, so the assembly
is
> > > working but it can't call the web service.
> > >
> > > I have modified RSReportServer.config as follows:
> > >
> > > <CustomAssemblies>
> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
Culture=neutral,
> > > PublicKeyToken=xxx">
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution, Assertion"
> > > />
> > > <IPermission
class="System.Security.Permissions.WebPermission"
> > > version="1">
> > > <ConnectAccess>
> > > <URI uri="$OriginHost$"/>
> > > </ConnectAccess>
> > > </IPermission>
> > > </PermissionSet>
> > > </Assembly>
> > >
> > > <Default>
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution"
> > > />
> > > </PermissionSet>
> > > </Default>
> > > </CustomAssemblies>
> > >
> > >
> > > And the policy file rssrvpolicy.config is also modified:
> > >
> > > <CodeGroup class="UnionCodeGroup"
> > > version="1"
> > > PermissionSetName="FullTrust"
> > > Attributes="LevelFinal"
> > > Name="cmcs.wsclient"
> > > Description="Codegroup generated by the .NET Configuration
> tool">
> > > <IMembershipCondition class="UrlMembershipCondition"
> > > version="1"
> > > Url="file://C:/Program Files/Microsoft SQL
> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > > </CodeGroup>
> > >
> > > Any tips?
> > >
> > > Jonas
> > >
> > >
> > >
> >
> >
>|||Yes, I also had a heck of a time with this. We are calling a web service to
translate English to Spanish.
I ended up going the FullTrust route myself, still haven't tested on a clean
machine all the install and config steps I took.
Steve
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ejM$u7RIGHA.376@.TK2MSFTNGP12.phx.gbl...
> I've finally gotten the report to run in Report Server, but it took a
> while
> and a nasty config to do it. It seems that the only way to get this to
> work
> is to change the PermissionSet for Report_Expressions_Default_Permissions
> in
> rssrvpolicy.config to FullTrust. I've tried to create a custom
> PermissionSet
> with CASPOL where I ended up adding all permissions and setting them to
> Unrestricted="true" thinking that I could then remove one at a time to
> finally get a lower priviliege permission set, but the only thing that
> works
> is FullTrust.
> Is there someone else that have experienced the same thing?
> Brgds
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
>> After some more investigation, I found out that it is the following
>> statement
>> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
>> I need this to get the web services to use the callers identity. The
>> exception thrown is:
>> Request for the permission of type
>> System.Security.Permissions.EnvironmentPermission
>> As before, it works in Report Designer so the code is alright, it is the
>> security configuration that fails somewhere.
>> /Jonas
>> "Jonas" <Jonas@.nospam.pl> wrote in message
>> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> > I forgot to mention that I make an assert in code before the call to
>> > the
>> web
>> > service:
>> >
>> > WebPermission webPerm = new
>> > WebPermission(PermissionState.Unrestricted);
>> > webPerm.Assert();
>> > TIA
>> >
>> > Jonas
>> >
>> > "Jonas" <Jonas@.nospam.pl> wrote in message
>> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
>> > > Hi,
>> > >
>> > > I've got a custom assembly used in Rptsvcs that calls a web service
>> > > on
>> the
>> > > local host. When run in Report Designer, it works as planned, but
>> > > when
>> run
>> > > in Report Server, it doesn't call the web service. I have a
>> > > HelloWorld-method in the custom assembly that works, so the assembly
> is
>> > > working but it can't call the web service.
>> > >
>> > > I have modified RSReportServer.config as follows:
>> > >
>> > > <CustomAssemblies>
>> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
> Culture=neutral,
>> > > PublicKeyToken=xxx">
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution, Assertion"
>> > > />
>> > > <IPermission
> class="System.Security.Permissions.WebPermission"
>> > > version="1">
>> > > <ConnectAccess>
>> > > <URI uri="$OriginHost$"/>
>> > > </ConnectAccess>
>> > > </IPermission>
>> > > </PermissionSet>
>> > > </Assembly>
>> > >
>> > > <Default>
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution"
>> > > />
>> > > </PermissionSet>
>> > > </Default>
>> > > </CustomAssemblies>
>> > >
>> > >
>> > > And the policy file rssrvpolicy.config is also modified:
>> > >
>> > > <CodeGroup class="UnionCodeGroup"
>> > > version="1"
>> > > PermissionSetName="FullTrust"
>> > > Attributes="LevelFinal"
>> > > Name="cmcs.wsclient"
>> > > Description="Codegroup generated by the .NET Configuration
>> tool">
>> > > <IMembershipCondition class="UrlMembershipCondition"
>> > > version="1"
>> > > Url="file://C:/Program Files/Microsoft SQL
>> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
>> > > </CodeGroup>
>> > >
>> > > Any tips?
>> > >
>> > > Jonas
>> > >
>> > >
>> > >
>> >
>> >
>>
>|||When the report is deployed and run from the web server it runs under a
different set of user credentials to when it is in debug, (Probably "Local
System" or "Network Service", which ever user is configured to run the
reporting services?).
Try explicitly setting the network credentials like so..
ws.Credentials = new NetworkCredential(Username, Password, Domain);
I actually store my username/password/domain in a Settings file, to allow it
to be changed easliy.
This works for me when calling the reporting services web service, I am using:
1. Explicit credentials of a domain user that can access the web service,
2. set the rssrvpolicy.config, Report_Expressions_Default_Permissions -->
Full_Trust
Note I am running my assembly in the gac.
Hope this helps
John

Deployed Application isn't connecting to SQL Server

When deploying my application that uses sql server it doesn't connect to the server.

I checked the connection string & it's ok the server instance is the same.

The computer name isn't the same & i use the .\SQLExpress as the data source.

I get an error saying 'sqlserver does not allow remote connections error 26 locating server / instance specified'.

Since computer name is changed, can you try to recreate the data source again? When creating a datasource, you can verify that if the datasource is ok to connect to the server.|||Another thing to look at is that if computer name is changed, the servername might not be valid. Can you run select @.@.servername to verify?|||

This link can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

The connection string from the dataset that visual studio generated was wrong

it needed to be .\SQLExpress thanks to all for the help