Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SharePoint 2013 Administration
This is the forum to discuss the Wrox book Professional SharePoint 2013 Administration by Shane Young, Steve Caravajal, Todd Klindt; ISBN: 978-1-1184-9581-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SharePoint 2013 Administration section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 23rd, 2013, 12:07 PM
Registered User
Points: 14, Level: 1
Points: 14, Level: 1 Points: 14, Level: 1 Points: 14, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2013
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error setting up Excel services

I am currently in Chapter 8, page 248 and i'm trying to test the Excel services unattended service account. I have followed all step by step instructions up to this point.

I'm using a named instance for the ssas server. Because a named instance uses a dynamic port for listening, I had to set it to a static port, but it works. When I try to connect to the analysis server from excel, I get this error message: The following system error occurred: The requested name is valid, but no data of the requested type was found

For server, i'm using serverad1\ssas:[port#]

Id is [domain]\sp_excel

I've googled for answers but have not found anything useful yet. Any suggestions would be helpful.
Reply With Quote
  #2 (permalink)  
Old October 23rd, 2013, 02:18 PM
Registered User
Points: 14, Level: 1
Points: 14, Level: 1 Points: 14, Level: 1 Points: 14, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2013
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok, here's an update.

I found an article that listed different ports to unblock. I've now opened 1433 and 1434 for sql server, and ports 2382 and 2383 for the browser, and i'm getting this error message: "the following system error occurred: a connection attempt failed because the connected party did not respond after a period of time, or established connection failed because host has failed to respond

I went to the firewall settings and just shut the whole thing down. Went back to excel and it worked. Obviously, it's a firewall issue but I don't know what else to do with it. Is there another port to unblock?

Any suggestions?
Reply With Quote
  #3 (permalink)  
Old October 23rd, 2013, 03:37 PM
Registered User
Points: 14, Level: 1
Points: 14, Level: 1 Points: 14, Level: 1 Points: 14, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2013
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Another update:

I installed SSMS on my client machine, rather than remoting into the server. I was able to connect to the DB engine, but not the AS, as I expected.

Again, I turned off the FW and I was able to connect to the AS with no problems. I turned the FW back on and it failed again. Obviously it's a firewall issue, but I've unblocked the ports it says to unblock. What else is there that could be causing this?

thanks.
Reply With Quote
  #4 (permalink)  
Old October 23rd, 2013, 05:33 PM
Registered User
Points: 14, Level: 1
Points: 14, Level: 1 Points: 14, Level: 1 Points: 14, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2013
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I finally figured it out. I turned on the firewall log and had it log all the dropped requests to see what's NOT coming thru. I found that port 49179 was blocked and getting tcp requests. I unblocked that port and it works fine now.

Maybe I was supposed to unblock that port in another step and I missed it, but it's working for now.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning Excel Services book issue material.study All Other Wrox Books 2 May 31st, 2009 06:10 PM
Excel Services on SharePoint /Windows Comp Cluste jvanlin BOOK: Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 ISBN: 978-0-470-12449-9 0 June 3rd, 2008 01:50 AM
Excel Services luis.filipe BOOK: Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 ISBN: 978-0-470-12449-9 0 September 12th, 2007 08:50 AM
Setting a new Excel application Shasur Pro VB 6 1 September 21st, 2005 11:12 AM
Setting a new Excel application Shasur Excel VBA 1 September 21st, 2005 11:11 AM



All times are GMT -4. The time now is 09:58 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.