-
Problem connecting to SQL
Hi, I'm having a problem to connect to my SQL Server (2005) in a specific computer. I can connect to the SQL DB(using Dynamics NAV client) in my computer, but if try to do that in my partner computer I can't. The same situation with his login (in my computer works fine but not in his). The message we get is that user or…
-
SQL Index what to Use, Rebuid or reorganize index task?
What's the best practice. To make an maintenace plan using Rebuid or Reorganiza index? or none? And will the SIFT table be affected? Thanks
-
Windows Login ID in SQL Server
Hello There, We are using Dynamics NAV 5.0 with SQL Server 2005. We are trying to use MS SQl Reporting Services to pull out some reports, mainly security and permissions related so that we can have those reports published in the Report Portal configured in MOSS 2007. The problem is when I opened the NAV database from SQL…
-
companies missing after SQL restore
I have a client that had a disk failure and had to restore Navision. They had 2 types of backup. navision and SQL. The SQL is approx 70GB (something wrong there I think!) The navision backup only has about 15 2GB files so it does not seem large enough and we assumed it was not a full backup. On restoring the Navision…
-
What do extended store procedures in XP_NDO.DLL do
We have had several clients that have tight controls on their servers and have asked us exactly what the two extended stored procedures (xp_ndo_enumsusergroups and xp_ndo_enumsids) do to the SQL server. All I have been able to find out is that they are needed to use windows authentication with NAV. Can anyone elaborate on…
-
Nav SQL
please tell me the steps to create the Navision database in Sql and steps to create the users in sql
-
SQL Help!!!! (xp_ndo.dll)
Damn it! I've just read the help file with the xp_ndo.dll file and tried to add a query via SQL Server Management Studio, but the first attempt was accepted and I mistakenly put in the 64 bit file instead of the normal one #-o . Now when I try to execute the proper query: USE master EXEC sp_addextendedproc…
-
SQL Server Authentication
Hi I created sql database using windows authentication in Navision. I would like to use the same database with SQL server authentication and want to add the users. What is the process for this. Thanks and Regards ajay
-
License Upload error - HY024
Dear All, I am facing a problem while uploading the clients license file on his SQL server database. The system shows an error "ODBC SQL Server Driver: Database is invalid or cannot be accessed. State ID: HY024." Please help me out over this so that I can resolve this error.
-
Suggestion required
Hi ALL, I have created a New Database.All master data and setups are present in this db. Our Client wants there some old transaction data into this DB. Is there any problem if old transactions(customers outstanding, suppliers outstanding,employees advances pending purchase & sales orders) are present?
-
NAV 5.0 SP1 SIFT Views question
Hi guys, after a first look to the indexed views I've one question about it. SIFT maintenance is enabled for some line-tables like Sales Line Archive or Service Line in the Cronus-DB. Because the Line No. field is part of the SIFT enabled keys there will never ever be a line in the view that summerizes data from the base…
-
Decimal Format in SQL Server
Hi all why in sql i have decimal fields lenght 38 with 20 decimal part? Because if i try to use driver Jet 4.0 SP8 (MS ACCESS ODBC DRIVER) this decimal fields are reads like text and not like decimal! Thx in advance Best Regards Stefano Cominotti
-
There is a method of restore only one table?
I use NAV4 SP3 with SQL2005 64bits ,with a mistake of manipulation I drop the totality of records on the table 'Purch. Cr. Memo Line', Please I'am in a big problem because I cant restore my total DB it takes long time(100GB) and this affect the activitie of the company. So I look for a quik solution ,please it's very…
-
Error deleting company in NAV 5.0 SQL 2005
I'm getting an error when I'm trying to delete a company (CRONUS Nederland BV) in NAV 5.0 on a SQL 2005 server. Microsoft Dynamics NAVThe following SQL Server error(s) occurred while accessing the Payment Terms table: 3701,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'CRONUS Nederland…
-
suggestion
Hi, could any expert provide a list of databases besides Navision. Can I have a comparison chart of features on these databases? What database can be customized more on workflow? Very appreciate it!!!
-
Drive configuration for transaction log
I'm looking for people's opinions/feedback on their preferred drive configurations for transaction logs. In these scenarios only 1 databases transaction log is being supported on a given drive set. 1. 2 large physical drives configured as a single RAID 1 array. 2. 4 (or more) smaller physical drives configured as a single…
-
Guest role
I can remember that I've read that it is advised to use the SQL guest role for regular NAV users. Now I read something completely different: "The guest User Account After a user has been authenticated and allowed to log in to an instance of SQL Server, a separate user account must exist in each database the user has to…
-
ODBC SQL Server Driver Timeout, State ID : HYT00
Hi, We are trying to access SQL database using FINSQL from a client machine (LAN connected, no domain). If we logon to Windows of the client using administrator user, then only we are able to properly connect to the database and working fine. But if we logon to windows using a user who is not an administrator, it is…
-
Isolation Level (locking)
What is the default isolation level in Navision and how do you control this in the code? I'm using SQLServer 2000. We are seeing records being locked and I'm not sure how to overcome this. Thanks.
-
sql user
How can I stop the sql user to create a table in Navision, or insert/modify/delete table data??????????
-
Trace flag 4616 Error
Frens i m getting a error which says " The Trace flag 4616 is not set on the server DT363. You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV". I have 5.0 Executables and when i m trying to create new DB through SQL option it Says so.
-
SQL Server 2000 DLL problem (SQLSORT.DLL)
We are Navision 4.0 SP2 and SQL Server 2000 with service pack 4. At times we face problem of sqlsort.dll file missing. Is there any solution for fixing above problem.
-
Error 701, "42000", [Microsoft]{ODBC SQL Driver][S
Not enough system memory available to execute this query. I want to copy one company to 40 the same companies in one database (for educational use). First I backup company 1. Then I rename company 1 to company 2. I restore the backup of company 1. I rename (the new) company 1 to company 3. And so on till I have 5…
-
Can't restore backup on SQL server
Im from india. Trying to restore the russian navision backup (came with CD) on SQL server but im failed with given below error. Microsoft Business Solutions-NavisionThe Payment Terms table contains a value in a Code field that cannot be used with Microsoft Business Solutions-Navision: Field: Code Value: ìÅ main thing is…
-
Crazy table size after modifiying an index
Here is the store, if I modify the SQLIndex option in NAV by choosing more selective fields and compile the table then the table size is increasing enormously. I have the same problem with a table optimize from NAV. The index size usage is going from +/- 200MB to +/- 18GB for a small table. The number of rows and data size…
-
Difference SQL 2000 - Native: roles, db size
Hi two questions for Native to SQL 3.7: - Database size in SQL is roughly 2/3 (29 GB) compared to Native (45 GB). What would explain this difference? - Security Roles linked to a company seem more strict in SQL Example: Item Card, in Native database Access was granted based on company specific and a few global Role…
-
Running Fixed Assets Depreciation
My tempdb of Sql server get full while running the Fixed assets depreciation batch job....what should i do for that....
-
Synchronize NAV -- SQL
Hi, In an earlier post I have asked some questions about SQL-scripting to add users, rights and roles to SQL 2005 and NAV 5.0 (in an educational setting). I still have one question. Maybe you can help me again? When I perform some actions in NAV I have to synchronize in NAV [Tools-Security-Synchronize All Logins] to SQL…
-
Connect Navision with SQL 2005
Hi all, Please I need someone to help me out urgently. I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort. When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath…
-
Connect Navision with SQL 2005
Hi all, Please I need someone to help me out urgently. I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort. When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath…