-
Synchronize Login Error
Hi, When i try to Synchronize All Logins (SQL Logins with Navison Logins) in Navision i get the following error The following SQL Server error or errors occurred: 2714,"42501", [Microsoft] [ODBC SQL Server Driver] [SQL Server]There is already an object named '$ndo$ar$336DD6064F4F3B5118CC6A827F102EDO' in the database.…
-
SQL Server primary datafile setup
Hi guys, I'm comming from a DBA background (more Dev. and reports than physical setups). I just had a quick look at our server after 3 months in production post Go-Live. Apparently the initial install was made with 32 GB of datafiles. That seems appropriate for the next 2-3 years of data. However after looking at where the…
-
Servers for SQL databases - HU, PL, CZ, RO cases
Hi, We are planning install NAV databases for HU, PL, CZ and RO. Since their languages belong to Latin2 family, I decided to install them on a separate SQL Server whose non-Unicode support is set to one of the languages of these countries. Is there anyone who has experienced NAV database installation for these countries ?…
-
Purchase SQL Licenses?
I found some information on this using search, but it was pretty old, so I figured I'd ask again to see if anything has changed: Where can I find information on the difference between SQL Runtime and Enterprise Licenses? And is it still true that if they own SQL Server already that they don't need to buy these at the time…
-
Navision security synchronization error lock request time ou
Has anyone seen this error when synchronizing (NAV 4 SP1, SQL Server 2000): Navision security synchronization error lock request time out period exceeded? Thanks a lot in advance! Regards Chri
-
Can't figure out the taxes in MS Dynamics Nav 2009 SP1
I've been tasked with writting a few reports / aspx pages and I need to figure out the taxes to apply depending on the cust. #. I'already asked 2 Nav dev and they couldn't explain it to me (not their area I guess). 99.999% of our clients are in Canada so that means either none, only 1 tax applied or 2 taxes, and the 2nd…
-
Relate Record ID to a replicated record question..
Hi guys, I have no idea where to ask this question in the forums so lets try it here... I have a situation where I'm using SQL replication to replicate tables out of my NAV database to a separate SQL database.. I want to be able to replicate the "Record Link" table... actually replicating the table shouldn't be hard, but I…
-
Problem with ODBC connection Navision/SQL Server 2005
Hello, I have created a SSIS package which copies data from Navision 3.70 database to SQL Server 2005. I'm using C/ODBC driver 3.70. DNS is set up, connection test in SSIS package Connection Manager says ok. Data Reader Source of SSIS Data Flow Task says when being executed: SSIS package "Package.dtsx"…
-
View Server State
Hello I have seen a strange behaviour 2 or 3 times when technically migrating older Nav solutions to Nav 2009. The users without special sql server roles needed to have sql rights on VIEW SERVER STATE. There are some threads around this topic, but I would like to see the case in a greater contecxt, I'm sure other reader…
-
SQL user language problem
Hallo, I had make are new installation. Server 64 Bit 2008 and SQL 64 Bit Standard 2008. Es running all fine and fast, only one problem. Differnt user get by log on in german the problem, that we had a errogmessage. The NAV Client 5.01 get the message it is only ja/nein possibility and not yes. When he made the client on…
-
SQL Server native client support?
Hi there, anyone knows if there are plans for SQL Server native client support in future releases of Dynamics NAV? Sadly, at present time we, are still unable to fully utilize automatic failover for database mirroring as clients (and NAS, and NAV Servers etc) still have to be reconfigured manually.
-
How to recreate data in the SIFT table Company$17$0
Hi all. I dropped through SQL SIFT table Company$17$0, because data inside this table was not correct. How to recreate data, table very big (200GB), I try enable and disable flag MaintainSIFTIndex, but nothing happened. Help me,please. P.S. Navision 4.0 SP3 and SQL Server 2008.
-
Accessing another NAV database on different SQL Server
Hi, I want to access a NAV database on different SQL Server from within a NAV database, can this be done? For example: I have two SQL Srver A &B placed at diffrent locations. Each SQL Server has one NAV database and each database further has 3 companies in each.Item master (Item No. only) of these databases & companies are…
-
Does NAV Register Login Synchronization?
Does NAV Register Login Synchronization? Or in other words: is it possible in standard NAV to reproduce when (and by whom) the logins have been synchronized with SQL Server?
-
Errow during sql server 2008 installation
please solve this error.......
-
Incorrect syntax near the keyword 'WITH'
Just want to share info. I'm was creating SQL Query to launch from Navision with ADO. The Query was some thing like:WITH CONTR AS ( SELECT CT.[No_],CT.[Customer Name],CT.[Address],ROW_NUMBER() OVER (ORDER BY [No_]) AS RowNumber FROM dbo.Contracts CT )SELECT * FROM CONTR WHERE RowNumber BETWEEN 1 AND 10 In SQL Management…
-
Suddenly unable to login using Database Logins??
(NAV5SP1 - update 1 and SQL2005) I have a customer who all of a sudden got problems logging in with his database users. The customer primarily uses Windows users, but for some reason a few users had to login as database users and is created as such on the SQL server. This has worked fine for a long time, but suddenly they…
-
How copy the entire database
Hi, a few days ago I've migrated to my 3.70 version to SQL. The problem is that I can't copy and entire local copy of the .fdb database. When I do it, it shows only the data before migration, it's very strange. I need it entire to do local testings. Before migration I could do "copy and paste", for example, but now I…
-
NAV 50 SP1 & SQL Reporting Services
Hello everyone, i have the following situation: Server NAV-SRV with SQL 2k8 and NAV 5.00 SP1 Server REPORT-SRV with SQL 2k8 and SQL Reporting Services Database NAV "duplicated" with log shipping from NAV-SRV to REPORT-SRV Problem: When i use a report with a data source on the "standby" NAV database on REPORT-SRV i get…
-
SQL Activity Monitor: Microsoft Dynamics Nav 'Client'
Hey all, I have been stumped regarding this issue for so long that I've decided to register here in hopes that anybody can give me some more tips in order to solve this riddle. Whenever we start the 'Activitiy Monitor' on our SQL instance running the Dynamics Nav DB. we can see who is logged in, from which machine, using…
-
MDS (Master Database Services) installation
Hi folks, SQL Server 2008 r2 Windows Server 2008 r2 both 64 bit Re Installing "Master Data Services (MDS)" coming to the "System Settings" page I mistakely clicked "Exit" without proceeding "Web Configuration" Restart "Start -> Configuration Manager" (I'm administrator. No user created) -> Database -> Select Database ->…
-
Updating / Inserting data directly into SQL-Navision-Databas
Hi there, we are running Navision 3.70 (5.0SP1) <-- that's how it is being presented in the Navision client itself.. from my understanding, it is technically 3.70 but running on a 5.0 client, not 100% sure though) on a SQL 2008 database server. In the first step of a project, we would like to read some data and update it.…
-
SSRS error in SQL server reporting services
Hi, When I tried to install Microsoft SQL Reporting services for MS SQL 2008, It gives an error. Anybody knows how to sort out this. Path: Start -> Ms sql 2008 -> Configuration tools -> Reporting services configuration manager -> Reporting services configuration connection. Error: Unable to connect to report server WMI…
-
NAV 5 - SQL2005 (Windows Logins) Issue
Working on SQL2005/NAV5 [Security Model: Enhanced] I have noticed strange issue. If we create a Windows Login in Navision, and synchronize all security, username in sql will be created (with its own schema attached to it). Let's say we do not give super role to the new user, just some roles to read customer table, etc.…
-
SQL <-> Navision communication protocol
Hello, For a customer I need to know what communication protocol is used by SQL to communicate with Navision and/or this traffic is encrypted. I've did a packet lookup with Wireshark and saw that the data was encrypted (correct me if I'm wrong). Regards Thomas
-
Which permissions are needed to add new users to NAV SQL DB
Hi, Can anyone tell me which permissions/rights are needed for adding new database users in NAV and synchronize them correctly. It seems like NAV role SUPER is not enough, but that permissions on the SQL Server are also required. With Server Role Sys_adm and NAV role SUPER, it is possible to add new users and synchronize…
-
Inserting into sql table via codeunit
Hi. Cany anyone tell me how to insert data into a SQL table via a codeunit. Specifically a SQL table that is not part of NAV. I’m just wondering if any of you have a sample of a codeunit using an OleDB (or other) connection to write data to a SQL table directly. Thanks. steve
-
How to we disconnect idle connection in Navision?
how can we disconnect idle connection in the Navision? It takes up our license space when we only have 10 user licenses. We are currently using Nav 2009 with Sql server 2008 R2 setup. Thanks in advance :)
-
Nav 3.70 database with Nav 4.3 SQL client on SQL 2008?
Goodday, It is said somewhere on this forum that "MS has already said that they will not be supporting anything prior to 5.0 SP1 on SQL 2008. Even that may need updates. NAV 4.0 SP3 (with updates) may be an exception." Could anybody give me an (MS) URL where I can get this information confirmed? A customer with a 3.7…
-
NAV 3.70 on SQL 2008
Hi, is it possible to run NAV 3.70 (SQL option) on MS SQL2008? We want to move from SQL 2000 to SQL 2008. What are the necessary steps to do it?