[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Windows 2008 R2 Web - SQL ODBC

Posted on 2010-11-17
1
Medium Priority
?
1,058 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 43

Accepted Solution

by:
Eugene Z earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
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 …

834 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