Monday, February 13, 2012

Analysis Services not Started!

Good Day!

I have installed SQL Server 2005

In services.msc SQL Server Analysis Services (MSSQLSERVER) can't be started.

Message: Service Started and then Stopped and

The service cannot be started: The following system error occurred: Only one usage of each socket address (protocol/network address/port) is normally permitted.

What is this?

Thanks...

Some application occupied AS TCP port. In case of default instance it would be 2383. Please run netstat or (even better) tcpmon to find out what this application is.|||

Wow.

It seems like SQL Analysis Services can't live with started SAP on the Machine.

What ports use Analysis Services?

|||

Default instance uses port 2383.

The redirector for named instances uses port 2382.

Ports for named instances can be manually overriden.

|||

Ok

Where can I change instance port for Analysis?

|||Server -> Properties -> Show All (advanced) properties -> Port|||

Mosha Pasumansky wrote:

Server -> Properties -> Show All (advanced) properties -> Port

Sorry for borring, I'm a novice.

Where is it? I'm going in Computer Managment -> SQL Server Configuration Manager -> SQL Server 2005 Services -> SQL Server Analysis Services ->Properties

But there nothing...

|||

You need to go to SQL Server Mgmt Studio> Connect to Analysis Services>Right Click on the server-> Hit Properties> Scroll down and check the box "Show Advanced(All) properties" and then you will see the property "Port"

No comments:

Post a Comment