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 […]
New conference, new format, designed for Business Analytics professionals in the Microsoft space. Chicago 2013, April 10-12 (Full Conference), with an optional Pre Conference day beforehand for a sum extra. Register here (Best rate for registration finishes December 7, 2012) : http://passbaconference.com/Register.aspx
You attempt to Build your Analysis Services solution but get a “object reference not set to an instance of an object” error when you try the Build function. This can be any number of things but as a guide you can try checking the following within your SSAS solution : DSV – Check the DSV […]
Handylink to locate the download URLs for the VSphere client – thanks Chris ! http://chall32.blogspot.com.au/2011/10/vmware-vsphere-client-download-url.html If you are chasing just the regular VM player you can download her http://www.vmware.com/products/player/.
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 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 […]
Top read and good advice from Jen McCown for first time attendees at SQL Pass Summit 2012 ! I particularly like the “talk to people” bit as thats where I found most of the value in attending last conference 🙂 http://www.midnightdba.com/Jen/2012/10/pass-first-timers-guide-and-schedule-2012-edition/