Recently installed SSAS 2008 R2 on a server. I couldn’t connect to it from SSMS via a separate computer. Tried to figure but couldn’t resolve it. Then I realized that I haven’t set the port and maybe that might be the issues.
I launched SSMS on the box where SSAS is installed.
- Connected to it
- Right click and select properties
- Check Show Advanced (All) Properties in the bottom
- Scroll down to PORT and change the Value.
- Click OK
But in IT nothing is that simple. I was supposed to enter 2393 but ended up entering 2382. Don’t ask why it happened but it happened. So right after you change the port, it needs to be restarted
I restarted the service and it would not come online. I looked in the event log and found this error
-
System-
Provider
[ Name]
MSOLAP$P1
-
EventID
0
[ Qualifiers]
49441
Level
2
Task
289
Keywords
0x80000000000000
-
TimeCreated
[ SystemTime]
2014-02-13T19:25:41.000000000Z
EventRecordID
41775
Channel
Application
Security
-
EventData
The following system error occurred: Only one usage of each socket address (protocol/network address/port) is normally permitted. The following system error occurred: Only one usage of each socket address (protocol/network address/port) is normally permitted.
So basically 2382 is port where SQL listens for connection request so that is why the service was not starting. I looked online and after much research, I found that file “msmdsrv.ini” file. If open the file, change the value to 0 (dynamic) or the port you want to assign which in this case was 2393. Once I changed the file saved it, the server restarted.
I hope this is helpful
No comments:
Post a Comment