Unable to load data from dinnernow DB in work group setting

Topics: Architecture, Setup / Configuration, Web site
Aug 1, 2008 at 1:22 PM

I have installed dinnernow app on Windows Server 2003 Sp2 [part of WORKGROUP] with following change:
1> SQL Server 2005 Enterprise on another host with Windows Server 2008 [part of WORKGROUP]
2> Modifying Library.ps1 to
function new-DatabaseAlias
 [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null
 $sa = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ServerAlias "<SQL Server M/c name>","DinnerNow"
  #Assume SQLExpress for now
 $sa.ServerName='<SQL Server M/c name>'

3> Runme.bat suceeds without issue (other than gadget error)
4> Modify the connection string in Inetmgr for dinnernow site to have <SQL Server Name>.
and I am able to access the site http:\\localhost.

But when I invoke http:\\localhost\dinnernow, the dropdown menu on site like food type,meal are NOT populated.
On investigation with netmon, it turn out that web service access the DB by its own hostname account and that is throwing NT Status: System - Error, Code = (34) STATUS_ACCESS_DENIED.
If I add both the m/c to a domain and add web server m/c in required usergroup in DB server, everything works fine.
But I need m/c's to be in work group.
Is it possible to tweak web service so that it uses shadow account on web server to access DB service?

Please let me know if need more info.