?
Solved

IIS7, Windows Web Server 2008 Web Edition and Remote SQL Server Database connection

Posted on 2008-10-19
6
Medium Priority
?
624 Views
Last Modified: 2011-04-14
I have been trying to setup my IIS7 on my windows web server 2008 web edition to connect to my remote sql server 2000 database.

Is this version, web server 2008 web edition, going to allow connection to a remote sql server database, considering it does not have Active Directory?

I have tried every possible configuration and can't get a connection, whether windows authentication or sql server authentication.

So am I spinning my wheels trying to get it to work, when it requires Active Directory?

Would Microsoft really sell a product for web servers that does not allow a remote sql server database connection?

Please let me know if you have done this with a web server edition. Please please please!

I just don't think there are that many people who have even used IIS7 to know an answer, because I've asked tons of questions and just dont' find any answers.

thanks.
0
Comment
Question by:Starr Duskk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 2000 total points
ID: 22754602
Hi,

Try using SQL Authentication.

While It is supposed to be do-able that web-site on Windows Web Edition connects, you'll have to open the firewall for the authentication, as well as for the SQL connection.

HTH
  David
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22755373
I have tried sql authentication.
(As I said, quote: I have tried every possible configuration and can't get a connection, whether windows authentication or sql server authentication.)
 
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22755384
Also, please, I have written numerous detailed posts on this on what I have tried and what to try.
In this post I have written a specific question if it's doable. So please respond if you know for a fact if it is or not, BY EXPERIENCE.
Not a hunch or guess or what you think it's supposed to be. I need to know if someone has indeed ever gotten it to work. Because otherwise, I'll have to buy the standard edition and move on. I've already wasted enough time on this and time is money. I could have purchased the standard edition with the time I've wasted on this.
 
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 35

Expert Comment

by:David Todd
ID: 22760593
Hi,

In a previous role we had Windows 2003 Server Web Edition running in a DMZ. It connected to databases in the internal lan using SQL Authentication.

I installed the OS on this machine, and migrated the existing web-sites there.

I installed SSL on two web-sites, which required additional IP's to be mapped from the WAN to the DMZ.

I will admit to not having done this with IIS 7.

Is down-grading to IIS6 an option?

Cheers
  David
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22773766
dtodd,
I thought you meant sql authentication in the connection string. That never worked for me.
But when I was pulling out my hair trying to setup a sql server 2000 security user, I noticed a radio button for sql server authentication and tried it.
That works. So Step#5 below, use sql server authentication instead of windows authentication, but still use windows authentication in the connection string in the web config.

(i)Add the Windows account to SQL Server:
1.
Start Enterprise Manager.
2.
Expand Microsoft SQL Server, and then expand SQL Server Group.
3.
Expand your server, and then expand Security.
4.
Right-click Logins, and then click New Login.
5.
In the SQL Server Login Properties dialog box, enter the Windows account name in the Name box. In the Domain list, select the domain that the Windows account is a member of.
6.
Click the Database Access tab, set the appropriate permissions for the client, and then click OK.
thanks!
 
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22773781
oh, btw, I did not have to open the firewall.
I just used the local IP address for the web.config connection string, instead of the remote IP.
 
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

770 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