Problem with restoring navision database using SQL 2005

dareme76

I am experiencing a problem when tring to restore a navision database using SQL 2005.

The Navision Error i get when i open one of the companies is

"This message is for C/AL programmers;

Could not create an instance of the OLE control or Automation server identified by GUID={79766A7F-90D7-4143-8B23-83A78097E880}, Check that the OLE control or Automation server is correctly installed and registered."

my scenario is the following

1) I have SQL 2005 service pack 2 installed and Navision version 4.02
2) Using Navision i am creating a new SQL Navision Database
3) Using Navision i am restoring previously backed up Data common to all companies and application objects.
4) I am sure i have the correct permissions sia on SQL database and Navision wise.
5) i have the licence correctly uploaded onto SQL
6) Finally i am restoring the backup using SQL.

Please not that yesterday i successfully restored using this procedure but today i wanted to retry it to no avail. To the best of my knowledge i am following the same procedure as yesterday. I have also tried re installing SQL and navision.

Thanks to all

Savatage

off topic for 1 sec (Google is amazing)
in 10 min this post was searchable!
http://www.google.com/search?sourceid=n ... 097E880%7d

dareme76

at the moment i am tying to restore 2 of the companies using navision retore and not sql .... this takes time

kine

For me it looks like not púroblem of restore but problem of some missing DLL used in CU 1 in OpenCompany function... or somewhere else during opening the company... are you trying to open the database on same PC or it is another computer?

dareme76

Thanks to all

I SOLVED THE ISSUE, I HAD TO REGISTER "smtpmailxcontrol1.ocx"