Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The connection timed out Expand / Collapse
Author
Message
Posted Tuesday, November 5, 2013 12:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 5:11 AM
Points: 4, Visits: 25

I am using BIDS 2008, developing a cube in SSAS.

While trying to browse a dimension (by clicking the Browse tab), I get the message "The connection timed out".

Any help will be appreciated.

David
Post #1511374
Posted Tuesday, November 5, 2013 4:40 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:16 AM
Points: 543, Visits: 1,048
Could be a number of things.......
Is the dimension deployed and processed?
Are the permissions you are using have access to the dimension?
Can you navigate to the cube within SSMS?





I'm on LinkedIn
Post #1511429
Posted Tuesday, November 5, 2013 5:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 5:11 AM
Points: 4, Visits: 25
The deploy and process are successful.
I manage to access the dimension.
I can nevigate to the cube in SSMS, but when I right-clicked the specific dimension, I got the same message: "The connection timed out".

One more thing: It takes more than a minute to open the Microsoft Analysis Server in SSMS.

David
Post #1511440
Posted Tuesday, November 5, 2013 5:30 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:16 AM
Points: 543, Visits: 1,048
Can you have a look at your data source in BIDS and check that the Query Timeout, Connect Timeout and General Timeout are all set to "0"?




I'm on LinkedIn
Post #1511443
Posted Tuesday, November 5, 2013 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 5:11 AM
Points: 4, Visits: 25
Sorry for my ignorance, but I am not familiar with those three properties.
How can I reach them? I don't see them when I select the data source.
Post #1511449
Posted Tuesday, November 5, 2013 6:18 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:16 AM
Points: 543, Visits: 1,048
Having thought about it it's probably not them anyway. You can reach them by double clicking on your datasource in BIDS.

I think you need to look at your SSAS Server properties.

In SSMS right click on the SSAS node and go to properties and tick the box for Show Advanced (All) Properties. Here you can see ExternalCommandTimeout and ExternalConnectionTimeout, defaulted at 3600 and 60 respectively. You could try changing them.

I do think that you have a larger issue here though. If it's as slow to connect as you mentioned and you are hitting timeouts it may be time to look at your environment. Without knowing anything about what setup you have it's difficult to make suggestions other than the obvious.





I'm on LinkedIn
Post #1511457
Posted Tuesday, November 5, 2013 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 3, 2014 5:11 AM
Points: 4, Visits: 25
Your advice was very helpful.
Thanks a lot!
Post #1511471
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse