-
SQL Copy Database User Table permissions
Hi We have started to create a copy of the live database overnight using SQL 2008 Copy Database wizard to create a package which is run in the schedule overnight. I can logon to this database through Nav no problems but the user gets permission problems unable to access User Setup table. All roles look ok and the…
-
Can not print selected Sale order doc. it always show all
Dear I have created a new report. and i want to print only current selected document of sale order.but it always show all records. I know i miss one property for request page but i really forget about it . So could you please advice me ? best regard.
-
Single Syncronization in Navision Sql in a Windows login
Dear all, I just wanna know how to syncronize the single user with sql in windows login mode.
-
Access from NAV to a SQL view in different DB not allowed
Hi, I've created a simple sql view which is selecting date from a table in another database on same server. Furthermore I've enabled this view in NAV, that user can read the data in a form/page. But everytime a user tries to open this form/view he gets an Login-failure: "User ID and password are invalid" Our users have…
-
Display NTEXT variable
Hi, I want to display a ntext variable in NAVISION but i always have an error message. How can i do this ? Thanks.
-
Connection to Firebird DB (ODBC)
Hello, I am new to this great forum and the MS Dynamics NAV product but I need to solve one problem. I've tried to find a solution in many forums but I didn't success. :cry: I would like to make a solution for MS Dynamics version 5 or 2009. Generally I need the NAV to connect to a firebird database and obtain some data. A…
-
Where Are Objects Stored
Hi, Can someone please explain where Nav objects are actually stored within a SQL database? :-k If I wanted to go through SQL Management Studio could I find where the code in CU1 was. I don't want to change anything just curious. A customer has asked me where are the objects in SQL stored compared to a native database and…
-
Problem with collation and codepages
Hi, we are building a database for customer. the customer has company in Finland and China, so we'd need to have both chinese and finnish chars working in the database. We have added the chinese+finnish+english to server's text services and input languages options and we are able to type chinese and finnish letters to…
-
Problems with: SELECT ... WHERE ... LIKE 'S%' ...
(Using R2 - Classic - reproduced in several builds, most recent is 32813) Encountered a strange problem today ](*,) The Customer is in the Item List setting a filter on Item No. like this: "S*" (All Item Numbers starting with capital S) This result is fine, until the user clicks Ctrl-Home to go to the top of the list. Then…
-
SQL index field order different from NAV defined field order
Is there a utility available that will let me compare the SQL index field order compared to the Navision defined field order? I have come into a situation where I found the contact list was extremely slow because someone decided to change the field order of several of the indexes in SQL Server (not in the NAV key…
-
Drop Table?
We have a database with a huge amount of data in the Change Log table (60GB). Is there a way to use SQL command to drop the table without having it write to the transaction log?
-
SQL Collation and Codepages
Hi We have a strange behaviour and I shall be happy if somebody could shed some light on it... The story is to convert a native db into sql 2008r2. After checking the date fields in native and backing up, the nav restore fails because of invalid characters in customer table (character š = alt+0154). When I uncheck the…
-
Sync User Error on Nav 4.0 SQL 2008 R2
Dear Experts, I am trying to move Nav 4.0 SQL DB from SQL 2000 to SQL 2008 R2. When trying to Sync the user with roles, Attached Error Occurs. Is there any solution for this? Thanks in advance for you help and I hope to get back suggestions asap. Thanks alot. Best Regards, Mahar
-
MS SQL Server 2005 to MS SQL Server 2008
Hi, I'm planning to migrate from sql 2005 to sql 2008. - backup database from MS NAV (sql 2005), then create new database from MS NAV (sql 2008) and restore the backup database from MS NAV (sql 2005)? - how can i restore all the users? thanks in advance.
-
The Sales Line table cannot be changed because it is locked
I am calling custom made webservice to create headers and lines inside the Nav database. I get inturrupted in between by this error message. Can anyone please suggest how I can avoid conflicts between 2 calls to update the Sales Line table. "The Sales Line table cannot be changed because it is locked by another user. Wait…
-
Export to excel
Why does it seem that Microsoft made it so difficult to exports in to excel from NAV? I have been using SSRS reports for a long time now and really enjoy exporting to many formats on the fly. I have a report that i am re coding to excel because i an not able to find a good excel tutorial with NAV. The C/AL Symbol Menu was…
-
Database move from 32 bit to 64 bit problem
So we are in the process of moving a SQL2005 SE 32bit database to a new (virtual) SQL2005 environment. After the move we try to connect from Navision to this database, and we receive an error, telling us the file xp_ndo.dll cannot be found. Some research told us this is a needed 32-bits dll, and since we had moved to a…
-
SQL collation
I'm still a bit new with changing collations in databases and I came accross with a problem where I'd need wider character support. We have a Navision 2009 database which has Windows collation, where collation detail is Afrikaans, Basque, Catalan, Dutch, English, Faeroese, German, Indonesian, Italian, Portuguese I'd need…
-
navision sql proc xp_ndo.dll
Hi, When I trying to connect with windows authentication I get error for xp_ndo.dll . I have executed this code for enumusergroups and enumusersids USE master GO EXEC dbo.sp_addextendedproc N'xp_ndo_enumusergroups', 'C:\Program Files (x86)\CSIDE Client\xp_ndo.dll' GO GRANT EXECUTE ON "xp_ndo_enumusergroups" TO PUBLIC GO…
-
Minimum SQL Server Role/Permission to Create New DB
What is the Minimum Role/Permission for a user to create a New Database on the SQL Server. I do not want to give sysadmin Permission because I have other databases that I do not want the user to be able to access. I have tried giving DB_Creator permission, but it does not solve the issue, whenever the user tries to create…
-
Importing data to navision from other sql database direcrtly
Has anyone done interface between Navision and other sql database? Like running a sql query within navision code and retreaving that data to navision database? I'm seeking a way to do so, soo if anyone would have some experience making this kind of link I'd like to hear :)
-
Suddenly unable to modify the User table in some databases?
A customer with NAV5SP1 and a SQL2008R2 server with multiple NAV databases. (1 production and multiple test dbs). All using Standard Security and mainly Windows logins and a few database logins. As part of LogInStart() in Codeunit 1, we have added code to increment "No. of Logins", which is a custom field in the User…
-
Unable to establish ODBC connection using PHP
Please forgve my newbie-ness, if I have posted this in the wrong forum (I couldn't tell by the names which applies) or whether I am asking an old or redundant question. We have Navision 2009 (Nav 6?) running on a Windows Server 2008 R2, and all our employees are running happily with it. Now, I need to create a web page…
-
View permissions
Hi! Does anyone have a "permission-guide" to what kind of permission I need to set on a user in Nav2009 Classic and SQL 2008 when the user needs to open a linked table in Nav which points to a view in the Nav database which gets it's data from to another table in another database on the same server? At the moment it seems…
-
Link between user login and application roles nav to sql
Hello everyone, I am looking for a connection beween the application roles starting with $ndo$ar$.... and the user role on sql. when a new user is created in Navision, I noticed that on database level two schema's are added the first one has the same name as the user, but the second one is created with a the name starting…
-
Impossible to Add a New User in Dynamics Nav Users
I have a super account in dynamics NAV 2009 SP1 with all the privileges. When I want to Add a new user via active directory or sql server connection, i receive a message U don't have Sql Server Permission to activate Security. Please I want to solve this problem and I don't the solution. I have tried to synchronize all…
-
Problem SQL Kill Session script on NAV 2009
I Develope Classic Navision. from 3.7 Until > 5.1 and alwaysUsed SQL scripts (COPY From Mibuso) for Killing Session that have more Idle Time (It' s work on every version Below 2009) but when use this Script on NAV 2009 Classic on SQL 2008 R2, I found the important problem that 1. When Script execute , Session are killed,…
-
Can't see tables in SQL but in NAV
Greetings! This is one of those typical scenarios when a colleague goes on vacation and all shit brakes loose :? The customer has introduced a new EDI functionality and a third part vendor is writing directly to the SQL tables. This has worked without any problems until I uploaded a new license. Now the vendor and even I…
-
Listening SQL insert
Hello, Is there any automation server with triggers that will catch up any insert/update/delete actions done in SQL Server? Regards.
-
Security Role without dbo in NAV 4 SP3 / SQL Server 2008
Hi, Can anyone tell me is it possible to give Security permissions to a user without giving them db_owner on the database. i.e. they have in Navision: SUPER (DATA) ALL SECURITY and on SQL Server they have maybe (windows authentication) securityadmin, datareader, datawriter, public, but NOT db_owner permissions. I can't get…