Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

AaronBertrand — Mon, 18 Jul 2011 15:20:46 GMT

Thanks Marco. I have verified that SQL Browser is running, but I get this error message when trying to .Connect using PowerShell:

http://yfrog.com/kev5hp

Any ideas?

Thanks,

Aaron

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

Marco Russo — Mon, 18 Jul 2011 15:34:32 GMT

I tried my script by also using the machine name instead of localhost (like in your example) and it still works.

Are you sure that SSMS is using the same name? Just to check - is SQL Browser service active?

Marco

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

AaronBertrand — Mon, 18 Jul 2011 16:55:32 GMT

Yes, SQL browser is running. I can connect to default instances of SSAS no problem, but named instances do not work. Several people have filed before me (all closed as no repro) but I filed a new issue for Denali anyway:

http://connect.microsoft.com/SQL/feedback/details/679792/sql-browser-cannot-connect-to-named-instances-of-analysis-services

Are you using a named instance or a default instance? If both, which one did you install first?

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

Marco Russo — Mon, 18 Jul 2011 17:05:55 GMT

I have only named instance on this PC. No default instance. I installed SQL 2008 first, then 2008 R2 and then Denali. I don't know if it could be related.

Marco

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

AaronBertrand — Mon, 18 Jul 2011 18:53:54 GMT

No matter what I did with SQL Browser, it would not let me connect via the named instance. I had to go track down msdmredir.ini, find out what port number the named instance was listening on, and hard-code that in my PowerShell and SSMS connections. The instance name is never mentioned, just computer name:port number, e.g.:

$server.Connect("VM-DENALI:50560")

This works flawlessly but if you're connecting to a lot of machines then you have lots of machine/instance:port number associations to memorize. :-(

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

Marco Russo — Mon, 18 Jul 2011 22:29:26 GMT

It seems that it's really the SQL Browser not answering for some reason.

Did you check firewall? I would try writing in the SSAS forum in order to do some escalation.

re: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

AaronBertrand — Mon, 18 Jul 2011 22:35:35 GMT

Instance name works just fine from all clients/applications if I start sqlbrowser.exe manually with the -c switch.