Windows 2008 R2 Web - SQL ODBC

Hi all we are configuring a Windows 2008 R2 Web edition server to conenct to a backend SQL server on another box. our method would nornally be to configure ODBC and Com Services DTC, but windows 2008 Web does not come with the Applciation server role.

Does anyone know of any special configuration requirements to connect IIS Web app on windows 2008 Web to SQL 2008 on windows 2008 Standard backend

Who is Participating?
Eugene ZConnect With a Mentor Commented:
try to use OLEDB connection

also this may help:

FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.