Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1170
  • Last Modified:

Configuring Sharepoint Services on DMZ

We have an IIS Web Server running Windows 2003 Server.  It is not part of the domain.  Just a workgroup.    It lives in the DMZ.  We are trying to install Sharepoint services on this server and have it access the Sql 2005 server on the inside of the network.   I've opened up the Firewall ports and such and believe ports 1620,1622 and such are working fine.   When we run the installation wizard that creates the database and such.. it makes it to step 2.   It created, I believe 3 databases, but failed with the following error in the log.  I'm certain it has something to do with authentication or domain or firewall issues.  The error starts with the ****** below.


Administration v3, was successfully created.       
04/28/2009 08:23:25.17       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         Topology                            95kp      High          Creating site  in content database SharePoint_AdminContent_a1ddb337-f740-4370-afdc-a20b1c5221ae       
04/28/2009 08:23:34.25       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         General                             8l26      High          
********************************
Error when trying to get trusted forests and domains. Exception message: Current security context is not associated with an Active Directory domain or forest., callstack:    at System.DirectoryServices.ActiveDirectory.DirectoryContext.GetLoggedOnDomain()     at System.DirectoryServices.ActiveDirectory.DirectoryContext.IsContextValid(DirectoryContext context, DirectoryContextType contextType)     at System.DirectoryServices.ActiveDirectory.DirectoryContext.isDomain()     at System.DirectoryServices.ActiveDirectory.Domain.GetDomain(DirectoryContext context)     at System.DirectoryServices.ActiveDirectory.Domain.GetCurrentDomain()     at Microsoft.SharePoint.Utilities.SPUserUtility.GetTrustedDomains(List`1 trustedForestNames, List`1 trustedDomainNames)       
04/28/2009 08:23:34.25       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         General                             72dz      Monitorable      Found 0 trusted forests .       
04/28/2009 08:23:34.25       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         General                             72e0      Monitorable      Found 0 trusted domains       
04/28/2009 08:23:34.28       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         Topology                            95kq      High          Creating top level site at http://rda-quality:45193/      
04/28/2009 08:23:34.37       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         General                             72jz      Medium        Creating site: URL "/"       
04/28/2009 08:23:34.89       psconfigui.exe (0x0E28)                       0x0EC4      Windows SharePoint Services         General                             8gam      Medium        Recalc needs to happen. Real = 0, Cached =-1, WFE
0
rdelrosario
Asked:
rdelrosario
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
If you are trying to install the Sharepoint databases on the SQL server behind the firewall this won't work because Sharepoint uses Windows Authentication to connect to the SQL database which means it MUST be on the same domain as the web server.
0
 
FloorCoderCommented:
@tedbilly (2011_0103_1535)

This is not entirely true ----

Sharepoint also allows Database authentication as well as  Windows - hence you can use an SQL account to access SQL server through a firewall.

From the Share Point Create New Web Application Page -
Database Name and Authentication  
Use of the default database server and database name is recommended for most cases. Refer to the administrator's guide for advanced scenarios where specifying database information is required.

Use of Windows authentication is strongly recommended. To use SQL authentication, specify the credentials which will be used to connect to the database.
 
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now