Link to home
Start Free TrialLog in
Avatar of nicolajsb
nicolajsb

asked on

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
Avatar of Nazermohideeen
Nazermohideeen

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
Avatar of nicolajsb

ASKER

Ahhh I forgot to say that I'm talking about connecting from management studio to SSAS....
ASKER CERTIFIED SOLUTION
Avatar of Nazermohideeen
Nazermohideeen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thx a lot.... just what i needed.

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