Dear
I have recently Migrated Navision 4.0 sp1 Native DB to SQL database option.
I have successfully restore it.
now i am able to connect the sql database option thru finsql option on the server.
however when i am trying to connect it from other machine it is able to search that server but not able to connect it (database is not there in lookup).
what may be the problem.
Thanks
Ashish
If you were connecting on the sql server you were probably using the SA login so it was fine, when connecting from a client you need to make sure the login has permissions for that database on the server. Just connect from the sql server again and add the client login to the Windows Users (with correct role) in Navision and try again. You may also need to set the Session View to have public SELECT permission