Re: Extranet Deployment with Remote SQL

Hi Bob,

All you have to do is to configure the app pool for your SharePoint virtual
server to use a domain account which is granted Security Admins and Database
Creators roles on the SQL box. This account also needs local admin or power
user rights on the SharePoint box.

HTH,
Alex

"Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:34BE6AC5-58EE-4082-90CE-A4AF604889EA@xxxxxxxxxxxxxxxx
> Sorry, I have done this before but I got a braincramp and forgot the
> procedure: Im setting up an External Site for a company inside there DMZ
> (NO
> COnnection to Internal Users). AD and WSS will be in the "Blue Zone" and
> there is a seperate SQL Server in the DMZ that is part of a workgroup.
> How
> can i set up the authentication to allow WSS and the workgroup SQL box to
> communicate with each other for the WSS databases.
> Currently I have set this up in a test VM setting using the "Network
> Service" as the communication link. Thoughts..??
>
> No im not a moron... i just play one on occasion :)


.

Relevant Pages

  • Re: Sharepoint Migration issues
    ... \par 3.\tab Have you added the domain user into the Administrators group on the SQL Server box? ... \par 4.\tab Have you ever used the domain account to log on to the new WSS server? ... have you ever successfully imported the data from that SQL Server box when you log on to the new WSS server using the domain account? ... Do I need to connect to the existing configuration database? ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: problem connecting to dbase from webservice with impersonation
    ... will acess a remote SQL Server instance, so you want to let your ASP.NET ... application run under a domain account so as to access the remote SQL ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: IIS 6 CreateObject premissions issue
    ... >> tier system so I am confident that running on Windows 2000 what I am ... >> What I am attempting is to add a Windows 2003 server box to function as ... However if it is set for anonymous access using the ... >> end boxes to specifically allow the Domain account I attempted to use as ...
    (microsoft.public.inetserver.iis.security)
  • Re: Networking XP Pro to a Downlevel NT4 domain
    ... There are two ways to create a domain account on an NT4 ... domain - the first is to run Server Manager either from ... >We are not running DCHP here. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Adding additional server in a windows small business network
    ... Server for the domain account created on the SBS 2003? ... Windows 2003 server that will host MS SQL 2000 database. ... I have created a server account on the SBS and joined the Windows ...
    (microsoft.public.windows.server.sbs)