Solved

Windows 2008 R2 Web - SQL ODBC

Posted on 2010-11-17
1
1,046 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

815 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

7 Experts available now in Live!

Get 1:1 Help Now