Monday, May 27, 2013

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal:

'via Blog this'

delete orphaned sql jobs


--select * from sys.master_files order by physical_name

select * from dbo.sysjobs
select * from dbo.sysmaintplan_subplans

delete from dbo.sysmaintplan_subplans where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

delete from dbo.sysmaintplan_log where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

--sp_help sysmaintplan_subplans

delete from sysjobs where job_id='B3FECCA3-A0D2-4BEA-88D6-685EBE2F1164'

Tuesday, April 30, 2013

BizTalk 2013 and SharePoint 2013

There is no need to install the sharepoint web service adapter...the default biztalk installation already get the connectivity to sharepoint 2013 without installing anything on the sharepoint server :-)

Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)

I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...