Hi all, One of my customers has tried to create a new test-server. They have installed win2003, and SQL2000 - SP4. (Same as the production-server) They have taken an old back-up, and restored it on the new server. They created logins, and gave them database-access to the new test-DB. Now they can’t even chose the database inside Navision, as they get an error like the subject, when they press the assist-button in the “open database”-dialog, the field to define the database. Could someone please point me in the right direction??? regards Alexander
I guess you registered the xp_ndo.dll as required ?
check the permissions of the DB users at the old and the new database. See page 100 in w1w1sql.pdf from your Navision Installation CD
Hi Thomas, The ‘xp_ndo…’ seemed to do the trick. But I don’t understand why. As I understood it, ‘xp_ndo…’ was only needed when using windows-authentication. My customer uses DB-authentication only. Is it perhaps because the server is installed with mixed-mode? Well. Thanks anyway. You’re the man… regards Alexander
Hmm… The only table that Navision creates in the ‘master’ db is the license file store – [master].[dbo].[ndo$xxxxx] – (I forget the specific table name). This table is created on ‘first connection’. This first connection therefore must be performed by a user with sysadmin role membership.
Hey Fritz, This corresponds with my own assumption. I told my customer that they properly had to have ‘sa’-like rights on the server the first time they connected. But they specifically stated that they had tried this, before they called me. I bet he tried it while I searched for an other explanation, and then (in order not to admit to having made a mistake) he just told me that now it works. Thanks a lot. regards Alexander