For my job I need to have various RDBMS platforms installed, which includes SQLServer. When I installed MSSQL, I did not install it in the default Program Files/Microsoft SQL Server directory. I will describe the error and then explain what I did to work around it.
The installation sets what looks like an environment variable called something like (the log files are not there anymore) SQLSERVER_TOOLS_DIRECTORY= C:\Program Files\Microsoft SQL Server\90\Tools\Binn and then invokes sqlcmd.exe with the fully qualified path C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd.exe.
The installer obviously detected that sqlserver was already installed since the NR2007 instance was created. However, the NeatWorks mdf/log files are somehow imported/attached to the second instance with the use of sqlcmd.exe. A popup appeared saying that the command did not exist and to search for it and try again. Looked like a pretty standard file not found popup.
Click OK and the installer continues as if nothing happened. Unfortunately,when I tried to start NeatWorks I get an error stating that the database is not up. When the error log is brought up, it shows a dbconnection failure when trying to connect to the nrprofessional database using the sa user. Connect to the NR2700 instance with SQL Studio and you will find that none of the databases were created.
To fix it I had to start the installer and wait for the popup error. The installer does not continue until you hit OK. When stopped the following steps installed the database.
1 Locate the database files extracted from the setup in in C:\Documents and Settings\<current_user>\Local Settings\Temp\NeatReceipts Professional\setup\db\data,
2. Copy them to C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data (although you could probably put them anywhere. Just dont leave them in temp)
3. Open up sqlserver studio express and connect to the NR2700 sqlserver instance
4. Right click on the Databases folder and choose attach.
5. Click add and browse to the folder where you copied the mdf files and add them all. Click OK and they will be attached to the NR2700 instance.
6. Go back to the desktop and click OK to acknowlege the file not found pop-up. The installer will continue and NeatWorks will start.
A suggestion would be to see if sqlcmd.exe already exists in the PATH and use that, or verify sqlcmd.exe exists where it usually does and, if not, see if it is in the path somewhere.
