Solved

Windows 2008 R2 Web - SQL ODBC

Posted on 2010-11-17
1
1,042 Views
Last Modified: 2012-05-10
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
Comment
Question by:Singnetsvc
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 34162850
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now