-
About Identifiers
Hello, I ask you if there is some relationship between the field Identifiers in DB SQL Server under File->Database->Alter , Integration Tab Convert Identifiers / Remove Character and the Field Identifiers under ODBC Setup - Options that is an option between All Except Dot, All Characters, All Except Space, "a-z,A-Z,0-9,-".…
-
Synchronize Record Link Tabble Version 5.0
Hi We are having issues after upgrading to Version 5.0. Have added "Record Link" permission as a new role and trying to synchronise logins (all and single login). The problem is that the "Record Link" table is Blocked on SQL by all the users on the system. The only way to perform a synchronise is when all users are logged…
-
Sql server user-check for identical password
Hello everybody, A customer of mine has NAV 5 with the sql server option (sql 2005), and he needs this check: Every time a user changes his password, he must not use a password he already had used in the past. The problem is that I don't know how to do that. In sql server I don't think there is something, and it seems that…
-
Date value Problem
hello, i try to upgrade NAV 4.03 to SQL 2005. It's my first time that i try that so maybe someone can help me. After Creating a new Database on SQL 2005 i want to restore a exiting NAvision Database. I get the Error: the customer table contains a field with a date value that cannot be used with Sql 2005: Rec. No. xyxyx…
-
Standard backup and restore with SQL
Hello, I am not well versed in SQL but have come into a situation where I need to do a backup and restore for a client running 5.0 with the SQL server option. Is there any documentation out there that can step me through the process of doing a backup/restore through SQL? Thanks in advance for the help.
-
Cyrillic, Italian, English in 1 company on SQL with NAV 5.0
I searched for this but I didn't find anything conclusive. We have 1 SQL DB in which we need to use some very different languages together (Ukranian, Bulgarian, Romanian, Italian (Italy and Swiss), English). We already have a DB in use for Italian. My first thought was to split up the different languages in different DB's…
-
DB access in Nav only possible with db_owner role in SQL2005
Hello, I realized that a user can only open the database with the Nav40SP3-Client if he/she is given the role db_owner for this database in SQL Server 2005 (in db in SQL Server 2005: right click the user name under security, users, => Properties) How can that be? Why does not db_accessadmin or db_datareader suffice? Why is…
-
SQL Server 2005 Express on Server and Navision 5.0[5 client]
Hello, I ask you if SQL Server 2005 Express on a server with various client pc(probably 5) is fully and completely supported by Microsoft Dynamics Navision 5.0 SP1. I know that SQL Server 2005 Express should be supported in installation standalone [with client and dbms on same machine]. We have a customer that has already…
-
changing domain administrator password with sql
Hi, i need to change the domain administrator password. We also use MSS SQL 2005 for our NAV database. Does anyone know if this action will cause problems ? We log into the sql database also with SQL Server Management Studio which uses the administrator windows login to connect.
-
Rebuilding SIFTs, building on Waldos idea
Waldo once posted an idea for using a report or codeunit to rebuild SIFT indexes. It was something along the line of: Using the virtual KEY table uncheck the "MaintainSIFTIndex" option, modify, check it again, modify. You now have a completely clean SIFT table free of zeros, fragmentation etc etc. The main issue however is…
-
Rebuild SIFT Tables
Hi, Couldn't find anything using a search - is there anyway to force the system to rebuild all the SQL SIFT Tables? I can remove, then add the SIFT indexes, but this is time consuming. We are looking at clearing out our old company and starting again. I want to delete all history (ledger entries, posted pos, etc.) in SQL…
-
Changing SQL TCP Port from 1433
Hi I am Installing SQL 2005 with NAV 5.0 sp1 in Windows Server 2003. My User does not want to use the SQL default port 1433. I have try changing the port from 1433 to 1434 using SQL Server configuration Manager, restarted the services and firewall port is opened. However only the Server is able to connect, other PC in the…
-
How to filter "Value Entry" with Multiple criteria
I want to filter "Value Entry" table on "Source No." and "Item No." fields using multiple criteria. To be more specific I have 1 table for the Customer and 1 table for the Item and I want to collect X Customer and X Items and use them to filter the "Value Entry" table. The result will be something like this:"Value…
-
SQL Trace Flag 4616 error...
I keep getting a SQL Trace Flag error (4616) message when trying to connect to the server. (I am running NAV 4.0 under SQL) I know how to solve this problem, going into SQL Management Studio and executing a query ..... DBCC TRACEON(4616,-1) But the weird part and the problem is that every time I reboot the machine I have…
-
How to Show Navision Item Card image in Reporting Services?
Hi, I am trying to build a report that also includes Picture field of an item. But i am unable to display it in Reporting Services? Has anyone experienced a situation like that before? Whenever i tried to add an (Database) image in the report, I simply get only the N/A placeholder instead of image... Any help…
-
SQL Server 64bit Option with Navision 4.7
It has been recommended that we use a 64bit SQL Install to take advantage of some of the Memory usage in SQL 2005. Does anyone have any experience with Navision in a 64bit Installation?
-
How to attach existing SQL-users to new Database
As part of a go-live senario on SQL 2005, I'm trying to find a easy way to copy the userlogin from one database (systemstest DB) to another (Go-live DB). I have a systemstest-database and a future Go-live database on the same SQL2005 server. As part of test 70 users have been created with acces to the testdatabase. These…
-
reporting user is disabled in SQL Server after synchronizati
Related post: (~ref "Recommended security setup for SQL and ODBC?"~ http://www.mibuso.com/forum/viewtopic.p ... highlight= ) 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.…
-
server wont show up on Navision clients server list??
I have up running SQL service with navision database on it, but the server itself wont show up on Navision clients server list when I'm trying to open it. But if I type the server name manually on the servername textfield and browse databases it founds the database and I'm able to connect it. Anyone had this problem?
-
DCMEMSTREAM contains error
I have a SQL2000 server. There are two DB in this server, one is in Nav3.7 and another in Nav4.0SP3. We can access the Nav4.0 SP3 DB but not the Nav3.7. At time of open the Nav3.7 Db it shows an error msg. “The file DCMEMSTREAM contains a record that cannot be read completely.” How can I solve it???
-
Sychronizing Attain - SQL server not working
Hello, Running Navision Attain 3.6 and using MS SQL Server 8 We migrated our native Navision Attain to SQL Server several months ago and all has been well. When we add new users we add them via Windows Logins screen and use Windows Authentication. The issue now that we were unaware of is that the local Database Logins in…
-
SQL Query optimizer
Hi, I had a question about the query optimizer used when NAV works with SQL server. As I understand it isn't required that one uses the SETCURRENTKEY command in NAV anymore, since the query optimizer will deceide which is the most effeient key. One could think that this picking the most efficient key by the query optimizer…
-
SQL Error when importing objects
I am trying to import objects into Navision SQL. Some of the columns in the table are being deleted. All the data in the columns are blank or zero, but I get and error message which reads as follows: The statistics (column name) is dependent on (column name). ALTER TABLE DROP COLUMN (column name) failed because one or more…
-
Does SQL ODBC Driver for SQL 2000 works with SQL 2005
Don't ask me why, but the customer wants/needs to use Sql ODBC Driver from SQL 2000 with a SQL 2005 database (with Dynamics NAV). Does this work? EDIT: I have some more info now. They want to query the NAV database to get some data into Access. The PC has the ODBC drivers installed for SQL 2000. The NAV data is stored in a…
-
Which book is best for SQL newbie?
Hey people, My company want me to completely take over the administration of the SQL side of Navision. I know NOTHING about this. Thankfully i am a good reader and a fast learner so this shouldn't be a problem. Which book(s) are gonna be best for me to learn from? The company can't afford a course so i'm just gonna have to…
-
Login problem
hi, we are using German version of NAV 4.0 with Windows authentification. We have one user which username contains special German characert: ö (f.e. König). he can normaly login to windows, but to NAV his login failes. in the list of windows users and groups his username is correct: König, but if I pick his username to put…
-
Automatic Backup Procedures
Hi, What are the various alternatives to take automatic backups of Navision SQL Server database? Are there any documentation available? Thanks, Best regards,
-
datetime 2 hour diference
http://farm4.static.flickr.com/3256/2734858447_cfcfa3500c_o.jpg sombody please explain why there is a 2 hour diference between sql and nav
-
Deadlocks in custom changelog
Hi, I've created a custom changelog based on SQL triggers (Navision 3.70B, SQL2k). Log table has an autoincremet primary key and during testing concurrent transactions were able to add records without locking each other on this resource. The main "logged" tables are Sales Header, Sales Line, Reservation Entry and Item…
-
Reporting services report launced from Dynamics NAV
Hi€ everybody, i'm new with this community and Nav too. I've a problem: I'm looking for a solution about launching a report of MS SQL Reporting services directly from Dynamics NAV (as press preview button in Sales Invoice) passing parameters too. I'vent found any help. Do you know any solution? Sry for my bad english.…