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.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306
