IIS7, Windows Web Server 2008 Web Edition and Remote SQL Server Database connection
Posted on 2008-10-19
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.