Tag Info

New answers tagged

1

Working with this setup: CREATE TABLE tbl ( tbl_id serial PRIMARY KEY , user_id text NOT NULL , start_time timestamp NOT NULL -- if values could be NULL ... , end_time timestamp NOT NULL -- ... it would be more complicated ); Total duration without redundancy Your numbers indicate you just want the total duration without counting ...


2

You only have to run in Administrator mode because you haven't added any users to SSRS. You need to grant permissions. For example on the root folder in SSRS add a windows user/group to the Browser role. For more details see https://technet.microsoft.com/en-us/library/ms156014%28v=sql.110%29.aspx


1

Is the new user allowed to send mail on the SMTP server? You can do this: Review this and make sure your setup is valid with the correct user (MSDN Link). Also check the settings in RSreportserver.config (MSDNlink).


1

Go to Programs and Features, find the Microsoft SQL Server 2012 (64-bit) entry, select Uninstall/Change, and then select Remove in the window that pops up. You select the instance you are working with: Then check Reporting Services you installed:


2

Unless you have data in your SSAS cubes that no longer exists in your source (if this is the case correct that going forward!) then you can simply install a new instance of SSAS then deploy and process your SSAS solutions from SSDT (the 2012+ replacement for BIDS). For SSRS if you have a basic install you can do the same thing - simply install the new ...


0

This turned out to have nothing to do with the Microsoft side at all. The data source we are using is a linked server to Proficy Historian and, by default, only pulls 5000 rows. You have to explicitly tell it either how many rows you want to pull, or tell it RowCount = 0 for unlimited rows. Sorry for the noise! enter link description here



Top 50 recent answers are included