The server name or address could not be resolved

[jvn]

Hi,
I need some help in using Pivot table in ASP.NET page. I am using ASP.NET, SQL Server OLAP Cubes and Office 2003 web components. Also I use SSL for the entire web site.

The process works fine when connected through Proxy (Company's VPN) but does not work when connected directly from an ISP.

When I try to get data to client
I get a error in the pivot table saying "Query could not be processed:
The server name or address could not be resolved."

In the Web Service I use the Connection string as
"Provider=MSOLAP.2;user id=Id;password=Passwd;Data Source=http://servername;Initial Catalog=DbName"

Your help will be appreciated.

Thanks
JVN

 

[Wei-Dong XU [MSFT]]

Hi JVN,

From the error message, it will appreciated you tell me whether you can visit all the web site pages through the ISP in SSL connection. If not, this
ISP may not provide the SSL connection service for you. You will need to troubleshoot this one first.

I'd also suggest you can perform one configuration in Analysis Service server side for providing the service through https. This kb article will introduce
the configuration method for you.
INF: How to Connect to Analysis Server 2000 By Using HTTP Connection
http://support.microsoft.com/?id=279489

For your scenario, you can test the msolap.asp with the link: https://servername/msolap.asp. Then you can specify in the connection string with the
link: "Data Source=https://servername/".

In addition, the SQL server article will introduce more information for you concerning the OLAP http configuration.
Connecting Using HTTP
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_clien_9cog.asp

Please feel free to let me know if you have any further questions.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[jvn]

Hi Wei-Dong,
I am able to visit all the pages in the web site through SSL. The only option which does not work is the Pivot table which initialy prompts me "The Web site uses a Data Provider that may be unsafe. Do you want to Proceed" When I say OK. I get the error message "The Server name or address could not be resolved".

The above option works only If I am in the Company's Network (Both in Building or Connected to the Company through VPN).

I have configured the msolap and works fine. I get a blank page when I type http://servername/msolap.asp. I copied MSOLAP in the default web server location.

This is how the configuration is setup: The web server is in DMZ and the SQL Server and the Application server are inside the Company's network.

I also saved the query (The Pivot table also has a capability to save the Metdata information) after the error is message is displayed. The Data provider in the XML string gives me the exact connection string which was assigned to it through web.config.

Let me know if you need any additional information about this.

Thanks
Jvn

 

[Yan-Hong Huang[MSFT]]

Hello,

This problem is strange. Weidong discussed it with me. Currently we are finding somebody who is familar with it and we will get back with more
information as soon as possible.

If you have any more concerns, please feel free to post here. Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Yan-Hong Huang[MSFT]]

Hello JVN,

Thanks very much for your quick update. After talking to OWC support engineer, we all felt that there may be some issue in network
configuration. It is great that you have isolated the root cause and we are all glad to hear that.

For such issues, generally we have two workarounds:

1) As you did already, we can move the Analysis server to a web address which is allowed to be accessed.

2) Another way is to contact your network administrator to see whether it is possible to open special port and internal sql server address so
that it can be accessed.

The second way is determined by the company network policy. If it is rejected, I think you may have to stick to the first way.

If you feel there is any we can do for you, please feel free to post here. Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.