Report Portal

I have a Win2008R2 server with SQL 2008

I have a Win2008R2 server with SQL 2008 and SQL 2005 (named instance) but running netstat -n -b didn't show either of the SSAS services even though both were running. Not sure why. However, when I tried to connect to the 2005 instance in SSMS, the error message showed what port it was trying to hit. Since the firewall is enabled by default on Win2008 I had to create an exception for this port and all was well at this point. NOTE: In my case I hit 2 errors (one after another) in SSMS but in each case the error message showed the port # it was trying to use. Once I created rules for both of these ports connectivity was working from my laptop to the remote instance.

 

2007-2015 VidasSoft Systems Inc.