Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqadil
Starting Member
11 Posts |
 Posted - 2011-04-18 : 12:48:47
|
| Guys...!, I'm trying to connect to olap cube using excel 2007.From 'Data' tab selecting from 'other sources' --> 'Analysis servers'its giving error saying " Unable to connect to datasource.Unable to locate server .., bla bla.contact ur administrator"..tried many alternatives.. still can't get itPlease share ur ideas if u guys have already faced this problem and found solution..Thanking you in advanve.....@ |
|
|
Sqlraider
Yak Posting Veteran
65 Posts |
Posted - 2011-04-19 : 10:45:52
|
| You could be having a port/firewall issue on the server. If that is the case you need to unblock port 2383 from the server firewall to allow remote connections. You can google this issue for more information. |
 |
|
|
|
|
|
connecting to olap cube from Excel 2007