I can manually open the SQL database using SQL Server Management Studio Express and loggin in.  There is an Ayanova database entry but nothing in it?

I am not sure why it is stuck on 1% for you. I've just tested it again here, and it works with no issues. Perhaps your computer is overloaded and it's waiting for resouces before it can continue, or something else is preventing the tables in the database from being created and data copied to it, or ...

Do the following:

1. Shut down the ToMSSQL.exe utiltiy
2. Shut down all other programs that are running - i.e. anti-virus program, etc 
3. Delete that AyaNova database via SQL Studio Express (select it, right-click and select Delete)
4. Close the SQL Management Express Studio
5. Reconfirm again that you can log into AyaNova itself that connects via the default connection  - On this same SQL computer, log into the AyaNova program, select menu Help -> About AyaNova -> confirm it says 4.1.5, and that the connection is showing as connecting to %AllUsersProfile%\AyaNovaData\AYANOVA.FDB
6. Exit out of AyaNova
7. Now run the ToMSSQL utility again
8. Confirm that Firebird Connection String is ServerType=1;DataBase=C:\Documents and Settings\All Users\Application Data\AyaNovaData\AYANOVA.FDB;Dialect=3;
9. Confirm what the SQL connection string is
10. Confirm that the Open database connection successfully connects
11. Click on the checkmark to begin the firebird database to SQL database conversion
12. Post back your results

Make sure you are doing this from the SQL computer itself, if any step different than what is explicitly stated, also identify that.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I made sure that both are running the most recent version of Ayanova.  I ran the database back on the existing server using the Microsoft SQL Management Studio Express.  On the new computer I manually created the Ayanova database after having deleted it.  When I go to restore the database which I have the backup of I get the error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'CPU-OFFICE\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Ayanova' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Am I doping something wrong to get this data on the new computer?  Thanks for your help

Restore worked okay - Now for the wbi etc