Solved

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

Posted on 2008-10-19
6
617 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
  • 4
  • 2
6 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 500 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

828 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