Connect to a Remote SSAS 2005 Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Yaniv Mor » Connect to a Remote SSAS 2005 Database

Connect to a Remote SSAS 2005 Database

Rate Topic

Display Mode

Topic Options

Author

Message

jacob sebastian

Posted Wednesday, February 07, 2007 8:48 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2865.asp

.

Post #343319

cliffb

Posted Tuesday, May 01, 2007 7:06 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 03, 2013 11:41 AM
Points: 675, Visits: 426

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

william-505882

Posted Monday, October 15, 2007 12:21 PM

Forum 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

cliffb

Posted Monday, October 15, 2007 1:20 PM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 03, 2013 11:41 AM
Points: 675, Visits: 426

There is. Look up HTTP Endpoints in Books Online. I beleive that will give you what you need.

Post #410997

william-505882

Posted Tuesday, October 16, 2007 8:18 AM

Forum 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

Robert A. Booey

Posted Friday, November 09, 2007 11:50 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 17, 2012 6:17 AM
Points: 55, Visits: 91

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

Drew Solomon

Posted Friday, March 14, 2008 11:21 AM

Forum 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

tribhuwanupc

Posted Thursday, May 21, 2009 6:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, October 13, 2012 9:41 PM
Points: 6, Visits: 44

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 »

Permissions