Deploying Reports From BIDS Ask For Logon
Apr 29, 2008
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.
View 1 Replies
ADVERTISEMENT
Oct 10, 2007
Hi,
Ever since working with RS I had noticed that deploying reports felt inconsistent and didn't always seem to work, requiring sometimes for me to delete and re-deploy the reports before seeing changes applied. This has the knock on effect of generating new report ID's (GUID's) for the reports and any data in the ExecutionLog table for your reports becomes useless inhibiting effective usage reporting.
I never quite put my finger on exactly what the issue was until recently discovered that "by design" report paramerter defaults are not updated when deploying reports from BIDS. This is because MS envisaged that DBA's or Report Adminstrators would be responsible for changing parameter defaults and prompts once the reports are deployed.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1
I disagree and having discussed this with the product team here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2181673&SiteID=1 it seems a sensible option would be to add a deployment option to the reporting services project definition similar to the OverwriteDataSources option.
I have posted a product feedback report on the Connect site https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299372
Please vote for this to be added to Katmai (RS 2008).
View 1 Replies
View Related
Oct 4, 2007
Hi anyone:
I'm actually developing a report with some dates on it. I want that when I run this report, a prompt (a window) appears requesting a date (or at least it could be good if a list appears and I can select one of them). Do you have any idea about how can I do that?.
Thanks in advance,
Pat
View 3 Replies
View Related
Jan 22, 2008
Up to this point only two of use, both server administrators, have developed reports. Now we need to add two new report analysts to be able to develop reports in BIDS but limit their access to other server folders, etc. Our report source code is located at G:Visual Studio 2005 Source CodeProjects and all report folders, sln files, etc. are located under the Projects sub-folder. I have shared the Projects sub-folder and given read & execute / list folder contents / read / write / modify rights. They can see the report folders and sln files via BIDS or Explorer but get "access denied" when they attempt to execute one of them. Any thoughts on what I may be missing?
View 1 Replies
View Related
Jul 3, 2007
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.
Is there a better way?
Thanks
View 4 Replies
View Related
Sep 4, 2007
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!
View 1 Replies
View Related
Jul 10, 2007
Hi All,
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.
thankyou.
View 5 Replies
View Related
Oct 16, 2007
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?
Thanks
View 4 Replies
View Related
Sep 21, 2007
Hi,
I have two aquestions.
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.
Thanks
View 5 Replies
View Related
Feb 6, 2008
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?
View 2 Replies
View Related
Jan 3, 2014
I am using SQL Server 2008 R2 SP1, and BIDS 2008 SP1. The problem I am about to define does NOT happen when the report is deployed to the report server, but only within the report development environment (BIDS).
From within BIDS my reports are fed by stored procedures. The problem is when I modify a stored procedure in Management Studio, and refresh the report from within BIDS, the report does not reflect the new changes made in the stored procedure. So far I have found one clumsy solution to this problem:
1) Go to the folder where the project is saved on the file system.
2)Find the ".data" file that is associated to the particular report, then delete it. For instance, if my report name is TestReport.rdl, find the file named TestReport.rdl.data, then delete it.
View 3 Replies
View Related
Aug 9, 2007
Hi all,
I am trying create the script which is from net but now able to deploy reports using that script.
I am,using following script:
rs -i c:PublishReports.rss -s http://servername/Reportserver -v filePath="filePath" -v sqlServerName="SQLServerTest" -v parentFolder="target Folder"
I am getting following error:
C:e9usc6ik.1.vb(38) : error B
C30035: Syntax error.
/*PublishReport("Report1")
~
C:\e9usc6ik.1.vb(43) : error B
C30035: Syntax error.
*/
~
The specified script failed to compile with the following errors:
C:\Temp
mmy_1lg.1.vb(38) : error B
C30035: Syntax error.
/*PublishReport("Report1")
~
C:\Temp
mmy_1lg.1.vb(43) : error B
C30035: Syntax error.
*/
~
thanks
for the help!!!
View 3 Replies
View Related
Dec 27, 2006
Hi ,
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.
Did anybody face this kind of problem ?
Thanks & Regards,
Kiran Kumar
View 2 Replies
View Related
May 15, 2007
Hi All,
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?
An immediate reply will be highly appreciated.
Thanks
Sekhar
View 6 Replies
View Related
May 19, 2008
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.
Regards...
Girija Shankar
View 5 Replies
View Related
May 9, 2007
hello experts,
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.
/chandresh soni
View 2 Replies
View Related
Oct 31, 2007
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
View 5 Replies
View Related
Dec 22, 2006
Hello,
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.
Can anyone give me any clues?
Thanks,
Michael
View 3 Replies
View Related
Dec 19, 2006
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?
View 1 Replies
View Related
Oct 20, 2007
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 go to
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles
On the machine but we cannot find any more detailed error messages...
Does anyone have any idea as to whether the messages migh be written somewhere else?
Thanks and Best Regards
View 1 Replies
View Related
Oct 19, 2006
Hi all,
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.
Many Thanks!
Alex
View 4 Replies
View Related
Nov 20, 2015
I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .
ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate
[Code] ....
And for prompts how to create created_by and message_type dropdowns as shown in picture.
View 7 Replies
View Related
Mar 19, 2007
Hi
I have two questions:
1)
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?
Thanx :-)
View 1 Replies
View Related
Nov 16, 2006
I have come across this error message in ssrs and cannot seem to locate the error. Report manager lets me logon-- I can navigate to the folder but once I click on the actual report I get this error
and suggestions as to why and how to fix it???
Thanks in advance
View 6 Replies
View Related
Dec 3, 2007
Hi,
how to deploy the shared datasource and the related rdl files from test server to the client server.i am currently using Sql Server 2005.
Thanks in advance
Jai
View 1 Replies
View Related
Nov 5, 2007
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.
Hal1490
Hal9000
View 4 Replies
View Related
Mar 18, 2008
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.
Any help is appreciated
View 2 Replies
View Related
Mar 18, 2008
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.
Any help is appreciated
View 1 Replies
View Related
Jun 29, 2007
HelloI am getting this err msg when trying to logon to my website on the web - on my machine there is no prob, An error occurred while established a connection to the server.When connection to Sql.S 2005, this failure may be caused by the fact thatunder the default settings sql.s doesn't allow remote connection.(provider :Sql.S Network interface, error:26- Error Location Server/Interface Specified)(the files path is like in the web host s)
View 2 Replies
View Related
Jun 23, 1998
When attempting to logon to the SQL server using ODBC, Windows NT workstations get the following error code:
Connection Failed:
SQLState:`01000`
SQL Server Error:1326
...
Windows `95 stations can log on fine.
Any suggestions? Thank you in advance.
View 1 Replies
View Related
Aug 29, 2000
Is there a sp or an easy way to move logons from SQL6.5 to 7.0?
Thanks,
Kevin
View 1 Replies
View Related
Mar 26, 2001
Greetings,
After upgrading a SQL 7.0 WINNT 4.0 SP5 box to Windows 2000 SP1, SQL 2000 configuration I am getting the following error when some users try to connect to the server using Enterprise Manager;
"A connection could not be established to 'SERVERNAME'. Reason: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'"
After doing some troubleshooting, I have found that this only occurs when I have the services started with a domain service account (this account is part of the domain admin global group and is a System Administrator in SQL as well) and it does not occur when the services are started with the System Account. Additionally, it also appears that this only occurs for some users and not all. However, these same users that are having problems on this server, can connect to other Database Servers using the "same" configuration.
Has anyone seen this. I have searched TechNet and found nothing that applies directly to this error. Any help that could be provided would be greatly appreciated.
View 1 Replies
View Related
Feb 15, 2001
I just started at a new company. The security stinks, everyone logs into the servers as sa (including many applications). I am taking steps to tighten security and restrict access to the sa login. I would like to capture some additional information at logon as an interim measure.
Can anyone assist me in automatically recording the following:
Host Name / IP Address
Login time
I realize I could periodically run an sp_who2 and capture the results - I also realize that if I turn on auditing, the logon will be written to the SQL Srvr LOG - I'm looking for an elegant / low impact way to capture the logon and host information.
Thanks in advance for any help.
Scott Wright
View 1 Replies
View Related
