Proxy Error (Connection refused)

G

Guest

Hi,
I am facing one problem while using pivot table (through Analysis Server of
SQL) i.e. "Proxy Error (Connection refused)" when connecting to server
through excel (pivot table). I have installed Service Pack 4 too to avoid
this but still the prob. is same.

Is there any solution for this and what / why is this problem ?

Thanks,

Sanjeev
 
R

Robin Hammond

Sanjeev,

You might need to figure out what port SQL is running on and check that this
port is enabled through the proxy. Typically I think it is 1433 but not
sure.

On the server, run the Server Network Utility and look at TCP/IP properties
to see what port SQL is using.

Robin Hammond
www.enhanceddatasystems.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Web/Proxy/VPN problem 0
Dynamically generating a spreadsheet with custom pivot table including data 2
Corrupt files due to pivot remnants after saving via VBA 0
Date problem in Pivot Tables when using SQL as a Data Source. 1
Pivot chart loses data connection when copied to new workbook 1
Excel Service error "cannot connect to external data source" 1

Top