jump to navigation

SSAS named instance February 2, 2010

Posted by msrviking in Security.
trackback

Here is what I have learnt today while configuring a static port for a named instance of AS for one of my clients.

As per best practices for Security guidelines given by MSFT, SQL Server Browser could be disabled and to connect to named instance of Analysis Services we would need a static port. It was fun doing this although there are good steps around in BOL, and few other links.

However for benefit of having this stored in a knowledge repository I decided to list down steps clearly in here.

1) Goto SQL Server configuration manager and over the named instance in the SQL Protocols, click on the TCP/IP.

2) Under protocol table make the “Listen All” to “No”.

3) Under IP Addresses tab, make “TCP Dynamic Ports” to blank from “o” for IP1, “Enabled” value to “Yes”. Also don’t forget to put in a value “TCP Port”.

4) Under IP 2, set “Enabled” to “No”, and in IP All set TCP Dynamic Ports to blank from “o”, and the TCP Port to the port number you want listen.

5) And before restarting the service ensure that you put the port number you want to listen in the server property page of analysis services.

At the end restart the service, and you will have the analysis services named instance up and running, and connecting on your defined port without SQL Server Browser service running.

Some of the links that gave me leads are

http://dinesql.blogspot.com/2009/08/connecting-to-analysis-services-with.html
http://blogs.msdn.com/sqlserverfaq/archive/2009/09/08/sql-server-analysis-services-port-sql-2005-2008.aspx
http://support.microsoft.com/kb/823938
http://msdn.microsoft.com/en-us/library/cc966526.aspx

I hope this quick post helps. Enjoy!

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: