{"id":745,"date":"2012-11-12T16:05:48","date_gmt":"2012-11-12T16:05:48","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=745"},"modified":"2012-11-29T21:31:19","modified_gmt":"2012-11-29T21:31:19","slug":"ssas-login-timeout-expired-when-processing-cube","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2012\/11\/ssas-login-timeout-expired-when-processing-cube\/","title":{"rendered":"SSAS Login timeout expired when processing Cube"},"content":{"rendered":"<p>If you receive this error when attempting to process a cube:<\/p>\n<p><span style=\"color: #333399;\">OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00;<\/span><br \/>\n<span style=\"color: #333399;\"> An error has occurred while establishing a connection to the server.<\/span><br \/>\n<span style=\"color: #333399;\"> When connecting to SQL Server 2005,\u00a0this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001;<\/span><br \/>\n<span style=\"color: #333399;\"> SQL Network Interfaces: Error Locating Server\/Instance Specified [xFFFFFFFF]. ; 08001.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Try checking the following:<\/p>\n<ul>\n<li>Remote Connections are enabled on the instance your Data Source Database resides on<\/li>\n<li>If using the server\/host name in your data source connection string ensure that the named pipes protocol is enabled within SQL Server Configuration Manager &gt;\u00a0SQL Server Network Configuration on the instance your Data Source Database resides on<\/li>\n<\/ul>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>If you receive this error when attempting to process a cube: OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005,\u00a0this failure may be caused by the fact that under the default settings SQL Server does [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[50],"tags":[41,62],"class_list":["post-745","post","type-post","status-publish","format-standard","hentry","category-ssas","tag-bids","tag-ssas"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=745"}],"version-history":[{"count":3,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/745\/revisions"}],"predecessor-version":[{"id":762,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/745\/revisions\/762"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}