Can't create analysis view from the extranet PS2007

[jcano]

Hi,
I've installed PS2007 and SQL Server 2005 on the same machine (a domain
controller) and opened it to the internet. I've created the cube correctly,
and can crete it from the internet and from the intranet. I've introduced the
AS extranet direction (same as the project server IP direction) on the Cube
creation field.
When I try to create a analysis view in the office I've no problem.
The problem is that when i'm out of the domain, the database field is empty
and the search option gives an error of cannot find the analysis server.
Any idea?

 

[Ben]

Hi, Extranet access to AS views is only available in the Enterprise Edition
of SQL2005. What version are you using (standard or enterprise).

 

[jcano]

I'm using the standard edition. Anyway, what I'd to do if i had the
enterprise version of SQL Server 2005?
Thanks

 

[Ben]

I would check the documentation in the PS2003 resource kit for full details.

 

[Gary L. Chefetz [MVP]]

jcano

You'd have to set things up to run over http. Rather than incurring the high
cost of Enterprise SQL, and if you're the only one who needs access to build
views, you'd be better off terminaling into the server to do this.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project

 

[jcano]

Thanks for all:
Ben, i'm using Project Server 2007, i don't know if there's any change with
version 2007 for accessing data analysis views from the internet.
Greetings

jcano

You'd have to set things up to run over http. Rather than incurring the high
cost of Enterprise SQL, and if you're the only one who needs access to build
views, you'd be better off terminaling into the server to do this.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project

 

[Ben Howard]

Hi,
Extranet scenarios are covered here -
http://technet2.microsoft.com/Offic...7193-4ed3-93bd-6685f0d82db11033.mspx?mfr=true

However, I think the underlying requirement is still SQL Enterprise Edition.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

 

[jcano]

Thanks Ben:
I think that only opening 2383 port doesn't works (I saw this in the SASS
technet library). I think that you're right and I need SQL Server 2005 Ent.
Thanks