I have a standard package of reports that need to be deployed by an installer (InstallShield) to an SSRS Server for use with our custom application. We are not in control of the environments where these reports will be deployed as this is a "commerical" application that gets deployed directly to customer sites. The installer may or may not be run on a machine that has SSRS installed on it therefore there is no guarantee that the deployment tools are available. What is the reccomended approach for deploying a "Standard Reports" package using an installer like InstallShield? I can't seem to find anything out there that deals with this kind of situation. Is anyone doing this?
Just wondering what people do when they deploy sub reports and what is the 'best practise' for this. I'm just deploying them to the same folder as the main report and hiding them.
This is, to say the least, messy. As a user has to click 'Show Details' and they can see the sub report.
I have created a report, and want to now deploy it to the Report Server. Each time I try to do that, I get a Reporting Services Log In screen. I have no idea what to input, having tried my windows authentication and sa account without sucess. Is there something else that I need to set up so I can deploy my reports? Thanks in advance!
I want to programatically deploy the report in VS2005 environment,ie.from an asp.net page if i click deploy report Button ,the report should be deployed into the report server automatically.So that i can view the report in report server. the input to the asp page would be the.rdl file... If anyone could help then it would be good.
I have installed SSRS on my local machine with all default settings. Report manager and report server and reportserver data base and reportservertempDB all are in my local machine. Now I have already created few reports. but now the company wants to deploy them to the main server. Now can I do this? Do I have to chage the report configuration settings. Does it effect to my current reports? If this is possible, can anyone tell me how to do this please?
1. How do I select data ovewrite option in SSRS? When I deploy a report i got a following error message.
Warning : Cannot deploy data source mydatasource to the server because it already exists and OverwriteDataSources is not specified.
2. When I try to snapshot a report on report manager, I get a error message.
"Credentials used to run this report are not stored
Then I went to Management Studio and selected the data source and open the report data source property box. I gave a login name and a password under credential stored securely on the server. Can this login name and password be random ones or do they come from smwhere else? Even After I did this still i get the error.
I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.
While deploying reports on the reports server, it is asking to supply user name and password. When I entered the same, it didn't accept them. What do I need to do? Is there any specific setting which I need to configure?
I have found many references to this issue on the forum, but no solution that works in my case. I believe that I am lacking a fundamental understanding of a security issue so I will attempt to provide as much up front information as possible. I can publish SSRS reports from BIDS to my local computer but when I try and publish the same reports to a production server, I get a login dialog (which I cannot get passed). Here are the particulars. My environment is a home office. I have my computer (which works with the localhost designation) running on a workgroup network (not domain based). My server is another machine on the network (named €œserverone€?). Both machines are running Windows XP Professional. The BIDS project €œDebug€? property page has the TargetServerURL set to http://localhost/ReportServer. The €œProduction€? property page has the TargetServerURL set to http://serverone/ReportServer. I am logged on as an administrator but I cannot publish to the remote server (serverone) from my machine (localhost). I have also tried using the actual TCIP address of the server in place of the serverone name to no avail. I believe that my problem is related to authentication between the two SQL Server 2005 instances running on separate machines on a workgroup based network rather than a domain based network but I cannot find any information that might be useful under these circumstances. Now, here is my workaround (but this seems very wrong). From the logon dialog generated in BIDS, the user ID name was blank. When I attempted to remotely access the Report Manager on the server from my machine, IE tried to logon using the €œserverone/guest€? account. I added an administrator role to the guest account on the server and everything works as expected. As I mentioned before, this seems very wrong. Currently, both machines were set to use the €œlocal system€? account during setup, but I am not even sure what that means. I tried setting the server to use the €œNetwork Service€? account as suggested in one of the forum threads but that did not work. Any help here would be greatly appreciated as I am sure that allowing the €œGuest€? account to have €œAdministrator€? privileges is a bad idea.
I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.
i can deploy that onto any Report Server. For that I will have to change the datasource connection string.
Is there a way to achieve this. Please let me know if it is there.
i need help with deployment of reports (SSRS 2005). we need to deploy many reports (more then 100) on the production everytime we make changes in them.
"the problem is we cannot install visual studio on the server to open the project and use the deploy option from it" i tried using the script - PublishSampleReports.rss
but everytime i run i need to go and manully configure the report to map the shared datasource to it. any way to pass the information in the script itself, or is there any smart way to deploy on production.
I have seem many messages about this, mostly over a year old, with no satisfying answer. I have a set or reports that jump between each other, passing parameters, that work fine in VS 2005. (They are mostly based on sql server 2005 stored procedures). When the reports are deployed, the one that jumps without a parameter works. The ones that pass parameters do not even 'activate'- that is, the text box to be clicked does not allow the user to click. If I go to the report directly through the browser, it lists the missing parameters and the report does not render. I am using IE7. All SP on IE and SQL are current. Microsoft- will you be making this feature work anytime soon? Thanks
I wonder if anyone can help me save the few remaining hairs on my head? I am trying to deploy reports created in SQL Server Business Intelligence Development Studio to SharePoint running SQL Server 2005 Reporting Services in SharePoint integrated mode. Whenever I try to deploy a report, the Reporting Services Login window pops up no matter which user/password I provide it won't accept any. I have the Reporting Services database set up to use Windows credentials and my Domain adminstrator account so I presume that this is user that I should be providing when prompted when deploying.
I am trying to figure out Reporting Services and to to deploy results -- and really don't know what I'm doing. I'm going through some books and it looks like our TargetServerURL would either be http://SERVER NAME/reports or http://SERVER NAME/reportserver.
Either one will give me a prompt for user & pswd. When I enter my network user & password, I get this message: "You are not authorized to view this page" (It's set up for Windows authentication.) Any suggestions?
Hi All, we are changing some reports from English to German...some of the reports that we have changed generate the message 'An internal error occurred on the report server. See the error log for more details.'
We have many domain users who develop/deploy reports using VS2003 to our remote server at https://server/reportserver with no problems at all.
A single workstation on the domain that been used to develop reports cannot deploy though. The message looks fairly simple to diagnose "no report server was found at https://server/reportserver". I have checked dns and the servername resolves no problem. I have manaully edited and added the server to the hosts file also. I have updated and service packed all VS elements (VS2003 7.1.6030).
The server is contactable in all ways on this workstation, all ip/dns settings are the same as other domain workstations.
Can anyone point me in the direction of log files to look at, or if i am missing any basic options in VS. I have checked all deployment settings from other workstations.
I need to deploy reports to a server in Spain, which I do not have direct access to. Is there any way that I can simply deploy the reports to a server here, that I have access to, and then copy the reports to the server in Spain??? Or is there any other way? I cannot expect the customers in Spain to be able to use Microsoft Visual Studio 2005 themselves to deploy reports (they do not even have access to the tool).
2)
How do I set up reporting services on a clustered server? I have configured reporting services on both clusters, but somehow I cannot initialize both of them. Only on will be initialized at a time. Does anyone have experience with this?
When I'm using installshield to install sql runtime, I get the message "The Workstation service has not been started" during Configure SQL Server Agent. Does someone know what it means and how to solve it?
I don't know what I did, but I keep getting the message that I can't install a program or even uninstall one. I think I deleted part of my installsheild. I have tried to find out where and how to repair it, but I haven't so far. Please help!!!!! Rita
I tried to execute SQL Server Express Setup through InstallShield Script and it says that i required Admin Privilege. I checked and i have an Adnming privilegers.
Here is the Script. And the check says that i am an admin.
if ( Is(USER_ADMINISTRATOR, "") = TRUE) then MessageBoxEx("Admin...","Install",SEVERE); else MessageBoxEx("Non Admin...","Install",SEVERE); endif;
setuppath = "C:\Program Files\dir\Setup.exe"; sqlcmd = "ADDLOCAL=ALL"; LaunchAppAndWait(setuppath,sqlcmd,LAAW_OPTION_WAIT); if(LAAW_PARAMETERS.nLaunchResult != 0) then MessageBoxEx("Fail to install SQL Server Express...","Install",SEVERE); endif;
I am having a major issue installing SQL Server 2000 through InstallShield using the three merge modules sent with it (and available on the SQL Server CD) Being:
SQLBASE SQLSVR SQLSVR_RES
The install builds fine and runs right upto the end of the copying, where it pauses for a few seconds and comes back with a dialog saying
Product: SQL Object Installer -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
SQL Object Installer being the package I created
So I do this, only to find the following error log:
2004-01-08 09:58:40.65 server Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
2004-01-08 09:58:40.67 server Copyright (C) 1988-2000 Microsoft Corporation. 2004-01-08 09:58:40.67 server All rights reserved. 2004-01-08 09:58:40.67 server Server Process ID is 1588. 2004-01-08 09:58:40.67 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'. 2004-01-08 09:58:40.68 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2004-01-08 09:58:40.76 server SQL Server configured for thread mode processing. 2004-01-08 09:58:40.78 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks. 2004-01-08 09:58:40.98 spid3 Warning ****************** 2004-01-08 09:58:40.98 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2004-01-08 09:58:41.01 spid3 Starting up database 'master'. 2004-01-08 09:58:41.54 server Using 'SSNETLIB.DLL' version '8.0.534'. 2004-01-08 09:58:41.54 spid5 Starting up database 'model'. 2004-01-08 09:58:41.59 spid3 Server name is 'GROUPNETVISTA2'. 2004-01-08 09:58:41.59 spid3 Skipping startup of clean database id 5 2004-01-08 09:58:41.60 spid3 Skipping startup of clean database id 6 2004-01-08 09:58:41.60 spid3 Starting up database 'msdb'. 2004-01-08 09:58:41.84 spid5 Clearing tempdb database. 2004-01-08 09:58:42.10 server SQL server listening on 10.171.1.205: 1433. 2004-01-08 09:58:42.10 server SQL server listening on 127.0.0.1: 1433. 2004-01-08 09:58:42.60 spid5 Starting up database 'tempdb'. 2004-01-08 09:58:42.73 spid3 Recovery complete. 2004-01-08 09:58:42.73 spid3 SQL global counter collection task is created. 2004-01-08 09:58:42.74 spid3 Warning: override, autoexec procedures skipped. 2004-01-08 09:58:47.17 server SQL server listening on TCP, Shared Memory, Named Pipes. 2004-01-08 09:58:47.17 server SQL Server is ready for client connections 2004-01-08 09:58:56.67 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
I am stumped, I am not really the greatest with SQL Server so I don't really know where to start, the SCM line at the bottom of the errorlog doesn't tell me much as I can't see what would be sending the 'stop' request?
Could this be a permissions thing. I have set myself as the administrator on the machine and do have quite a few rights. The machine does not already have SQL Server on it as it is a fresh image of Windows 2000 (also tried on XP wth same result)
Any help on this would be most appreciated as all around me are stumped too.
I have copied install files to both local and remote locations
I know the response €“ Installshield cannot find the silent response file, but SQL setup creates this on its own. Short of bringing this production system down and re-installing on both nodes ( I did test this on a non-prod box by the way, no issues), I am at a loss
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID. I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data: 1 - 50 60 - 80 150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
