Wednesday, March 18, 2009

Error creating a Data Source from the Planning Administration Console

Hi and welcome to another post from Non-Stop BizTalk!

I was trying to create a Data Source to AdventureWorksDW in the Planning Administration Console, PerformancePoint Server 2007. Got the following error message: You do not have the required permissions to connect to the specified database (Error code: PerformancePoint_225000183) Connection to database AdventureWorksDW on server local failed. This was caused by collaction settings in SQL Server 2005 for this database. The complete description of the problem problem and the solution are available here.


Sunday, March 08, 2009

Would ARR help solve my problem?

Hello and welcome to another post from Non-Stop BizTalk!

Posted the following in the official IIS forum:


I have the following scenario:

I have 3 VLANs, or say 3 network segments. VLAN1 is the clients segment; VLAN2 has SharePoint Server, with a website that utilizes the PageViewer web part. This PageViewer is used to display websites hosted on Servers at VLAN3 (applications segment). Users from VLAN1 are prohibited to access the applications at VLAN3 directly; they have to do it via SharePoint's PageViewer); so when a users browses an application from the pageViewer at SharePoint he gets an access denied message for the contents in the viewer (since the PageViewer is merely an iFrame control -- URL holder). I am wondering if I can user the ARR module from IIS 7.0 to route the requests from VLAN1 to VLAN3 as if they were initiated from VLAN2 (SharePoint)..

Appreciating your help,


And got the following reply:

Sure, if you install ARR on machine which has 2 nics, one on vlan1 and the other on vlan3, it could accept requests for pages you want to allow from vlan1 and forward them to vlan3 - you would also need to update the links on your sharepoint pageviewer (or your dns entries in vlan1) to point to the ARR server. Note that while you can configure ARR to be an http forward proxy, you cannot use it as an https forward proxy.

Anil Ruia
Senior Software Design Engineer
IIS Core Server