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 |
|
minh-hieu.pham
Starting Member
1 Post |
 Posted - 2014-08-26 : 10:49:18
|
| Dear friends, I'm a beginner in Microsoft BI technology. I'm studying SSAS and have a problem of connection establishing with SQL server when I tried to process a BI cube project.I use SQL Server 2012 and visual studio 2013 for my project. My project process always failed with the first message was: -----------------------------------------------------------------------------------OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.------------------------------------------------------------------------------------Here are some solution I have tried after I did the research from internet but it's not working: 1. Try to unblock firewall (Source: http://technet.microsoft.com/en-us/library/ms174937.aspx) 2. Try to use either "Use Window Authentication" or "Use SQL Server Authentication" in Connection Manager when I set up a data source for my Cube project. So could anyone have a idea for my problem? Thanks in advance. p/s: Sorry for my bad English!! |
|
|
|
|
|
SSAS - unable to establish connection 08001