NeatWorks 4.x on Windows 7 RTM.
August 10th, 2009 | Author: JHardison
I have finished testing The Neat Companies NeatWorks 4.6.2_152 product
on a fresh install of Windows 7 Ultimate (32bit and 64bit).
Through this process I have found that during install if you fail to run the
initial install as an administrator, you will need to perform an additional
step to get the database running correctly. The install will complete
successfully, or at least appear that way even if you don’t do the install
as an administrator.
Now first of all, by run it as administrator I am an administrator, but
this is specifically if you have UAC still turned on. Since under UAC even
an administrator is not an administrator without saying you want to be.
So to run the initial install as an administrator, you simiply right click
on the file and click ‘Run as Administrator’. That’s it!
Now if you forget that step or don’t even think about it, you will make it
through but then receive errors along the lines of:
8/8/2009 10:11:43 AM MDIParent MainMachine Info : OS: Microsoft Windows NT 6.1.7600.0 .NET CLR: 2.0.50727.4927Assembly Base: file:///C:/Program Files/NeatWorks/exec/NeatWorks.exeAssembly Name: NeatWorks, Version=4.6.2.146, Culture=neutral, PublicKeyToken=nullAssembly Vers: 4.6.2.146Error Message: Cannot open database “nrprofessional” requested by the login. The login failed.Login failed for user ‘sa’.Exception Type: System.Data.SqlClient.SqlExceptionTarget Site : GetConnection–StackTrace–: at System.Data.ProviderBase.DbConnectionPool.GetConnection
(DbConnection owningObject)at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
DbConnectionFactory connectionFactory)at System.Data.SqlClient.SqlConnection.Open()at NeatReceipts.Components.Database.DBConnection.GetConnection()at com.digitalbp.state.ccSystemSession.firstLoginCheck()at com.digitalbp.state.ccSystemSession..ctor()at Program.SetupUserSession()at Program.Main(String[] args)User Message : Cannot open database “nrprofessional” requested by the login. The login failed.
Login failed for user ‘sa’.
In this case you will need to do one item over again, or you could uninstall and reinstall, but that will take
a lot longer. So lets begin!
- Open the path: %Program Files%\Common Files\The Neat Company\Setup\
- Right click on ‘Neat Database Setup.exe’ and select ‘Run as Administrator’
- Complete the following install as normal, and upon completion your database will now
be working and you can launch NeatWorks without an issue.
If you have for some reason not done a fresh install of Windows 7, but instead have
performed an upgrade… the one issue I have noticed is a delay in starting the
‘Database Controller Service’ before the SQL instance is started. Other than running
services.msc, you can also check in one location for NeatWorks status. You may open the
‘Support Center’ by Expanding Networks and Support Tools, then clicking on “Neat Support Center” in your start menu.
This program will let you view log files from the application, as well as submit support
information to The Neat Company. But one tab in particular is a simple view of your NeatWorks
related services. A note about this screen, on Windows 7 it will still say the OS is Vista.
But the version number will be correct, it is simply the application does not know what Windows 7 is.
Posted in 
