HI! I have a navision backup (complete) from a navision 3.60 own database. Now I want to restore this navision backup (6 *.fbk - files) on a sqlserver 2000. I get the following error message and the restore stopps: The SQL server object n.dbo.session (SQL) which is related to the tabele session(SQL) ist not here. What is my problem? Thanks!
This is a SQL install issue. My first response should be RTFM[;)] before installing SQL. Anyway… The correct solution, is to reinstall everything, but luckily Navision have workaround. The issue is that Navision has a stored procedure that allows Windows logins to SQL. Int he SQL quide there are clear instructions on how to fix it. Also if you are just startig in SQL, make sure that you have a a domain user as Administrator called SA, make sure you have a local administrator on the SQL box called SA, and log into you own client machine as user SA as administrator. Once you have all this working, you can start experimenting with different users and permissions. And do all your initial setup work with DATABASE logins (Both Navision and SQL). If this is a test machine, then use the Navision fix, if it is a production machine, do a complete reinstall to make sure.
But this error is concerning the Session table; I don’t think its related to the xp_ndo_enumusersids extended stored procedure. Can you explain your security setup suggestion, David, because it seems very much over-complicated! Regarding the session error, when you create the empty database but before doing the restore, look in Enterprise Manager and see what is in the Views list. What is listed?
quote:
Originally posted by robertc
But this error is concerning the Session table; I don’t think its related to the xp_ndo_enumusersids extended stored procedure.
Yes Robert I think you may be correct. I just know that I got this same error once, and when I reinstalled the stored procedure everything was fine. So it may have been just reinstalling SQL that fixed the problem. (And yes, I had followed the manuals step by step the first time [:(]). As for the security, I just know that in a few sites I have been, I get scenarios where their Sys Admin wants to limit security, and it always caused me headaches in the early days, since I was unable to identify where the problem was. When you are starting with SQL and Navision, its best to have full Admin rights.
the table 150014 “Session (SQL)” is used by the Client Monitor. the Client Monitor must be installed for the database.