-
Password expiry policy - SQL DB logins
A general SQL question I can't find the answer for in Partnersource. Using SQL DB logins (4.0 SP3), can we enforce any kind of password expiry or policy? I know I can using Windows Logins, but I see several tick boxes on teh login card in SQL 2005 SMS called "enforce password policy" & "enforce password expiration" . Tried…
-
problems migrating to sql
Hello, I´m trying to create database in sql server options for navision. I keep getting this error: 4628, "01000", [Microsoft][ODBC SQL Server Driver][SQL Server]The ALL permission is deprecated and maintained only for compatibility. IT DOES NOT imply ALL permissions defined on the entity. The database is created but it…
-
how to migrate native databse of navision to sql server 2005
i m unable to migrate native database of navision to sql server 2005 it is showing error g/l entry table how to correct the date of g/l entry table and can we do it through developememt toolkit please suggest me best solution of this
-
Navision Native database to SQL Server Conversion
hi! Planning change database from Navision navtive to SQL Server. What will the procedure to convert native database to Sql Server - ? Can anyone help me. Thanks!
-
navision 4.0 sp3
hello friends, we are abour to start a new project and we have started nav 4 sp3. when i installed the s/w, i found many of updates are not there, like there was hotfix release in mid march regarding new cess, like feature of gate entry and excise reporting are not there.... which i was expecting. what should i do, should…
-
Upgrade from Nav2.6B to Nav4.0SP3 SQL2005
I am starting the process to upgrade a database from Nav2.6B to Nav4.0SP3 SQL2005. I imported the SQLMigrate.fob objects to clean up the data. Had to make a few mods to create the Check Fields codeunit, but got past that point. Now I am running the new Check Fields codeunit and getting an error: Table2000000058 does not…
-
SQL Server 2005 Certification
hi Experts, any idea of SQL Server 2005 Certification details -? Thanks
-
Where is the code??
Hello, I run Nav against SqlServer 2005. Some questions: 1. Does Nav use OledDB to access SqlServer?? or what does it use?? 2. Where does Nav record the C/AL code that I write?? Thanks Asier
-
Trouble in NAV SQL Server
Dear all, I'm having trouble in lookup cust. ledger entry, somehow the Navision seems to process forever ... when I try to use this command : Select top 1 * from Cust.LedgerEntryTable The sql keep giving me "executing query batch ..." status, and it seems that the problem exists only for particular table, since other…
-
Navision 3.7A and SQL 2005
Hi, I have read various posts about Navision 3.7a and SQL 2005. Can someone please clear up for me is there any possable way to run Nav 3.7a on SQL 2005. Thanks
-
Database conflict Tables (SQL Replication)
hi, i've make an backup of an database this is in SQL replication. There existst confilc tables. Like Conflict_Companyname$Item Is store the backup on an other server an there should no replikation. Now, the conflict tabels still exist in the new database. How can i delete this tables in the new database? Regards
-
Unused space on SQL Server
Hello, Since december 2006 were are running Navision 4.0 SP1 on SQL Server2K. We are facing a problem with the size of the database. It growes about 3 GB per day. Looking at tables , somes strange infos appear: Table 355 , Ledger Entry Dimension is about 22Gb with 1.7 Million rows, SQL Server tells about 20 GB unused space…
-
Phantom (ghost) flow-field balance in G/L acct under SQL Svr
We are taking a client live on Monday with Dynamics – NAV 4.0 and have run into an interesting problem I need help with. I have a ‘ghost’ Actual Journal balance in an account, where on the G/L -> Chart of Accounts the Actual total is $1,591.86, but if you drill down to see the G/L entries, there are none. The entries were…
-
Navision 4.0 SP3 - SQL and Create eletronic invoices
Hi all. I encounted a problem when writing eletronic invoices from a SQL server. I had the problem that Navision wrote a error message that it was an invalid OIOXML path I had specified in sales setup. I tried quite a few things. I took a copy of the database and started a native database with the same information. It now…
-
Getting Error: accessing sessions table
running Nav.4.0, on sql2000, I get the following error when I go to File\database\information\Sessions tab and click on the down arrow for the number of sessions. The following sql error occurred while accessing the Sessions table: 535,"22003",Microsoft,[ODBC SQL Server Driver][SQL Server] Difference of two datetime…
-
Upgrading to 4.0 SP3
Hi ... How much of an operation is it to upgrade from SP2 to SP3? The security issues in SP2 are driving my nuts after just four days of running on SQL2005. Regards, Gulli
-
SQL from C/AL
We are using Navision 3.7 native database installation. I have a need to access data in a SQL Server 2005 database. I am needing guidance on how to make SQL queries from C/AL code.
-
Navision 3.70 in SQL 2005???
Our customer is working with Navision 3.70 in a native database. He wants to upgrade the database to SQL. This can be SQL 2000 and SQL 2005? Now I have 2 questions. - Is it possible to work with Navision 3.70 in SQL 2005? - If yes, which version is preferred, SQL 2000 or SQL 2005? Thanks in advance.
-
Information on SQL mirroring, Replication, and Log Shipping
Just and FYI and as I saw some discussions earlier on this topic, and did some testing on my own. 1. Replication – Replication works fine the only issue I had was for some reason the $ndo$dbproperty did not get published as an article so I exported the table over and everything worked after that. I was able to log into the…
-
Navision 5 and SQL Server 2005 on Windows XP SP2
I have successfully installed Nav 5, SQL Server2005 on Windows Server 2003. Now I am trying to do the same thing on my laptop running Windows XP SP2. Nav 5 browses for the server and sees it, but when I try to connect to an existing database or create a new one, I get a message that the database server can not be found. I…
-
Crazy file size on SQL Server
I have a customer whose database file is about 700 MB when restoring into a C/SIDE database file. When I use the same backup file to create a new SQL Server database, that same database file size is about 1.5 GB, so about twice as big. The kicker is that my customer's production database, the one that they created the…
-
permission problem in Navision
Hi, I'm new at Navision and i've just started to configure it to the users. When i've created the logins from active directory i've given the C/AL programmers the super user role. On the sql server i gave them the db_owner role and when they are trying to add the new codeunit or some other code they receve the error…
-
Microsoft Dynamics and SQL 2005
Hello guys Have you started using SQL 2005 with Microsoft Dynamics NAV or GP...??? I am planning to upgrade from SQL 2000 to SQL 2005, any recommendations would be appreciated!!! Take Care
-
Worth a try - SQL 2005 - Included Columns and SIFT
I just heard this from somebody who heard it from somebody at MS, no name so take it for what it is worth. In SQL 2005 you there is a new feature where you can add columns to a clustered index as "Included Columns" that exist on the index page but do not require stats maintenance that the actual index columns do so they…
-
Navision - SQL Logins
hi! Experts.............. we are planning to migrated from Navision Native Database to SQL Server, Problem facing :1. how to transfer all native database logins to SQL Server, in user table it is show all the users, but unable to login. right now creating sql logins manually same as native database logins. any right…
-
Error login MS SQL Option with MBS 3.70
Hi, a have some problems to login on a MS SQL server option for MBS 3.70. I have various server running this option and I only have problems with one. At this one when I try to login MBS Client shows this message: "User\Password Incorrect, try with another user\password." Analizing the process with SQL Analizer I observe…
-
SQL questions
Well, it is not really a Navision Tip&Trick, but these forums can be helpfull for SQL-issues. http://www.sql-server-performance.com/forum/default.asp http://www.sqlteam.com/forums/default.asp
-
Using NODBC (Nav 4 SP2 ) on a SQLServer2000 Instance
Hi, I am using NODBC of (Nav 4 SP2 / SQL Server 2000) on a SQL Server 2000 Instance to an external system. When i try to setup the NODBC, it doesnot identify the server and also it doesnot let me select a company name. Does NODBC support Sql Instances? Thanks.
-
Nav 3.0 SP3 on Vista with SQL2005 SP1
I've installed the latest Navision NL4.00 SP3 with Vista update. When connecting to a SQL2005 SP1 database, I receive a message that the <SQL-servername> cannot be found. Despite, that the servername is showing up in the servername lookupwindow. But when trying to select a database, i receive this message. I've also tried…
-
Business Analysis and sql 2005
I have install sql 2005 with analysis server, but when i am configuring BA its not get connected to sql 2005. Is there any service pack required in sql2005 or any other issue.