• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1065
  • Last Modified:

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

Alan.
0
Singnetsvc
Asked:
Singnetsvc
1 Solution
 
Eugene ZCommented:
try to use OLEDB connection

http://www.connectionstrings.com/sql-server-2008

also this may help:
http://man.unice.net/blog/index.php/sharepoint-2010-and-windows-2008-web-edi

hotfix:
FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system
http://support.microsoft.com/kb/950636

0
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.

Join & Write a Comment

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell┬« is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now