Solved

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

Posted on 2008-10-19
6
611 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:BobCSD
  • 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 1

Author Comment

by:BobCSD
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 1

Author Comment

by:BobCSD
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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 1

Author Comment

by:BobCSD
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 1

Author Comment

by:BobCSD
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 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

11 Experts available now in Live!

Get 1:1 Help Now