-
Business Notifications - SQL Notification Services
I'm trying to install the Business Notifications application. I've installed the IIS but now i need an MS SQL Notification Service. Anyone can tell me where I can find this installation file? I've tried the MS Dynamics CD but cant find the right folder! thanks in advance! Chri
-
SQL Server 2005 Service Pack 3
I see that Service Pack 3 was released this week. Probably too soon to ask if any one is running it live yet, but I am just about to install it on my test server, and wondered if anyone has any comments about it. Did anyone do any testing with the CTP? SQL Server 2005 - Service Pack 3
-
Nav Error caused by SQL Replication process???
Hi guys, I need your help to fix this issue,guys. I get an error message when I upload fob file to Nav that contain replicated tables, the error message is:Microsoft Dynamics NAVThe following SQL Server error(s) occurred while accessing the Item Ledger Entry table: 3724,"42000",[Microsoft][ODBC SQL Server Driver][SQL…
-
Data van SQL SERVER overzetten naar de demo tabel van NAV
Hallo, weet iemand hoe ik van SQL SERVER studio express gegevens van sql server naar de demo tabel CRONUS van navision kan krijgen. Ik kan de gegevens wel van navision in sql server plaatsen. als ik dan in sql server records toevoeg en ik dit dan weer in de C/SIDE van navision terug wil zien staat de nieuwe data er niet…
-
Starting a NAV process from SQL. Ideas?
I have a few spots where I'm using ADO to fire off SQL processes from NAV. The example below is used to start a SQL index maintenence job following a nightly adjust cost. Since I never know how long Adjust Cost will run this cannot be simply scheduled. Instead I run the below code from the Adjust Cost process. This has…
-
SQL reporting services query question.
Hi there I have build a query wchich does not work very well. I need the following info. I need to be able to filter on an item fields and view inventory data sold which will include Posted invoices and posted Credit memos. Here is my query. SELECT [Cronus USA$Item].No_, [Cronus USA$Item].[Item Category Code], [Cronus…
-
install xp_ndo.dll on SQL SERVER
Hi everybody, I'm try to setup NAS for SQL 2005 server. I´ve installed both procedures xp_ndo_enumusersids and xp_ndo_enumusergroups executing this query, USE master EXEC sp_addextendedproc xp_ndo_enumusersids, 'C:\Archivos de programa (x86)\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\xp_ndo.dll' GO GRANT EXECUTE ON…
-
Synchronise all users
Hi Everybody, When clicking on synchronise all users, does the synchronisation includes both database and windows logins or is it restricted to just the window logins? Steve
-
Error while opening sales shipment line table
On opening sales shipment line table, i get following error: "[Microsoft][ODBC SQL Server Driver][SQL Server] Attempt ot fetch logical page(3:380765) in database'test-db' belongs to object 'test-company$32$5', not to object 'Acompany$Sales Shipment Line' ". Please note that I am opening sales shipment line from company…
-
Syncronization problem
yesterday i encountered a strange behavior between sql and nav. I admit i am not a sql expert, i know only the base of the base....of the base :mrgreen: First things first: sql 2005, nav 4sp3, sql authentication. There is a database on server X with three users, let's call them A,B,C (creative, huh?). i've just restored a…
-
Transactional replication in SQL
In transactional replication whole table is get replicated or only that transaction is replicated in which the transaction is occured?
-
SQL Server connection problem
I have a Nav4 sp3 sql server database which all of a sudden does not allow navision sql clients to access it. When trying to connect (using database authentication) the following error is shown. The SQL Server cannot be found. This has been working fine for months. Any ideas? The server can be successfully pinged it is…
-
Security - You do not have permission.......
Good day, I am curious what is forcing me to re-synchronize permissions. I am using NAV 5.0 on SQL 2000. I have been making some changes to custom functions that affect the side panel of Sales Quotes and Sales Orders. I think it revolves around custom flowfields and the need to add/modify keys. Amongst other changes, I…
-
Change location of log file?
Hi all, "A friend" :oops: has by mistake installed both the SQL datafile and the log file in the same folder on the same disk. The log file was supposed to be placed on a seperate disk. I know this can be changed - I am just not sure how to do this. Some instructions, please? BTW; It's for SQL2000, but I guess the…
-
Detaching database in 2000 > Attaching database in 2005
Hi all, The exercise I am doing is upgrading from Nav 3.70/SQL2000 -> Nav 4.03/SQL2000 -> Nav 5.01/SQL2000. All of this went good. Now I need ti finalize by migrating to SQL2005. Can I simply detach the databse from SQL2000 and attach it to SQL2005, or is there some security settings etc. I need to do? Someone has asked a…
-
SSIS: Codepage Conversion
Hey everybody! Is it possible to convert textdata from Codepage 1252 (Euro Windows Standard) to Codepage 850 (OEM Latin 1, the codepage NAV uses) using Sql Server Integration Services? I tried to import Data from a text flatfile using SSIS into a NAV Database (Yes, I know that there are dataports :wink: ) I tried to…
-
Null not allowed in textfileds on sql server
I have created a table in NAV, an external application is filling data into this SQL table. but the external apllication have problem when inserting records with "Null" values in one of the fields. Does anyone know how to change the field propperty, so the field accept Null values? /roynes
-
Nav 2009 and SQL 2005
We are going to use Nav 2009 and SQL server 2005 for one Project. Here, we have to create number of databses in SQL. and data will be transferring among each other DB's using SQL queries/SQL Properties. Please suggest, how many maximum DB's whould be feasible to create in one sql server.?
-
Sql permission Error
Hi Friends i was trying to connect sql and navision has a client server configuration mode. We have setup the server using sql server 2005 express edition, navision 5. The problem we face is when we try to do a windows authentication we get a property or select permission. Can you please let me know what is the solution…
-
DB on server does not contain Nav system objects
Hello, I want to create a NEW Navision/SQLServer2005 database on an MS SQL Server2005 server. Since this is a Server in Central MIS/IT is has no Navision Client or Navision Application Server etc. installed. Instead I open a Navision/SQLServer Client (finsql.exe) on another machine and then click: File, Database, New Then…
-
Using security filter permission in Reporting Services
Hi. I am not an Nav user nor Nav developer, but a MS BI developer. I don't know Nav very well. One of our clients has Nav and wants to be able to use permission set in Nav for SSRS reports. They use windows logins. The way I want to implement this is by grabbing the username of the user running the report and see if the…
-
Data Export from Nav Sql DB to an external Sql DB??
Hi Guys, I need to export some Tables from NAV to an external SQL DB (I'm using SQL Server 2005) For Example : I want to Export Sales Header and Sales Line for Customer wich are Blocked=False; What's the best way to solve this issue? My Job should be scheduled. Any suggestions Thanks
-
Client Monitor: SQL Status ?
Hello, in my Client Monitor result i have some lines with column SQL Status filled with "Cached". What does this mean? Some "cached" lines have an elapsed time > 15ms. Is there a configuration parameter to optimize this? Perhaps DBMS Cache (actual it is 100.000 KB)! Thanks for Help! Best Regards, Florian
-
Checking a linked table on another server
I have a linked table on another server - it is used for inquiry only on a Navision form. I don't want to cause an error for the user if the other SQL Server is down for any reason. They won't be able to open the linked-table form, but I don't want to crash them out of Navision. Has anyone discovered or created any code to…
-
MS SQL Server 2008 on Windows XP SP3
Hi all, I’m not getting any error message during MS SQL Server 2008 Installation on the Windows XP SP3 system. Though I want to know from you that are it compatible in this OS platform and can this system work as a Server? Thanks with regards.
-
NAV 5.0 SQL server Requirements
Hello We have no knowlegde on NAV but some on SQL server. We intend to use a Microsoft SQL server 2008 standard for storing the NAV 5.0 database. The OS will be Windows server 2008 standard. Which SQL server 2008 components below are required by NAV 5.0 ? SQL Server Database Engine Analysis Services Reporting Services…
-
Move NAV SQL Log File to another drive
Sorry if this is posted, but I couldn't find it. I've got a simple SQL 2005, single file database which includes the .mdf,.ndf and .ldf. I need to move the log file. I've found the following online: Detach the database use master go sp_detach_db 'mydb' go Move the file(s) and Reattach the database use master go…
-
Move SQL Database to new Drive
What is the best way to do this? I have just installed a RAID 10 (8x136GB). It is Logical drive (E:\) is 546GB. Currently Database is on Logical Drive D: \. Servername is PROD. DB name is PROD. I want all this to stay the same so that any DSNs I have developed on other machines don't need to be adjusted. Thanks for your…
-
SQL Error 15151
Hi! I use NAV5.0 with SQL. I created all the users in SQL and was trying to syncronize them with NAV. I received the following error: 15151, "42000", [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the user '$ndo$a$', because it does not exist or you do not have permission. SQL: GRANT SELECT, INSERT, UPDATE,…
-
Problem deleting a linked table
I defined a view which I repeated for each company in my database. Then I defined it as a linked table in NAV 5.0SP1. Now I need to delete the NAV table definition, but it won't let me. I get a SQL server error - invalid object name $ndo$usrproperty. SQL: Select [sid] FROM [$ndo$usrproperty] Do I need to delete the views…