Deployment question: SQLDB - SSIS on different boxes with SQL Agent for scheduling

I am interested in how you guys are deploying your packages.
I am running SQL Server Integration Service(SSIS) and SQL Server Database Service (SQLDB) on different boxes. I can't have SSIS installed on SQLDB box because in my prod. environment, the DB box has *just* DB - no services or no other fancy stuff. So far so good.

Now, if I want to schedule the SSIS packages (deployed on MSDB) to run periodically, I need to create an SQL Agent job (or everyone else here is using a Windows scheduler instead?). SQL Agent has dependency on SQLDB and so it goes on the SQLDB box, correct? Can I run job steps to execute SSIS packages via remote SSIS service (on another box)? If not, I cannot separate SSIS and SQLDB on two boxes and have SQL Agent run the packages periodically, right?

What am I missing?

thanks,
Nitesh

Is there a reason you cannot install DB on the IS box? That would be best for your case as I understand it. You could also keep your packages on your IS box then as well.

To answer your question, there is no current IS feature for running packages remotely. Please see this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=18177&SiteID=1

|||

KirkHaselden wrote:

Is there a reason you cannot install DB on the IS box? That would be best for your case as I understand it. You could also keep your packages on your IS box then as well.

There are two reasons:

Hard Reason --> Our production environment does not allow to install *ANYTHING* on the box that runs the database (i.e. SQL DB). This was the main reason we were not using DTS.

Soft Reason --> For deployment, we would like to have separate tiers for DB, app server components (i.e. SS*S), and presentation components (SPS etc). One may argue that SSIS is a component at DB tier and its scaling, clustering etc will be dependent on the DB tier.

KirkHaselden wrote:

To answer your question, there is no current IS feature for running packages remotely. Please see this thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=18177&SiteID=1

I guess I did not put the question correctly.
What I want to know is if I can configure SQL Agent running on machineA to execute SSIS packages using the SSIS Service running on machineB. Note that machineA does not have SSIS Service running (only machineB). The packages themselves can be stored locally on machineB, if needed (but I am hopeful that it should not be an issue and msdb of machineA should work just fine).
Thanks,
Nitesh

|||

If a process on machineA calls a package, then it will run a A, so you need IS installed on A. You can load the package from B or wherever, but the package runs on the same machine as the process which called it and hosts it. You would need a layer of abstraction, which is not currently available in IS itself, that is really remote execution.

Simplest method is to have SQLAgent on B, and call the job, since this is just saying start a job, which means the process runs on B.

|||<quote>
Simplest method is to have SQLAgent on B, and call the job, since this is just saying start a job, which means the process runs on B.
</quote>

The problem with having SQLAgent on B is that I will need to have SQLDB also on B (because SQLAgent has a dependency on SQLDB). This defeats the original plan of having SQLDB on machine A and SSIS on machine B separately.|||In my opinion it is the simplest, but not the only way. You can do any form of remote call, such that the server/listener on the remote machine hosts the SSIS process.

You can use any scheduler you like, it is just that SQL Agent can easily be controlled remotely, through T-SQL which most of us are quite happy with already.

I don't see what the issue is with having another SQL instance on the SSIS machine, after all would it not be nice to have a local working store, in fact don't some tasks want a SQL store, and therefore having it locally makes much more sense. I think your network costs could get excessive, just for the sake of keeping things separate. By all means keep server A clean, and have your main data there, but what is the harm in having SQL on server B as well. You like to have separate tiers, but is it so strict you cannot mix applications, should it not be functions really, in which case where is the issue? Having a no SQL and IS on the same machine at all, regardless of the use of SQL seems rather artificial and just making life hard for the sake of it. Offloading IS onto a separate machine makes sens as well for large volumes, to reduce impact on your main production SQL server, but I woudl argue that the IS box should be the controller of the IS based processes, and not the other way around.

Saying all that remote execution would be cool to have too.|||

DarrenSQLIS wrote:

In my opinion it is the simplest, but not the only way. You can do any form of remote call, such that the server/listener on the remote machine hosts the SSIS process.

Unfortunately, my prod environment doesn't allow for the simplest solution, that I would love to have.

DarrenSQLIS wrote:

You can use any scheduler you like, it is just that SQL Agent can easily be controlled remotely, through T-SQL which most of us are quite happy with already.

I would love to use SQL Agent. Since it has a dependency on SQLDB, I cannot have it on SSIS box. If SQL Agent could invoke SSIS remotely, I would have take n that.

DarrenSQLIS wrote:

I don't see what the issue is with having another SQL instance on the SSIS machine, after all would it not be nice to have a local working store, in fact don't some tasks want a SQL store, and therefore having it locally makes much more sense.

Issue is simple - it won't be supported by our database group. Our DB group controlls all the DB instances, and they have nothing at all on those boxes which they support. So, SQLDB on SSIS box won't be supported. I don't want to get calls in the middle of the night for that and neither do I want to start doing backups, maintenance etc.

DarrenSQLIS wrote:

I think your network costs could get excessive, just for the sake of keeping things separate.

I know lot many enterprises that enforce such policy of having clean DB boxes.
I thought that network costs for such configurations will not adversely impact performance too much. Am I wrong?

DarrenSQLIS wrote:

By all means keep server A clean, and have your main data there, but what is the harm in having SQL on server B as well. You like to have separate tiers, but is it so strict you cannot mix applications, should it not be functions really, in which case where is the issue? Having a no SQL and IS on the same machine at all, regardless of the use of SQL seems rather artificial and just making life hard for the sake of it. Offloading IS onto a separate machine makes sens as well for large volumes, to reduce impact on your main production SQL server, but I woudl argue that the IS box should be the controller of the IS based processes, and not the other way around.

Saying all that remote execution would be cool to have too.

Bottomline is -> It is not important what I could do to get around the issue, it is more important that the product should be deployable in a layered/tiered fashion on separate boxes with support for scheduling packages on whatever is the preferred scheduling mechanism (i.e. SQLAgent). Please understand that there exist network deployment scenarios in enterprises that might not work with having a side-kick SQLDB instance on SSIS box.

Thanks for your suggestions though.

Nitesh

|||

Nitesh Ambastha wrote:

Issue is simple - it won't be supported by our database group. Our DB group controlls all the DB instances, and they have nothing at all on those boxes which they support. So, SQLDB on SSIS box won't be supported.

Somewhat of a retorical question or point, but if your DB group does not understand SSIS then they should not allow you to use it. Your use of it could adversely impact the avilability of the pure SQL systems, I would never allow any system to interact with my SQL systems that could have such an impact unless I had sufficient understanding of it. If they did understand it, then what is the problem :) This is my personal point, so no response required, but it seems an artificial rule.

Nitesh Ambastha wrote:

I thought that network costs for such configurations will not adversely impact performance too much. Am I wrong?

I was trying to highlight the time and bandwidth costs. The further away from your data your SSIS is, the slower it will be, although you could solve some of that by spending money on faster links. So for large amounts of data processing it could have an impact since you will be running across the two machines.

Nitesh Ambastha wrote:

...for scheduling packages on whatever is the preferred scheduling mechanism (i.e. SQLAgent).

SQL Agent is my preferred scheduler, and maybe yours too, but many organisations have their own standards. Many houses use IBM/Tivoli for example, and SQLAgent is not required for SSIS. If you would prefer to use it, then yes you are stuck. I think buyng SQL Server for SQLAgent is an overkill, but if you look at that SQL Instance in the same way as you look at MSDE, then it is no big deal. There are plenty of proucts our there that install DB engines. I saw a report that said Informix (I think that was the one) was one of the most widely deployed DBs, and that is because CA shoved it under the covers of ArcServe backup, probably for the scheduling :)

Deployment Problem

I get the following error while deploying on my local machine with my machin
e name or ip
A connection could not be established to the ReportServer http://machinename/Repor
tServer
If i deploy with localhost instead of machinename it works.
Any ideas why that happens.
Help would be appreciated.
ThanksI suggest you check your IIS configuration. Check the properties - web site
tab - advanced button of the Default website in IIS and see if you have
anything other than just "Default 80" under "Multiple identities for this
web site"
Tunji
"ReportFaqGuy" <anonymous@.discussions.microsoft.com> wrote in message
news:8160D89C-32CE-40C4-9A31-6066893C2048@.microsoft.com...
> I get the following error while deploying on my local machine with my
machine name or ip
> A connection could not be established to the ReportServer
http://machinename/ReportServer
> If i deploy with localhost instead of machinename it works.
> Any ideas why that happens.
> Help would be appreciated.
> Thanks
>sql

Deployment on load balanced servers.

Hi, I'm trying to solve the problem with deploying sql code on load-balanced application server.
Normally when we put new feature\fix live we take one server out of the loop, than we put new app code, we test it and then we bring it back to the loop. But we've started to have a problem when we had to change stored procedures at the same time to run the new app code, becouse either 'test' server won't work either production application won't work. I wonder is there any good solution for this problem.

Regards
Piotr.
P.S. Sorry for the forum topic but I didn't know where to put it.

what I understand is that your stored procedure signature is still the same but its implementation is changed in such a way that only the new application code can work with it. Your configuration is mulitple application servers talking to 1 SQL Server. In that case, let us say you have 10 application servers. I will take 5 (let us call them group-A) of those out of the loop, install new app code. Note, your app is still up and running though at 1/2 the capacity. you can test your group-A with another SQL Server (say the test SQL Server that has new stored procs). Once it is done, you can take other group of app servers offline (this will cause short term unavailability of your application), change the stored proc on the production SQL Server, and then bring group-A online. Now you can do the same with other set of application servers.

|||That was very helpful, but I'm more after stored procedure versioning solution. Sometimes we need old and new code running (part of requests are hitting old and other new code). Thanks in advance.|||http://weblogs.asp.net/fmarguerie/archive/2003/02/24/2880.aspx fyi.sql

Deployment of SSRS Reports

Hi,

How do we deploy SSRS Reports to various server. One option which we

are using currently is deploying from the report project. We want to

automate the Reports Deployment. Can any of you who have done this in

the past share the experience?

Thanks,

S Suresh

YOu can use the APIS of the reporting Services. Deploying is quite straight forward with them, see the link here for an example http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d265ba0a4f82369e

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Deployment issue SSRS 2000 reports on Production server

Hi All,
I am facing the issue while deploying Reporting Services 2000 Reports in
Production environment (Windows NT Server and SQL Server 2000) in our
application.
Background: I developed few reports using SQL Server Reporting Services 2000
and are able to deploy in Development environment and those reports are
working fine without any issues.
When we are trying to deploy the same in our Production environment, then we
are facing some issue during the deployment time and not able to deploy those
reports into it. We are followed 3 ways to deploy the same as mentioned below:
Method 1: From Application or report manager screen
(http://servername/reports or http://localhost/reports ) we are trying to
deploy / uploads all the reports one by one, then we are getting the error at
the time of upload as â'The underlying connection was closed: Could not
establish trust relationship with remote server.â'
Method 2: From Reports Designer window, we set build mode as â'Productionâ'
and set all the project environments as Production environment and made a
build and then made deploy. After that we are getting an error as "A
Connection could not be made to the report server
http://servername/reportserver". Later we manually copying all the reports
into Production environment and trying to open the reports, then we are not
able to open / call those reports from our application. Here we could not
able to connect or do not know what to do after copying of the reports into
physical environment of the application.
Method 3: We search thru google and few forums, and then we got to know that
we can deploy reports from the script also. So we tried to do the same as per
their instructions, then we got the error in command prompt as below:
E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i ps_reports.rss
â's http://servername/reportserver -v parentfolder="DBDReports"
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The command completed successfully
Kindly help us to resolve this issue and thanks in advance for your help.
Regards,
nsbThe best way to work this out is from the development environment. You can
deploy a single report by doing a right mouse click on the report and
deploy. What error if any are you getting? Do you have the rights to
publish? One easy thing to try in that regard is to add your user to the
local adminstrators group on the server.
I am betting that you are not part of the administrators group and you were
on the development server. You need to have someone who is in that group to
add you to the appropriate roll in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nsb" <nsb@.discussions.microsoft.com> wrote in message
news:8327C9F9-4320-4D0B-84F2-B636A0CAC04C@.microsoft.com...
> Hi All,
> I am facing the issue while deploying Reporting Services 2000 Reports in
> Production environment (Windows NT Server and SQL Server 2000) in our
> application.
> Background: I developed few reports using SQL Server Reporting Services
> 2000
> and are able to deploy in Development environment and those reports are
> working fine without any issues.
> When we are trying to deploy the same in our Production environment, then
> we
> are facing some issue during the deployment time and not able to deploy
> those
> reports into it. We are followed 3 ways to deploy the same as mentioned
> below:
> Method 1: From Application or report manager screen
> (http://servername/reports or http://localhost/reports ) we are trying to
> deploy / uploads all the reports one by one, then we are getting the error
> at
> the time of upload as "The underlying connection was closed: Could not
> establish trust relationship with remote server."
> Method 2: From Reports Designer window, we set build mode as "Production"
> and set all the project environments as Production environment and made a
> build and then made deploy. After that we are getting an error as "A
> Connection could not be made to the report server
> http://servername/reportserver". Later we manually copying all the reports
> into Production environment and trying to open the reports, then we are
> not
> able to open / call those reports from our application. Here we could not
> able to connect or do not know what to do after copying of the reports
> into
> physical environment of the application.
> Method 3: We search thru google and few forums, and then we got to know
> that
> we can deploy reports from the script also. So we tried to do the same as
> per
> their instructions, then we got the error in command prompt as below:
> E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i
> ps_reports.rss
> -s http://servername/reportserver -v parentfolder="DBDReports"
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The command completed successfully
> Kindly help us to resolve this issue and thanks in advance for your help.
> Regards,
> nsb

Deployment Error

I am getting the following error when deploying to the Sharepoint from my Report Designer. I was able to deploy the reports before by providing the TargetServer url. What could be going wrong?

The path of the item "/Sample Reports/Test Sample Report " is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.

Very wiered... I was able to deploy the report even with deployment error... Any way I changed the name of the report and am not getting any deployment errors.

Deployment

Hi All,
After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:
"Cannot Find keycodev2.dll, or invalid keycode"
Any help will be appreciated,
thanks.
mzainalDid you check the users machine to make sure that dll was there and registered properly?|||Thanks for your reply, but how do you go about doing that ? Do you have a list of required DLLs ? How do you register them ?

thanks.|||Did you create a setup file before you deployed, or did you just give the user a copy of the exe? If you just gave the user a copy of the exe, then there's you're problem. You should create a setup so that all the necessary files can be installed on the users machine.

The list of required dlls is different depending on what part of Crystal you're using. CrystalReportViewer is not the only part of Crystal that's being used.

I use Crystal Reports 8.5. That version comes with a file called runtime.hlp which contains a list of all the Crystal Files required for deployment. You can search on www.google.com or Crystal's website (http://support.businessobjects.com/search/advsearch.asp) to try and find a list of the files that you need.

Also, look here. I found this by typing in keycodev2.dll into Google and hitting the search button.

http://www.dotnetforums.net/t75112.html

Deploying with sql server express

I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

It depends on how you're syncing. If you're using manual implementation via SQL Client on device, that would work with properly configured SQL 2005 Express as well.

If you using SQL Mobile RDA or replication, you would have to implement manual sync using SQL Client as Express offers no RDA/Replication support.

|||I am using replication. Can you direct me to some reference material that can assist me in changing to manual sync?|||Also, to test with sql server express will I need to install it on my computer? I am running sql 2005 and visual studio 2005. Can I load express in addition to what I have installed. I do not want to un-install anything that I have currently. What is your suggestion?|||

I'm not aware of any reference materials on that. The idea is very simple - you go through all records in one db and compare them with records in another db. If they are different, you'd need to synchronize them as appropriate in your particular case. For example:

Before:

SQL Mobile SQL Express Action

1-foo 1-foo Same data, do nothing

2-bar 2-foobar Data changed, copy from Express to Mobile

2-some <nothing> Record deleted, delete from Mobile

(or is it added on device? - that's for you to track)

Before:

SQL Mobile SQL Express

1-foo 1-foo

2-foobar 2-foobar

As far as I know you can run SQL Express and SQL Server side by side, though you would need to use nonstandard port.

|||

some honest, non-politically correct advice - I wouldn't install SQL Server 2005 and SQL Express on the same machine. it can cause you a lot of difficult issues - I'm not saying it can't be made to work, but you're asking for a day of searching newsgroups to resolve the issues that this introduces. either remove SQL Server and re-run the VS2005 setup, choosing SQL Express as an optional install component, or use a separate box to run SQL Express on.

-Darren

deploying with default parameter value

I have an application with a parameter that has a single value drop down list from a query. My dataset has a union with "0","All". I set the default to non-queried, value "0". I go to preview and BI displays the label correctly as "All". When I deploy the app and view it in the web browser the default value is not displayed correctly, and it shows "Select a value". Why, why, why does it preview correctly yet deploys incorrectly, and how can I fix it
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou can try deleting the earlier deployed report from Report Manager
and deploy the modified report which is previewing fine with all
default values.
Thanks
Subhash

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying web app, which SQL files do I upload?..

I'm working on a web application that uses SQL Server 2000. Once I'm ready to upload my website to a production server, I need to know how to upload my SQL Server database files to the server. Are there actual files that can be uploaded? I've only deployed a website that works with MySQL to a production server, and there were no files to upload... the database had to be created on the server, and then the data itself had to be exported to text files (on my computer), then imported/uploaded to the production server using SQL statements...

How do I do this?

Thanks~::I need to know how to upload my SQL Server database files to the server.

Ask your provider, systemadministrator or whoever manages this.

Our hosting operation does NOT allow uploads of sql database fiules - you are supposed to create a new database and use the copy database wizard out of SQL Server's enterprise manager.|||hi
i saw http://europe.webmatrixhosting.net, do you know that all hosts provide like this host utilities to work with SQL Server? utilities like http://www.aspenterprisemanager.com??

i'm developing an asp.net storefront that uses SQL Server Database, but i'm worry about after developing that, i want to do what?!! how to manage my database?
tahnk

Deploying vb.net english query application

Hi,
I'm attempting to distribute a vb.net english query application to a
client, however, when the client runs the application, it crahses when
it tries to create an instance of the "Mseq.Session" object.
As far as I can tell, the interop and the original dll are being
included in the setup correctly - are there any special settings (such
as com registration, system etc), or other files that I should be
including? Or are there any other prerequisits for the client's pc
before I can expect the software to run?
Cheers,
Tinium.
you are still going to need to install the EQ engine on the target
platform.. There's an awful lot of work done by the engine before the query
is shipped off the Server. EQ is a client function..
Guy
"Tinium" <tin@.ium.com> wrote in message
news:eWfltpaQFHA.132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm attempting to distribute a vb.net english query application to a
> client, however, when the client runs the application, it crahses when it
> tries to create an instance of the "Mseq.Session" object.
> As far as I can tell, the interop and the original dll are being included
> in the setup correctly - are there any special settings (such as com
> registration, system etc), or other files that I should be including? Or
> are there any other prerequisits for the client's pc before I can expect
> the software to run?
> Cheers,
> Tinium.

Deploying updated report but still seeing old version

Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >

Deploying too many reports causes error in report manager

sql reporting services (sp2)
windows 2003 server
Sql 200 sp4
all on one server (iis & sql server)
I have about 30 reports which I deploy from my local environment to our
reporting server. If I deploy about 10 of the reports everything is fine,
all reports deployed work. However, the more reports I deploy I notice the
slower the report manager screen takes to load. After I deploy about 15 of
my reports I will eventually get an error on report manager screen:
There is an error in XML document (1, 4078)
I have tried to deploy differnent reports to see if it is a specific report
that may be causing this, but this does not seem to be the case.
Any help with this would be greatly appreciated, as I am out of ideas and
resources to figure this out.
Regards,
Troygensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
sounds strange ,30 reports not a lot at all .|||gensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
Troy, i may test your reports in your environment just
to verify nothing is really wrong with them, if you
wish.
We have our own tool to deploy reports, so this could
be useful - to deploy them at once but slightly
another way...
I just need your .rdls to do so.
Let me know.
Cheers

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...