Viewing 15 posts - 31 through 45 (of 352 total)
Jeff - thanks for your reply. Question - in a D/R recovery scenario, once I restore all my system DB's & application DB's (including SSISDB and Distribution DB) onto my...
August 28, 2018 at 5:49 am
August 1, 2018 at 5:37 am
I embedded my original commandinto the -Invoke-Command ----- and specified the -ComputerName followed by the -ScriptBlock contents which was my original command.
Working Example:
Invoke-Command -ComputerName MyComputeName1...
July 5, 2018 at 7:21 am
I found the answer to this question. I brought up SSDT, opened my SSRS Solution, clicked on "VIEW" on the toolbar, and clicked on the last item in the popup...
June 26, 2018 at 6:05 am
thx for the quick reply. When I look at my txt box properties (text box is named [Active]), I right mouse click, then click fx Expression, I see: =Fields!Active.Value
What...
May 24, 2018 at 7:23 am
so far so good.. and I used this solution: https://www.mssqltips.com/sqlservertip/3469/install-and-configure-sql-server-reporting-services-2012-sp1-and-2014-in-sharepoint-integrated-mode-part-1/
Multiple parts:
– installation of Reporting Services in SharePoint-integration mode
- installation of the Reporting Services Add-In
- installing...
April 6, 2018 at 12:27 pm
thanks for your reply. I requested 2 new IP's (as we use multi-subnet failover from 1 data center to another w/ D-DNS) and your info set me straight. My 2nd...
March 15, 2018 at 8:30 am
We have an internal BI group in our company who wrote a 'black box' app (API ?) to connect to Hadoop from SQL Server therefore I never utilized the solution...
March 7, 2018 at 6:47 am
re-created the error using these exact steps:
- removed the subscription from both SQL nodes of the AoAG -- completely (fresh start)
- confirmed my subscriber database is in...
February 15, 2018 at 6:12 am
Thank you for the link. Unfortunately, that link contains all the info I used during my setup. All works fine and dandy UNTIL you failover the AoAG to the other...
February 14, 2018 at 2:59 pm
Leo - thanks for documenting this solution. Following up on the typo:
--> There's a declare scaler variable missing for @_Source_NM within the uspAG_DisableEnableJobsandAlerts SP
Do you have a...
January 19, 2018 at 6:18 am
On our SQL 2012 Enterprise SSRS instance, the DIR C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\RSTempFiles was filling up our 80 GB C: drive w/ 65 GB of RSFILE_xxxxxxx files
As I...
December 21, 2017 at 5:13 am
thanks for your reply Sue... Actually, I went ahead and manually added my 15+ Publishers in SQL 2017 ReplMonitor.. took me about 3 minutes..
November 11, 2017 at 5:18 am
thanks, yes - that was my issue -- Using Windows Integrated Auth... I went back and added the appropriate A/D groups as db_datareader on the database itself and it's...
July 31, 2017 at 7:27 am
ALSO -- the error the user receives is:
July 31, 2017 at 5:54 am
Viewing 15 posts - 31 through 45 (of 352 total)