SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 SSAS - unable to establish connection 08001
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

minh-hieu.pham
Starting Member

1 Posts

Posted - 08/26/2014 :  10:49:18  Show Profile  Reply with Quote
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!!
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000