question

Håkan Winther avatar image
Håkan Winther asked

How do I connect to a Analysis service with portnumber?

Our client have specified a different port number than the default and the firewall is not open for SQL Browser service. How do I connect to the analysis service with the specified port number? In SQL server management studio you specify the port with this syntax sqlservername,1433 for the database, but it doesn't work with analysis service.

(I can give you a hint, Microsoft doesn't follow any standard, not even their own, and I think it is important to share this knowledge to everyone)

sql-server-2005ssasseeder-question
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Håkan Winther avatar image
Håkan Winther answered

Analysis service is using a different syntax than the database service, in the same tool (Management Studio). To connect to Analysis service you use this syntax sqlservername:portnumber instead of sqlservername,portnumber.

Why? The syntax for analysis service is following the standard for portassignment, but database services is not! It should be hard for Microsoft to allow the same syntax for the database services!

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.