设为首页 收藏本站
查看: 1008|回复: 0

Configure Windows Firewall for SQL Server 2008 Analysis Services in Windows Serv

[复制链接]

尚未签到

发表于 2015-4-30 12:18:49 | 显示全部楼层 |阅读模式
  Problem
  I have installed SQL Server 2008 Developer Edition on Windows Server  2008 R2 and I am unable to get connect to SQL Server 2008 Analysis  Services Instance from SQL Server 2008 Management Studio which is  installed on another remote server. As I am new to Windows Server 2008  R2 it would be great if you can let me know the step by step approach to  enable the default port of SQL Server 2008 Analysis Services in Windows  Firewall for user connectivity.
  Solution
  Windows Firewall helps prevent unauthorized access to computers in  the network. By default, windows firewall will be turned ON once the  operating is installed. If a firewall is turned ON and if it is not  configured correctly then attempts made by the users to connect to SQL  Server Analysis Services will be blocked.
  In order to access an instance of SQL Server Analysis Services which  is behind a firewall, database administrator needs to configure the  firewall on the computer that is running SQL Server Analysis Services to  allow users access. In this tip, we will go through the steps that you  need to follow to quickly configure windows firewall in Window Server  2008 or in Window Server 2008 R2 to allow SQL Server Analysis Services  access to users.
  1. Click Start | All Programs | Administrative Tools | Server  Manager. This will open up Server Manager as shown in the below snippet.
DSC0000.png
  2. In Server Manager, expand Configurations tab and then expand Windows Firewall with Advanced Security. Right click Inbound Rules and click on New Rule... as shown in the below snippet to open up New Inbound Rule Wizard.
DSC0001.png
  3. In New Inbound Rule Wizard's Rule Type Page, you need to select Port option as shown in the below snippet to control connections for a TCP or UDP Port. Click Next to continue with the wizard.
DSC0002.png
  4. In Protocol and Ports, specify the protocols and ports to  which this rule applies. As we know, SQL Server Analysis Services when  installed as a default instance will use TCP Port 2383 as the default  port, hence you need to choose TCP option and then specify the port  number as 2383 as shown in the below snippet. Click Next to continue  with the wizard.
  If you have installed Analysis Services as a named instance on the  server, then Analysis Service will be assigned a dynamic port. In such a  scenario, you need to make sure that SQL Server Browser Service is  running and the UDP Port 1434 which is used by SQL Server Browser  Service is open in the windows firewall. Secondly, you need to make  sure that you have opened TCP Port 2382 in the windows firewall,  so that the clients can connect to the SQL Server Browser to be  redirected to the named instance of SQL Server Analysis Service or else  the dynamic port which is used by Analysis Service Named Instance should  be open in windows firewall.
DSC0003.png
  5. In Action page, specify the action to be taken when a  connection matches the conditions specified in this rule. There are  basically three options available to choose from which are self  explanatory.
a) Allow the connection
b) Allow the connection if it is secure
c) Block the connection
  Here, you need to choose the first option which is Allow the connection and click Next, to continue with the wizard.
DSC0004.png
  6. In Profile page, specify the profiles for which this rule  should apply. There are three options available to choose from which are  self explanatory.
a) Domain - Applies when a computer is connected to its corporate domain
b) Private - Applies when a computer is connected to a private network location
c) Public - Applies when a computer is connected to a public network location
  Here you need to choose the first option which is Domain as  you want everyone who is connected to its corporate domain to get  connected to the SQL Server Analysis Services Instance as long as they  have permissions to connect to the SQL Server 2008 Analysis Services  Instance. Click Next, to continue with the wizard.

  7. In Name Page, you need to provide a meaningful name and  also provide a meaningful description as shown in the below snippet and  click Finish to complete the wizard.

  8. Once the wizard configuration is complete, you will be able to see  the new rule available under Inbound Rules as shown in the below  snippet.

  9. Now you will be able to connect to your SQL Server 2008 Analysis  Service Default Instance from remote SQL Server 2008 Management Studio.

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-62269-1-1.html 上篇帖子: ASP.NET development sever 在Windows server 2008/Vista显示页面无法找到 下篇帖子: Windows Server 2008 Standard Enterprise Datacenter各个版本区别
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表