web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM Dynamics & SQL...
Microsoft Dynamics CRM (Archived)

CRM Dynamics & SQL 2008 link to Excel 2007 failure

(0) ShareShare
ReportReport
Posted on by Christopher A Bird 80
Infrastructure Microsoft Office Small Business Server 2008 with second Microsoft 2008 server with Microsoft SQL server 2008 installed and Microsoft Dynamics Workgroup 4. No other software installed on second Microsoft server.
 
Microsoft Dynamics Workgroup 4 cannot link CRM data to Microsoft Office 2007 Excel Dynamic or pivot tables following error messages.
 
Connection Failed
Sql state:’01000’
Sql Server Error 10060
[Microsoft][ODBC Sql Server Driver][TCP/IP Sockets] Connection Open
(Connect ()).
Connection Failed:
SqL state #08001’
Sql Server Error: 17
[Microsoft][ODBC Sql Server Driver]
[TCP/IP Sockets] SQL Server does not exist or access denied.
 
SECOND MESSAGE
Connection Failed
Sql state:’01000’
Sql Server Error 231
[Microsoft][ODBC Sql Server Driver][DBNETLIB] Connection Open
(C onnect ()).
Connection Failed:
SqL state #08001’
Sql Server Error: 17
[Microsoft][ODBC Sql Server Driver] ][DBNETLIB]
SQL Server does not exist or access denied.
 Spent many hours digging around trying to find a solution, for example the best I found was
 
Regards
Christopher Bird

 

*This post is locked for comments

I have the same question (0)
  • Alan Garcia Profile Picture
    Alan Garcia 2,020 User Group Leader on at

    Have you tried manually configuring an ODBC/ODC connection to link the first server to the second?

    It sounds like a missing trust relationship.

  • Christopher A Bird Profile Picture
    Christopher A Bird 80 on at

    Thank you my issue is resolved, apologise for taking so long to respond been away on client site.

     

  • nomadic Profile Picture
    nomadic 20 on at
    How did you do it? thanks!
  • Christopher A Bird Profile Picture
    Christopher A Bird 80 on at

    Step one http://support.microsoft.com/default.aspx/kb/968872 two solution methods, wizard or manual.

    Step two - Still suffer connection issue check user accounts can be authenticated for SQL database. Look in SQL Server Management Studio connect to server, expand Security expand Logins. Decide how users can authenticate either Windows Authentication or SQL Server Authentication then setup appropriate account(s).

    Good luck. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans