What ports are your SQL Server services are running ?

You need to know which ports your SQL Server services are running.  This could be for Kerberos constrained delegation to Data Sources or to allow access through Firewalls.  Either way, the following guide explains how to go about this for your Analysis Services Service, and a similar process can be used to find ports for […]

Where are my Reporting Services 2012 Integrated end points and log files ?

A good article outlining the location of end points in Reporting Services 2012 integrated mode and how the various bits and pieces talk to each other. http://blogs.msdn.com/b/jtarquino/archive/2012/06/13/sql-server-reporting-services-2012-sharepoint-integrated-mode-endpoints-architecture-or-how-our-services-talk-each-other.aspx Includes an outline about how to check the Sharepoint Timer job which is used for Reporting Services 2012 Alerting. http://blogs.msdn.com/b/jtarquino/archive/2012/05/07/the-sql-server-reporting-services-2012-timer-job-in-sharepoint-mode.aspx If you are looking for Log files, these […]

SQL Server 2012 Service Pack 1 and SSDT Automatic Update Feature

SQL Server 2012 Data Tools gets an automatic update feature included in Service pack 1 for Microsoft SQL Server 2012 ! This is an excellent feature as most people update the server, but forget to update their workstations with the latest and greatest offerings that come with the general update. Once Service pack 1 is […]