How To Enable FIPS And Keep SRS (for MOM Reporting) Working?
Mar 15, 2007
Long Time Lurker, First Time Poster
Need to know how to enable FIPS and yet still keep SRS (for MOM Reporting) working? Is this even possible? SQL 2005 box sits in an OU where FIPS is enabled, serves MOM Reporting up.
Tried SSL-ing IIS and using TLS.
Tried enabling FIPS also in the local policy to ensure it was on when SQL started.
Even have SQL 2005 SP2 on there.
Everything works great if I disable FIPS and bounce it. Enable FIPS and bounce it and can't get to the SRS or MOM Reporting web pages, not locally or from a workstation.
Has anyone got this to work?
Does anyone see a reference stating that this is not supposed to work, by design, or whatever?
TIA,
KAZE33
View 3 Replies
ADVERTISEMENT
Feb 6, 2007
Hello,
I got the error:
______________________
Reporting Services Error
* For more information about this error navigate to the report
server on the local server machine, or enable remote errors SQL Server
Reporting Services
______________________
I saw the answer:
"You could set the "EnableRemoteErrors" configuration value to True in
the ReportServer.ConfigurationInfo database table."
How can I get to the ReportServer.ConfigurationInfo database table?
I am on the reportservice server and I run "reporting services
configuration manager" and the "sql server managment". I didn't saw
that option :(
Where is this configuration?
Any help?
Thanks
View 1 Replies
View Related
Oct 7, 2007
SQL was installed w/o reporting previously by the other admin. How do i enable the reporting now?
View 6 Replies
View Related
Sep 16, 2015
How can we create a checkbox in SSRS and how can it be enabled disabled based on the value.
View 5 Replies
View Related
Apr 2, 2010
I have an SSRS 2005 report that I want to enable for multi value. However, I always run into the issue with the way it passes multiple values. How exactly do I get a multi-value parameter setup and working on both the report AND SQL side?I used the MS example of checking the multi checkbox for the parameter and then using a WHERE Column IN (@MultiParam), but this doesn't work. When you select one item, or is it multiple I can't remember, it fails.
View 29 Replies
View Related
May 29, 2008
Hello,
On the desktop, it is possible, through an OS setting, to automatically encrypt SQL Server 2005 databases with FIPS 140-2 compliant encryption algorithms.
My question is; is it also possible to do this with SQL Server 2005 Compact Edition database files on mobile devices?
Thanks!
View 1 Replies
View Related
Aug 30, 2007
Hello!
I am developing with .NET 2.0 and SQL Sever 2005 on WinXP for a production system of Windows 2003 Server with FIPS enabled (http://www.itl.nist.gov/fipspubs/).
When our team tries to use SqlDependency, we get FIPS exceptions. I assume that this is because the inner workings use encryption algorithms that are not FIPS-compliant. Is there a way to configure my application (or even the entire machine) such that SqlDependency will use FIPS-approved encryption?
I guess my real question is how can I use SqlDependency on a FIPS-enabled machine?
We have been using SqlNotificationRequest, but I'm now developing a client, of which, we require multiple instances. So we've run into the problem where when multiple clients run, only one will receive and process a notification.
Thanks!
John
View 15 Replies
View Related
Dec 8, 2006
Is SQL Server CE's encryption capability FIPS 140-2 compliant?
View 1 Replies
View Related
Aug 3, 2009
How to enable ADFS for SSRS 2008?
View 4 Replies
View Related
Mar 7, 2006
How do I enable remote errors for Reporting Services 2005?
View 5 Replies
View Related
May 18, 2015
I have a couple of Power View reports that I cannot enable the data refresh schedule for. I cannot pinpoint what caused the schedule to stop working but the scheduled data refresh for these reports used to work and now they don't. Every time I try to enable a schedule the page submits and it seems like everything worked (no errors). However, when I go back to the schedule page for the report the Enable checkbox is unchecked. There are other Power View reports that are scheduled and running just fine. The only error I can track down in the SharePoint logs is this:
Failed to remove workbook tracking handle from collection for workbook
I've tried making a copy of the file and re-uploading with a different name but nothing changes. The user would really rather not recreate the report from scratch.
View 4 Replies
View Related
Sep 14, 2015
Is there a way to make the View Report disabled or enabled if certain condition exists?
View 3 Replies
View Related
May 19, 2015
How to enable http for SSRS service in my current sharepoint 2013 environment with https.
this is needed as we have a limitation in SSAS: We cannot specify HTTPS in the Analysis Services Report Action.
View 3 Replies
View Related
Jun 9, 2015
My Report service account, by default "Network Service" in the config manager.
some of my onsite people my mistakenly changed the SSRS service account to the "Local system".
when I am trying to change it back, Manager is ask to create the dialog box 2(encrypt key) given below...
When try to create the encrypt account , report server is stopped working..I had changed the properties of the reporting services also..
View 3 Replies
View Related
Jun 13, 2007
Hello All
I was working on Sql reporting services using MSQL 2000
2 years back. I was on a break for the last 2 years and want to get back to Reporting now
Can somebody guide me with the latest versions I need to learn
Is there a lot of diffrence between SQL 2000 and latest 2005
What's the latest verion of Reporitng Services
Can somebody provide links or information where I can download latest SQL reporting sevices
Any help is appreciated
Thanks
View 1 Replies
View Related
Feb 22, 2007
I had to make room on the system partition so I uninstalled SQL 2005 Ent. and reinstalled it in a different partition, which is mounted in c:apps. Since doing this, although MSSQL works fine, RS does not respond. During the reinstall, Setup reported that RS was "installed but not configured". I ran the RS Configuration Mgr and went through the config sequence. However, on the Initialization page, which has a red 'x' in the left panel, the local server is not listed -- the grid is empty.
The RS service is running, using the same credentials as MSSQL, the admin account .SQLExec. It logs a normal startup in the Event Log. However, on visiting http://localhost/Reports, I get a message saying that Reporting Services is not responding. SP2 installed OK on the system, and reported that all components were upgraded.
How can I debug this installation?
View 10 Replies
View Related
Jun 15, 2006
I have been working for days to translate a report out of an old system and in SQL reporting services.
Getting the basic code down to get the required data was easy, however getting it to work in reporting services has turned into a nightmare.
Why, because I have been told that SQL reporting services does not allow temporary tables...HUH!
Ok, so how am I supposed to take three data queries and munge them together into a report.
Here is the query that does work, can anyone give me an idea of how to make this work given the limitations I have run up against.
I have already thought of using a store procedure, but we have ruled that out since would likely have to do it via linked servers, which would be expensive. We thought of having it just create and then link real tables and then delete them...not sure thats going to work, and again probably talking linked servers to get that to work.
Code:
select distinct al3.asg_location into ##tmp1
from dbo.probsummarym2 AL3
inner join dbo.probsummarym1 AL1 on AL3.number=AL1.number
where AL1.assignment='international client services'
AND AL1.status='Closed'
AND AL1.close_time BETWEEN {ts '2006-05-28 00:00:00.000'} AND {ts '2006-06-04 00:00:00.000'}
and al3.asg_location is not null
SELECT AL3.asg_location as asg_location, Count (AL3.resolve_met) as met_sla into ##tmp2
FROM dbo.probsummarym1 AL1, dbo.probsummarym2 AL3
WHERE (AL3.number=AL1.number)
AND (AL1.severity_code<>'Scheduled'
AND AL1.status='Closed'
AND AL1.close_time BETWEEN {ts '2006-05-28 00:00:00.000'} AND {ts '2006-06-04 00:00:00.000'}
AND AL3.resolve_met='t'
AND AL1.assignment='international client services'
)
GROUP BY AL3.asg_location
SELECT AL3.asg_location as asg_location, Count (AL1.status) as sch_closed into ##tmp3
FROM dbo.probsummarym1 AL1, dbo.probsummarym2 AL3
WHERE (AL3.number=AL1.number)
AND (AL1.assignment='international client services'
AND AL1.severity_code='Scheduled'
AND AL1.status='Closed'
AND AL1.close_time BETWEEN {ts '2006-05-28 00:00:00.000'} AND {ts '2006-06-04 00:00:00.000'}
)
GROUP BY AL3.asg_location
SELECT AL3.asg_location as asg_location, Count (AL1.status) as unsch_closed into ##tmp4
FROM dbo.probsummarym1 AL1, dbo.probsummarym2 AL3
WHERE (AL3.number=AL1.number)
AND (AL1.assignment='international client services'
AND AL1.severity_code<>'Scheduled'
AND AL1.status='Closed'
AND AL1.close_time BETWEEN {ts '2006-05-28 00:00:00.000'} AND {ts '2006-06-04 00:00:00.000'}
)
GROUP BY AL3.asg_location
select ##tmp1.asg_location, ##TMP3.sch_closed, ##tmp2.met_sla, ##tmp4.unsch_closed
from ##tmp1 left outer join ##tmp2 on ##tmp1.asg_location = ##tmp2.asg_location
left outer join ##tmp3 on ##tmp1.asg_location = ##tmp3.asg_location
left outer join ##tmp4 on ##tmp1.asg_location = ##tmp4.asg_location
group by ##tmp1.asg_location, ##TMP3.sch_closed, ##tmp2.met_sla, ##tmp4.unsch_closed
order by ##tmp1.asg_location
drop table ##tmp1, ##tmp2, ##tmp3, ##tmp4
View 21 Replies
View Related
Jan 10, 2007
In Sql Reporting Services 2005 (This is bolded because this same error is all over the web for Sql Reporting Services 2000 and thats not where my problem lies) I schedule a report to be emailed. However when the delivery extensions Deliver method is called I get the following error
Failure sending mail: The report server has encountered a configuration
error. See the report server log files for more information.
In the log it shows the following
ReportingServicesService!emailextension!4!01/10/2007-12:21:01:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid) at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation) at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
So it seems to be failing at GetAuthzContextForUser
I've set up my smtp as out domain email smtp, given the accounts all the permissions I could (Even going to far as to give Everyone permissions everywhere)
Currently my IIS, SQL 2005 and reporting Services 2005 as well as my local SMTP is running on the local machine account.
I cannot seem to get it to work, or even give me a different error.
Could anybody please tell me what needs permission where and what settings I need to have set up for this not to happen.
Some extra information
I'm using Windows XP to develop on however the server where this will eventually run is Windows Server 2003
I'm using ASP.NET 2 and SQL Reporting Services 2005 and SQL 2005 with sp1 loaded
Any help would be appreciated
View 1 Replies
View Related
Nov 4, 2010
I have created a report that sharing two datasets for displaying the data. This datasets are using Stored procedure for execution of the report.One of the stored procedure using Order by clause and returning the data.But on running the report , the report viewer displays the unsorted data of the filed. But if we run the stored procedure directly from the sql server , it will return the sorted data.
View 8 Replies
View Related
May 20, 2015
sql server edition-2008 enterprise evaluation edition
Operating System- Window Server 2008 R2
I've Created Local Smtp to use gmailid for Subscription of SSRS Report by Email as we don't have an Exchange Server.
User this link to Create local SMTP
Studied few blogs that related it to agent service running under local system account, on my machine it was running on NT/NetworkService change it to Administrator of local Machine. Did same change for Database Engine of Service of SQL Instance.
FYI- My Machine is not in Domain, so used local administrator for giving rights to service mentioned above.
Below is the Screen Shot of rsreportserver.Config File
ERROR : on Report Manager
Below is report log on after time report was executed.
library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 executed at 05/20/2015 13:19:05.
schedule!WindowsService_16!2b30!05/20/2015-13:19:05:: Creating Time based subscription notification for subscription: ea7fc6ce-00df-4f6a-9050-e713986307ca
library!WindowsService_16!2b30!05/20/2015-13:19:05:: i INFO: Schedule 3374e590-8374-4360-b5da-d487eacb0417 execution completed at 05/20/2015 13:19:05.
[code]....
PS: Local SMTP is working, i.e. i am able to receive email if i place an email.text file in C:inetpubmailrootpickup
View 7 Replies
View Related
Nov 22, 2015
I have a working set of parameters, when they are all visible. However, when I change the second parameter to hidden it stops working.
First Parameter - Contains static values 'MTD' & Daily
Second Parameter - has available values and a default. Set up to be invalidated when the First parameter changes... like i say it works beautifully when not hidden.
Third Parameter - has an expression takes the value of the 2nd parameter value, removes the first character off and then converts the remainder to a date and uses it as its default value.
It based on this webpage: URL....However, when i set the second parameter to hidden it no longer works.
View 2 Replies
View Related
Oct 1, 2015
We are facing an issue related to SSRS 2012. We have Reporting Services 2012 configured on a couple of servers. On one server, we have created Datasources and Data-driven subscriptions for our reports and selected email as the report delivery option. But the subscriptions are not working. The LastRunTime column is NULL in the Subscriptions table in the ReportServer database and no email is being triggered. Also, no error message is displayed. The same reporting solution is working on another server that also uses Reporting Services 2012.
View 14 Replies
View Related
Nov 26, 2006
I installed the SQL Server Express Advances w/ Reporting Services, but it doesn't appear to be working. When I bring the URL up in my web browser all I get is this:
transam/ReportServer$SQLExpress - /
Microsoft SQL Server Reporting Services Version 9.00.2047.00
Any tips on where to begin looking for what is wrong?
Robert
View 1 Replies
View Related
Sep 7, 2015
We had migrated the SSRS reports from 2008 R2 to SSRS 2012 SP2 version. We had a strange issues after migration.
The report which is having images is not working and it just hangs.
The reports which doesn't have any images are working fine.
On top of it some times we are getting the following error message.
Error message : The request failed with HTTP status 503: Server Error.
View 4 Replies
View Related
May 28, 2015
I am using SSRS 2008. I have 3 applications specific reports deployed to reporting manager..AAA , BBB and CCC - be my Applications for example.i have 3 different application users. i want to grant access the respective application users to access respective reports.i mean application user A should not be able to access/view reports from BBB and CCC. similarly for B and C application users.HOw this can be implemented ?
View 2 Replies
View Related
Nov 4, 2015
I have a simple matrix with a row group that is basically a name. I want to sort a list of 10 or so names based on a count. I also have a column grouping -basically 1 years worth of month end dates. I want to sort on the count on the most recent date, so I set the expression to:
=IIF(Fields!week_ending.Value = MAX(Fields!week_ending.Value, "customer_2015_select"), COUNT(Fields!application_id.Value), -1)
And then Sort Z-A. It allows the expression, but doesn't sort the values correctly. It doesn't seem to be picking up the date.
View 6 Replies
View Related
Apr 23, 2015
I have created two report parameters and want them as Cascading. District Parameter depends on Region Parameter which should allow Multi selection. When I select single value in Region it works perfectly. But when I choose multiple values, District turns out to be a blank text box. I have used the In clause in my code :
SELECT
DISTINCT
SalesDistrict
FROMDistrict(NOLOCK)
WHERESalesRegion
IN(@SalesRegion)
View 2 Replies
View Related
Oct 25, 2011
I am trying to push the install for ReportBuilder 3.0 and am having an issue with the REPORTSERVERURL option for installing via command line.I have a batch file that works fine, however when I launch the app it does not have a report server configured. I have verified I can connect to my report server if I enter it manually.
View 3 Replies
View Related
Jun 24, 2015
I developed one dynamic column (matrix) report. while export to excel it 's show same output as SSRS have. but while exporting CSV pivot column not coming as same as Excel and SSRS screen. data is moving to rows.
Please see below screen shot ....
View 3 Replies
View Related
Aug 10, 2015
I have designed a report in which there are 6-7 charts. I want to print each chart in a new page. For this I have inserted page break after each chart. After this the report is populating fine but when I am exporting the report in pdf the page break are not working.
View 4 Replies
View Related
Mar 2, 2012
VS 2008. I have the following set up. Group1, Group2, Group3 header, Group 3 detail rows..When I set the row visibility (hide based on Group2) on the Detail row, it still shows up when the report is originally rendered.
It should be: Group1 expanded, Group2 collapsed, Group3 header hidden and detail rows hidden
It is showing: Group1 expanded, Group2 collapsed, Group3 header hidden, Group3 detail row visible.
I never had this trouble in 2005. Is there something different about row visibility in 2008?
View 3 Replies
View Related
Jan 31, 2011
Currently i am working on SSRS 2008 R2.The issue is that it is wrapping long words and not growing. I set the property can grow to True.
How to prevent the word wrapping?
For example, the column will have the word "information" in it. Instead of the column showing:
information
it shows:
informatio
n
The "n" gets wrapped to the next line. Is there a way to prevent this from happening.
How to prevent the word wrapping?
View 4 Replies
View Related
Nov 20, 2015
Here I am trying to do switch then nested IIF in it. I dont know where i missed but this doesnt work.for first condition in switch, 'WEEKLY', WW2 and WW1 is in number form but of text/string datatype. so after cast them to integer/number datatype then those are use in iff operation.for second condition in switch, 'MONTHLY', WW2 and WW1 is month name. so the objective is to get month number from month name. After that, then WW1,WW2 are use in iff operation.
=SWITCH(Parameters!date_range_type.Value
= "WEEKLY", IIF((cInt(Parameters!WW2.Value) - cInt(Parameters!WW1.Value)) > 10, Parameters!WW1.Value,IIF(cInt(Parameters!WW2.Value) < 11,1,cInt(Parameters!WW2.Value) - 10)), Parameters!date_range_type.Value = "MONTHLY", IIF((cInt(MONTH(datepart("YYYY",today())&
"-" & Parameters!WW2.Value & "-01")) - cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW1.Value & "-01"))) > 10, MONTH(datepart("YYYY",today())& "-" &
Parameters!WW1.Value & "-01"),IIF(cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value & "-01")) < 11,1,cInt(MONTH(datepart("YYYY",today())& "-" & Parameters!WW2.Value
& "-01")) - 10)) )
if i run report for 'WEEKLY' only, means doesnt need switch and the other iif condition, it working fine. so does when run on 'MONTHLY' only.
View 2 Replies
View Related
