I'm going to need to install this with 1 server for the web and a db server which is not accessable via the web...

"You must not store cardholder data on a server accessible from the Internet in order to
remain compliant with the DSS. For example, you should not have your database and
web server on the same machine."

Do I need to run instdsc on both machines?

You still run InstDSC from the web server. Just pass the correct server name to InstDSC. Make sure you have the permission to create DB and SQL client software installed on web server.

InstDSC.exe <database server name> <database name> <database data file path>
<encryption key path> [<smtp email server>] [<system email address>]

Thank you, After running the command from the webserver:
D:\dsc\Install>instdsc dbserver dotshopping_staging \\dbserver\d$\mssql\data d:\key localhost noreply@r2pnetworks.com

the directory structure \\dbserver\d$\MSSQL\Data\FTData\dotshopping_staging is created but then it gives this error:

Creating database dbserver.dotshopping_staging at \\dbserver\d$\mssql\data ...
Running sqlcmd -E -S dbserver -v DatabaseName="dotshopping_staging"
PrimaryFilePhysicalName="\\dbserver\d$\mssql\data\dotshopping_staging.mdf"
PrimaryLogFilePhysicalName="\\dbserver\d$\mssql\data\dotshopping_staging_log.ldf"
DBDataPath="\\dbserver\d$\mssql\data" -i "D:\dsc\Install\CreateDB.sql" -b</span>

Unhandled Exception: System.ComponentModel.Win32Exception:
The system cannot find the file specified
   at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startIn
fo)
   at System.Diagnostics.Process.Start()
   at DotShoppingCart.OpenSource.Core.RunCmd.RunProcess(String filename, String
arguments) in D:\sites\OpenSourceEdition\Core\RunCmd.cs:line 44
   at DotShoppingCart.OpenSource.Core.DBDeployment.CreateDSCDatabase(String serv
er, String dbName, String path, Boolean outputToConsole) in D:\sites\OpenSourceE
dition\Core\DBDeployment.cs:line 35
   at InstDSC.InstDSC.CreateDB() in D:\sites\OpenSourceEdition\InstDSC\Program.c
s:line 94
   at InstDSC.InstDSC.Install() in D:\sites\OpenSourceEdition\InstDSC\Program.cs
:line 86
   at InstDSC.InstDSC.Main(String[] args) in D:\sites\OpenSourceEdition\InstDSC\
Program.cs:line 81</span>

Any tips?

Try using the local path d:\mssql\data instead of \\dbserver\d$\mssql\data.

Still "no joy" I get the error but the data directory is  now on the web server rather than the sql server

Is it a different error message? If so, could you please post the exception stack?

It's the same message, I'm going to try creating InstDsc_DB with just createDB() and instDsc_web with everything else ... or maybe just add switches /justdb and /justweb

You could use that as a workaround. Alternatively you could create local DB first and then move it to the production server.

Ultimately we want to fix InstDSC to work with this scenario.

Cool! I'm up and running after adding a parameter to the instdsc, Thank you! :)

Cheers. Don't forget to post your site here when your site is live. We are trying to set up a reference list.