Solved

connect to a SSAS 2005 not on AD?

Posted on 2008-06-23
5
120 Views
Last Modified: 2016-02-12
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
Comment
Question by:nicolajsb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Nazermohideeen
ID: 21844954
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
 

Author Comment

by:nicolajsb
ID: 21845084
Ahhh I forgot to say that I'm talking about connecting from management studio to SSAS....
0
 
LVL 4

Accepted Solution

by:
Nazermohideeen earned 500 total points
ID: 21845116
you still need to configure HTTP access, and then in the Management studio, type the Http url, in the server name.
NM
0
 

Author Closing Comment

by:nicolajsb
ID: 31469659
Thx a lot.... just what i needed.

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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question