Hey Luke,

 

I am trying to install sql and web on different servers and getting this error. Do you know what might be the problem?

 

Thanks

 

C:\DSC\Install>InstDSC.exe CDC-DB1 dotshoppingcart C:\database\sd9000 c:\Encrypt
ionKey mail.temp.com temp@temp.com
Creating database CDC-DB1.dotshoppingcart at C:\database\sd9000 ...Running sqlcm
d -E -S CDC-DB1 -v DatabaseName="dotshoppingcart" DefaultDataPath="C:\database\s
d9000\" -i "C:\DSC\Install\CreateDB.sql" -b

Unhandled Exception: System.ComponentModel.Win32Exception: The system cannot fin
d the file specified
   at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startIn
fo)
   at DotShoppingCart.Commercial.Base.RunCmd.RunProcess(String filename, String
arguments)
   at DotShoppingCart.Commercial.Core.DBDeployment.CreateDSCDatabase(String serv
er, String dbName, String path, Boolean outputToConsole)
   at InstDSC.InstDSC.CreateDB() in C:\sites\DotShoppingCartSuite\InstDSC\Progra
m.cs:line 98
   at InstDSC.InstDSC.Install() in C:\sites\DotShoppingCartSuite\InstDSC\Program
.cs:line 90
   at InstDSC.InstDSC.Main(String[] args) in C:\sites\DotShoppingCartSuite\InstD
SC\Program.cs:line 85

You need to make sure the folder C:\database\sd9000 at machine CDC-DB1 exists first.

It does exist.

Does C:\DSC\Install\CreateDB.sql exist on the local machine?

Yes.

Then try to run the following directly.

 

sqlcm d -E -S CDC-DB1 -v DatabaseName="dotshoppingcart" DefaultDataPath="C:\database\sd9000\" -i "C:\DSC\Install\CreateDB.sql" -b
 

 

SQL is not installed on the webserver. I am getting sqlcm is not recognized command.

Ah, that was the problem. SqlCmd is the client tool. Try to install the SQL client to your web server.

Luke,

 

I am trying to setup a test environment. I replaced the code from production on test site and also did the dabase restore from a backup from production.

 

The front end pages that i have are loading fine. All the products are also loading in the test environment but when i hit login or register, its timing out.

 

Am i missing something?

 

Thanks

 

-D

i also updated the encryption key on the test machine. Is there anything else?

Are you still expericening the problem? Is there any exception stack or error message?