• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

connect to a SSAS 2005 not on AD?

Hi All

In SQL Server 2005 you can only connect to SSAS with windows Authentication - this gives me quite a headache L
My database servers are located in our hosting center and are NOT part of a AD network. At the office however Im on a AD server and login on my laptop as a domain user.

Is there any way at all for me to connect to the SSAS instance on the server?

Thx a lot
0
nicolajsb
Asked:
nicolajsb
  • 2
  • 2
1 Solution
 
NazermohideeenCommented:
You need to configure the SSAS for HTTP access and access it through browser

if your server is running Windows 2003
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

if your server is running Windows XP
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx


Hope this helps
NM
0
 
nicolajsbAuthor Commented:
Ahhh I forgot to say that I'm talking about connecting from management studio to SSAS....
0
 
NazermohideeenCommented:
you still need to configure HTTP access, and then in the Management studio, type the Http url, in the server name.
NM
0
 
nicolajsbAuthor Commented:
Thx a lot.... just what i needed.

Btw. I'm very sorry for the late response on this answer!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now