1

I have a 3-level application running. WebServer IIS7.5 and SQLServer 2008 R2 Express Database and OS WinServer 2008 WebEdition.

When I try to connect via ODBC from a PC on the network have this error.

enter image description here

Remote connections with MSSM (Microsoft SqlServer Managemet Studio) work properly. I want to use this ODBC to connect Hyperion to SQLServer

Can you help me?

daniele3004
  • 13,072
  • 12
  • 67
  • 75
  • do you have enable sa account and enable mix authentication mode . if local sqlserver can connection check your firewall . – King Jk Nov 03 '14 at 15:11
  • @King Jk Mixed authemtication mode is enable. The firewall is disabled by excluding it from the problem – daniele3004 Nov 03 '14 at 15:29

1 Answers1

1

I resolve to enable TCP/IP service in SQL Server Configuration Manager.

enter image description here

After this , if problem persist disable firewall on private/domestic net and try again.

daniele3004
  • 13,072
  • 12
  • 67
  • 75