Viewing 15 posts - 1 through 15 (of 33 total)
Resolution Steps :
-> I verified the report logs and below was the error logged :
extensionfactory!ReportServer_0-4!20f8!07/30/2015-13:15:03:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server...
July 30, 2015 at 3:29 am
I have restored the reportserver database along with the encryption keys on my local machine. I see that everything except the subscriptions. Is there any way to restore the subscriptions?
July 29, 2015 at 11:43 pm
You have to open 5022 port on both the servers
March 27, 2015 at 5:25 am
Do you have only one database on the principal server?
March 27, 2015 at 3:46 am
You can change the default data directory and provide your own path while installing SQL server for system databases.
March 25, 2015 at 7:42 am
what kind of patching is it? is it a windows update or SQL update or any database script?
March 23, 2015 at 6:24 am
1) you can create a linked server of destination server on the source , write a insert query put it in a SQL job and schedule it
OR
2) Create an SSIS...
March 11, 2015 at 9:25 am
Is the job really running? It might look as if it is running sometimes, can you run sp_who2 for that spid and check?
March 11, 2015 at 7:50 am
check if the log reader & distribution agents are running fine.. Also verify the t-log space of distribution db
March 11, 2015 at 6:44 am
DECLARE @I VARCHAR(10)
SET @I = '0745'
IF( SUBSTRING(@I,1,1)= 0)
SET @I = '0'+ CAST((CAST(@I AS INT)+15) AS VARCHAR(10))
ELSE
SET @I = CAST((CAST(@I AS INT)+15) AS VARCHAR(10))
IF( SUBSTRING(@I,1,1)= 0)
SELECT CASE WHEN SUBSTRING(@I,3,2)='60' THEN...
March 10, 2015 at 8:20 am
Create backup jobs on both the nodes and add tsql code to check for the primary replica as first step before the maintenance plan step .
If node =...
March 10, 2015 at 6:42 am
Do you have any open transactions on the primary database? what is the state of secondary database?
March 10, 2015 at 6:21 am
Taking full backup of database wouldn't truncate the log, instead you have to take a log backup to truncate the log.
March 9, 2015 at 6:56 am
March 9, 2015 at 3:19 am
Viewing 15 posts - 1 through 15 (of 33 total)