AI OnAI Off
ECF installer error: 'sqlcmd' is not a recognized internal or external command, operable program or batch file
Hi,
I think you need the sqlcmd utility on the machine you are running the installation from. I don't know if you can download and use them seperately, or if you need to install SQL Server as well though.
Jan 10, 2011 9:15
As far as I know, sqlcmd can not work standalone (see http://stackoverflow.com/questions/2290903/run-sqlcmd-without-having-sql-server-installed/2291123#2291123)
If it turns out sqlcmd (and hence, SQL Server) needs to be installed on the machine where the installation is running from, this is a pretty serious flaw in the installation concept. I mean, the whole point of using separate servers is to keep web and database separated.
Also, the Commerce install guide or MediaChase ECF doc does not mention this dependency at all - in fact, it specifially says you can have your db on a server other than where you're installing ECF. :-O
Jan 10, 2011 9:50
Hi,
According to your link you can run the sqlcmd stand-alone.
http://www.mssqltips.com/tip.asp?tip=1807
Jan 10, 2011 9:58
How did I miss that?? *shamed by own poor research* I'll try to install that.
EDIT: Oh, and after re-checking, I see that SQL Server Native Tools and Command Line Client is also mentioned in the ECF doc. So that's 2 out of 2 eff-ups from me then. However... :
Still, it is a requirement that is not mentioned anywhere, and it is still mixing SQL Server components into a Web server environment - not necessarily something that all server admins would agree to immediately.
Edited,
Jan 10, 2011 10:05
I see your point, but then again you could just uninstall the components once your are done installing Commerce.
Jan 10, 2011 10:27
<p>Thanks for your help Tobias. Since my database server is SQL Server 2008 R2, I downloaded Native Client and Command Line Utility for SQL Server 2008 R2 from this URL:</p>
<p><a href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52&displaylang=en">http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52&displaylang=en</a></p>
<p>and installed them on the Web Server. After installation, I put the path to the sqlcmd executable <br />(typically "C:\Program Files\SQL Server\100\Tools\Binn") in the Windows %PATH% variable.</p>
<p>I was then able to run the Commerce installer successfully :-)</p>
#46952
Edited,
Jan 12, 2011 14:04
Great work, thanks for expanding on my post and provided a download link :)
Jan 12, 2011 14:05
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
Been trying to reinstall Commerce on a new server, but I'm having trouble with the ECF installation, step 4 (Setting up the site database).
First I installed a new EPiServer CMS 6 site (on a Windows Server 203 R2 server).
The site's database was installed on an SQL Server 2008 server (webserver and database server have separate IPs, but are on same subnet).
Then proceeded to install EPiServer Commerce on same webserver and same database server as CMS 6 site.
Error during ECF installation:
" 'sqlcmd' is not a recognized internal or external command, operable program or batch file"
at Mediachase.EcfConfiguration.EcfInstallForm.SetupDB()
(at step 4: Setting up the site database)
I tried to RDP into the database server and run 'sqlcmd' from command line, which works fine (proving that sqlcmd is in the PATH variable).
This also happens if I try to use SQL Server 2005 for the databases.
According to the MediaChase installation requirements doc for ECF 5.1, both SQL 2005 and 2008 should be supported, and database does not have to be on the same machine as the ECF program files.
(http://docs.mediachase.com/display/ecf51installanddeploy/System+Requirements)