Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Connect to a Remote SSAS 2005 Database


Connect to a Remote SSAS 2005 Database

Author
Message
jacob sebastian
jacob sebastian
SSC-Addicted
SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)SSC-Addicted (472 reputation)

Group: General Forum Members
Points: 472 Visits: 2523
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2865.asp

.
cliffb
cliffb
Say Hey Kid
Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)

Group: General Forum Members
Points: 681 Visits: 438

I'd like to see a follow-up article on this regarding security and when one would use HTTP to connect vs TCP/IP over port x. I am also curious as to what issues you ran into. I've had two installs of AS2K5, one on XP one on Win2K3 when they rolled that out for all the developers and in neither case did I have issues connecting to any instances that were not related to security permissions.

That being said, it is a good walkthrough of how to setup HTTP Connectivity.

Cliff





william-505882
william-505882
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 8
Thanks for this article. It certainly did save a few hours!

Do you know of a way (using HTTP), to connect to the database engine with Management Studio in the same way? It would be great to be able to do some remote working when a customer has nailed down all the tcp/rdc options!

William.
cliffb
cliffb
Say Hey Kid
Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)

Group: General Forum Members
Points: 681 Visits: 438
There is. Look up HTTP Endpoints in Books Online. I beleive that will give you what you need.



william-505882
william-505882
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 8
Thanks Cliff, but HTTP endpoints are just another option for IIS, and require webservice webmethods setup. I was looking for a generic link which would act like the TCP connection. There is an option to connect BIDS/Management Studio to an Analysis Server for administration using http (http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx) but there doesn't seem to be an equivalent for the SQL engine.
Maybe SQL2008!
Wm.
Robert A. Booey
Robert A. Booey
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 93
Jacob, thanks very much for the post!
I killed many hours searching the MS sites, blogs, forums, etc and was up and working minutes after reading your post.
Drew Solomon
Drew Solomon
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 12
I have this setup correctly such that I can view my SSAS db remotely through Management Studio. While in a report project, when I setup a shared data source using the same HTTP url as the server, if I turn off SSPI in the advanced tab, when I "Test Connection", it succeeds. However, if I create a report using this data source, it says:

A connection cannot be made to the database.
Set and test the connection string.
Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.

Any ideas as to why?
tribhuwanupc
tribhuwanupc
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 46
i have connect SSAS though RemoteServer.after connecting when database is expanding then no any database shown,while database alreadyexist in remoteServer.


Pl Give me response as soon as.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search