Solved

connect to a SSAS 2005 not on AD?

Posted on 2008-06-23
5
108 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
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Nazermohideeen
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thx a lot.... just what i needed.

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now