SSAS IP

  • SSAS connection - working with vendor to get connection thru AWS to our sql servers and ssas instance (which is named instance ssasname\ssastab. They can connect to the sql servers fine through the IP. However having tough time finding ip for ssas instance, you can't ping the ssas named instance even when on our nextwork (i can attach to named instance fine in SMS with the name) WHat am I missing?

  • The IP of the SSAS instance will be the same as the IP of the server that's hosting it. You'll have to include the instance name like you've been doing, even when using the IP address. Some of the things that may be happening:

    • If you're using a non-standard port for SSAS, it needs to be included in the connection string. If the SQL Server browser service is turned off, you may have to do this in any event. 
    • Your network settings on the VM that's hosting SSAS, may not be allowing traffic from your client or for the SSAS port (standard is 2383). Make sure that you have the necessary networking rules set up.
    • Make sure that you're using Windows Authentication. If the client machine is not in the same domain, you'll probably have to use "runas" to impersonate a domain account. This is of course assuming that you're trying to access the instance via something like SSMS.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply