Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect to a Remote SSAS 2005 Database Expand / Collapse
Author
Message
Posted Wednesday, February 7, 2007 8:48 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2865.asp

.
Post #343319
Posted Tuesday, May 1, 2007 7:06 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, September 27, 2014 12:26 PM
Points: 676, Visits: 433

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




Post #362259
Posted Monday, October 15, 2007 12:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 17, 2010 4:11 AM
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.
Post #410973
Posted Monday, October 15, 2007 1:20 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, September 27, 2014 12:26 PM
Points: 676, Visits: 433
There is. Look up HTTP Endpoints in Books Online. I beleive that will give you what you need.


Post #410997
Posted Tuesday, October 16, 2007 8:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 17, 2010 4:11 AM
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.
Post #411322
Posted Friday, November 9, 2007 11:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 7:09 AM
Points: 55, Visits: 92
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.
Post #420657
Posted Friday, March 14, 2008 11:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 10, 2010 10:01 AM
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?
Post #469565
Posted Thursday, May 21, 2009 6:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 10:33 PM
Points: 6, Visits: 45
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.
Post #721282
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse