Viewing 15 posts - 241 through 255 (of 966 total)
To create a subscription, the report must use stored credentials.
June 16, 2015 at 1:53 pm
How are permissions on the report setup for the report data source(s)? If it is using Windows integrated security do the new users have access to the back-end data source(s)?
June 16, 2015 at 1:49 pm
If you go to the report on the Report Manager interface, click the drop-down and select "Manage" you should be able to see the data sources the report is using....
June 16, 2015 at 1:48 pm
The Reporting Services trace logs are at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. As for the Reporting Services execution log, that is a table in the ReportServer database. I would...
June 16, 2015 at 1:34 pm
If the cluster is running on Windows Server 2008 R2 I second this. In fact there are a whole load of patches recommended for running AlwaysOn Avialability Groups on Windows...
June 15, 2015 at 2:25 pm
Since OLEDB is deprecated and because MultiSubnetFailover is not supported in OLEDB anyway, I have come full circle back to ODBC and must now create ODBC connections for ETL. (ADO.NET...
June 15, 2015 at 2:22 pm
If you can manually run the code to troubleshoot it try adding print statements at different levels within both stored procs. That way when you go to execute it you...
June 15, 2015 at 2:11 pm
I also agree with the use of rectangles. They are an organization tool and are meant for this purpose.
The only thing I have to watch out for with rectangles is...
June 15, 2015 at 1:50 pm
That does sound weird. HTTP 500 errors are specifically server errors so one would think that something would show up in either the Application, IIS, RS trace or RS execution...
June 15, 2015 at 12:33 pm
Can you posts errors from the SQL Server Error Log with more details? It might shed some more light on the situation.
June 14, 2015 at 3:11 pm
I second setting up mirroring (or log shipping if you have to).
Remember to check for other items you might need to bring over as well:
SQL Agent jobs
Maintenance plans
Server-level triggers
etc.
June 14, 2015 at 3:09 pm
Hi All,
I have installed a SQL Server cluster recently.
Noticed below errors logged in the error log. I understand that SPN is not getting registered, hence this error.
What permissions SQL Server...
June 14, 2015 at 3:07 pm
It is important to note that SSDT is a little bit of an ambiguous term. SSDT is included on the SQL Server 2012/2014 media, but it is concerned with adding...
June 14, 2015 at 5:32 am
Did you try installing the following?
Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013
June 14, 2015 at 2:23 am
Viewing 15 posts - 241 through 255 (of 966 total)