-
Hi everyone hope that someone could help me with this. I'm in charge of a global project for GE and we have SQL Server in each of the countries in the scope of the project, right now I have a problem posting Payment and Cash Receipt Journals for Colombia. We're creating Purchase Orders and then...
-
Hi Guys I am working in Navision 5.0 and we are looking in for a database migration from NAV to the SQL server . Can you let me know the procedure and method involved in it. As such i know how to restore database in SQL front and start working with a fresh database , but i have no idea on the migration...
-
Hi everyone hope that someone could help me with this. I'm in charge of a global project for GE and we have SQL Server in each of the countries in the scope of the project, right now I have a problem posting Payment and Cash Receipt Journals for Colombia. We're creating Purchase Orders and then...
-
Hi Guys I am working in Navision 5.0 and we are looking in for a database migration from NAV to the SQL server . Can you let me know the procedure and method involved in it. As such i know how to restore database in SQL front and start working with a fresh database , but i have no idea on the migration...
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Colleagues; I am pleased to report to you that I have apparently resolved this troublesome issue. The steps I took are as follows: SQL Server steps: 1: A new login was created in SQL Server with no domain specification using SQL...
-
Joshi; Thx for the suggestion. I added the user to the Super (data) group, In sql,he has public and db_datareader only. I can log on and access the profile in NAv, so I'm not sure what that tells me. Anyway, it's still having its dbase user mapping disabled after every user security synch. Cheers...
-
Are you assigning NAV permissions to this user? Are they setup as public? This users permissions should be goverened through NAV permissions. Give them the public role and in NAV give the user the role of SUPER (DATA). NAV will then assign SQL read only permissions to that user.
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Folks; We have configured a reporting user on SQL server (NavReportingUser ) which has data read access only. This profile is the profile we are using to enable SQL Server RS reporting over Navision data. It’s a best practice approach...
-
We are using Navision 4.0(SP3). I am new to Navision and Database Administartion. I got restored the Navision production database backup (SQL Server 2005) in to our testing environment. Everything works fine from when I setup the application from the restored database but I am not able to execute any...
-
hi, im having sql server 2005 running windows 2003 server, all clients are connected via xp Navision sp3. when i run a report 106 for a one company on xp machines (Navision sp3 client), it will show one page only! But when i log to windows 2003 server(i have a client inside (Navision sp3 client), the...