SQL Server 2382 Port issues

Source: Internet
Author: User

The official sample database adventureworksdw2008r2 and its OLAP project were downloaded in Microsoft two days ago:AdventureWorks 2008R2 Analysis Services Project You can go to Microsoft download "

Deployment Error Warning: 2382 error, referring to the bids deployment processing cube today

http://bbs.csdn.net/topics/370083185 changed with Windows authentication, nor okay

Https://msdn.microsoft.com/zh-cn/library/hh510203.aspx

Https://msdn.microsoft.com/zh-cn/library/ms174937.aspx

And then in SSMs want to connect as also failed, this is also the error prompt, cmd command only 1433 port is monitored, no SSAS PID service and port status,

The server does not have a process listening on port 2383, indicating that the port is not open,

Not like a variety of netizens said the firewall blocked, the verification found that

TaskManager inside the Masqlserverolapservice service does not open, nor run, in addition to the SQL Server Configuration tool, the SQL Server service is not turned on, indicating that the remote call failed:

Various indications:

The problem is that the SQL Server service!!!

So solving this problem first is the key: http://jingyan.baidu.com/article/9f63fb91d436b4c8410f0e5c.html,

Uninstall Microsoft SQL Server (+) Express LocalDB, and then open SQL Server Configuration Manager, refresh, normal-all normal, haha ~ ~

Next, you can learn to use the sample database and the as project to learn and create your own SSAS project.

SQL Server 2382 Port issues

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.