RE: Integrated Security in the DMZ



Sean,
Thanks for your ideas.
They sounds like an interesting idea, but I think there is more to it.
I need to make IIS run under that account.
I already have set my website in IIS with a domain account. Now email is
trusted, but sql authentication is not trusted.
To make things more complicate, I have a remote share defined in IIS. That
remote share has its own identity which is different from the Identity that I
use for the website.
--
Arne Garvander
Certified Geek
Professional Data Dude


"Sean McCown" wrote:

You have to setup a trust between the DMZ domain and the internal domain. If
your DMZ isn't an actual domain, then you'll have to setup a local windows
acct on your sql box and use that acct to access on the DMZ side.

So say on your sql box you setup a LOCAL user acct 'MySQLUser'
You would setup the same LOCAL user acct on the DMZ box as well. Use the
same password and everything. Then when you make the connection to the sql
box from outside the domain, it will validate the windows permissions and
should let you through because you're connecting with the same named acct and
password.

If neither of those 2 work, then just use sql auth and be done with it.

"Arne Garvander" wrote:

I have a test web server in a domain. The IIS identity as a domain account.
The website can access SQl Server (2005) using integrated security.
I have a production web server in DMZ out side the domain. How can I setup
the webserver to use integrated security? The SQL server is inside the domain.
--
Arne Garvander
Certified Geek
Professional Data Dude
.



Relevant Pages

  • Re: SQL2005 auf Vista
    ... Mittlerweile hab ich den SQL 2005 drauf. ... Allerdings verweigerte der Setup hart näckig die Installation der Reporting services angeblich weil IIS nicht drauf was nicht stimmt! ... Auch das Setup hat geklappt. ...
    (microsoft.public.de.sqlserver)
  • Re: Unable to reinstall SBS Monitoring
    ... Uninstall Windows SBS 2003 R2 components". ... they ask to see "Installing the Windows Small Business ... Rerun Setup, and retry installing ... B5CA-19397244DCFD})of sql setup at Software\Microsoft\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: PROBLEM: ASP on IIS 5 secured via "Windows Integrated Authentication" accessing "
    ... uses NT group based permissons on the SQL Server, ... > transfered to the IIS box and IIS does a local logon. ... > delegation for all accounts. ...
    (microsoft.public.inetserver.iis.security)
  • RE: Co-Hosting SQL with IIS FTP service
    ... there are no functional conflicts between SQL and IIS; their network resource demands are unique. ... If the machine resources are enough, you can also use your favorite virtualization technology to separate the FTP and SQL servers and thus avoid the combinational security issues that public FTP services may impose on the SQL server. ... Co-Hosting SQL with IIS FTP service ...
    (Focus-Microsoft)
  • Re: SQL Server Developer Edtn 2005 - WMI Error during installation - Error:2147500034 (0x800
    ... Here is some information from the Log files that are created from the SQL ... Server setup (C:\Program Files\Microsoft SQL Server\90\Setup ... Condition "Setup is running locally." ... Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp ...
    (microsoft.public.sqlserver.setup)