Solved

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

Posted on 2008-10-19
6
622 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 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Removing SCCM 2016 4 48
How to use Recordset, returned from a SPROC as the recourdsource of a form. 24 49
Moving away from Access 2003 adp files 4 45
SQL Query 9 26
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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…

739 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