-
Difference between SQL 2005 and SQL 2005 express
Hello, We have a solution to transfer data between Navision and Microsoft SQL. Until now we have worked with SQL 2005 and the transfer works very well. Now we want to transfer data between Navision and SQL 2005 express. We thought the used commands work with both SQL versions. Unfortunately this is not the case. The…
-
Incompatibilty SQL Server 2005 with Navision 37B
Dear World, I tried to transfer Navision 37b database from SQL 2000 to SQL 2005. All user account on SQL 2005 has been created (with public serverroles, as like as on SQL 2000). After Restore & Syncronize from Navision 37B Client, I can only login with 'sa' account, all other user account login failed with message (as on…
-
SQL Log File
Dear All, I have a problem with some of my client tha the back up will take longer time., My Database is in SQL server 2005. with the first view I analyse that Log is taking so much of space. Waiting for your reply.
-
error during the renaming of the company
Hi, Need help to rename company I work with Navision 3.7 and SQL2000 I need to rename a company, only that the error below is informed while continuing. The error appears when they click on rename. Is there another way? :cry:
-
Accessing tables created out of Navision.
Is there any way to access tables created outside Nav? When I create tables using SQL management studio or something else I don't see them in Nav. Any information please!!!
-
Datawarehouse with multi-sites dimension
Hi all, I have a fact table which contain SITE dimension. All the other dimension tables contain each SITE field. How to create a cube for viewing all data relatively for each site ? I want that all dimensions depends for site dimension. Thank you in advance.
-
how to insert table data using dotNet and sql server
Hi Any one knows how insert data in sql server through navision database tables using aspdotNet.
-
Problem with linked table
Dynamics NAV 5sp1. I have one table in Dynamics NAV linked with a view in SQL server. I have a form that shows information of that table. But when i export to excel (from the buttom or "copy and paste") the registers that shows the form in Dynamics NAV, i don´t get all the registers in Excel. Any solution?
-
Using one No. Series table in multiple companies
Hi all, I have a requirement to get 2 companies in one database to share the No. Series. I have asked our supplier and they suggested to change the DataPerCompany field on the No. series but could you please help me with how I can call from just one table? Many thanks for your help. Regards, Mike
-
SQL Server 2000 SP4 will support NAV-3.7
Hi, Our client is using Sql Server 2000, with Navision 3.7. Is SQL SERVER2000-SP4 will support Navision 3.7.? Kindly give your experience on the same. Thanx in Advance.
-
SQL guidelines
Hi, is there any docoment regarding how SQL server 2005 should be setup for navision 5.0 SP1 (do and don't)? Also, how are common problems solved like file growth, partitioning data, fill factor etc. Any links will be usefull. Currently we have a table of 15 milion records and is growing (database growth 22GB in 8 months).…
-
SQL Password
Is there a way to prompt a user that his/her SQL password is about to expire from inside Navision?
-
SQL getdate -> Navision date/time
Hello, i need to fill a Navision Date- and Time-Field via SQL. (No, i don't need a datetime-field in Navision) I use "getdate()" to retrieve the datetime of the SQL server, but i don't know how to convert it to a navision Date- or Time-Field. Looks for me like a common problem, if you want to insert Data via SQL in…
-
About SQL server for Navision 2009
Hi friends I have installed the SQL client system with the help of Nav5 and there are 3 to 4 users who work on nav 2009 , but they are not able to connect to this system neither by windows or sql authenctication . how to resolve this setting
-
Combination of user id password
Hi friends If i use a windows id for authentication in sql mode navision i always get a combination of user id and password error . is there any solution or method to solve it.
-
Security issue after change of table
Hi all, We run Nav5.0 sp 1 on SQL with windows users. As soon as we change a table (adding field,...) we see that users lose the access to the table. I need to resync the user's security whick of course forces the users to logoff and on. As we have 15 companies in 4 database with 100+ users, this takes a lot of time. We…
-
Log shipping vs shrinking Log Files
I have a customer who uses log shipping. He shrinked the transaction log of a database. Is the log shipping still working after a file-shrink for the log files and if not, what is the eaiest way to re-enable the log shipping? Thanks for the help, Regards, Timothy Yzermans
-
get amount in the date range
Hi there, I create a report which display local amount with in date range..like current,31-60, 61-90,91-120,120+,my report have parameter,@startdate and @enddate..... so my 1st query like this SELECT gle.[G_L Account No_], ( SELECT SUM(gle.Amount ) WHERE (gle.[Posting Date] BETWEEN gle.[Posting Date] AND…
-
Cleaning up transaction Log Backups
Hello, Our Navision database is hosted on a SQL Server 2005. The recovery model is set to full. A maintenance plan performs a full daily database backup at night. During the day there are multiple transaction log backups scheduled. The full database backups are kept 14 days. Today I noticed that the transaction log backups…
-
Error: odbc sql server driver: cannot generate sspi context
Has anyone seen this error before when connecting via Windows Authentication to SQL Server 2K5 Express? The security model is Standard, though at one time it was Enhanced. To make matters even more bewildering, the user claims that it is possible to login to NAV if you first login to the box with terminal services with…
-
SQL Server Error
Hi Everybody, I was running a process onto Navision, and got an error message due to lack of memory. As soon as I re-opened Navision the following error cropped out: Cannot open user default database. Login Failed. As a result of this error I couldn't open the Navision Database. Does anyone have any idea the reason behind…
-
Changing the AD domain on SQL Server 2005
Hello, We are planning to migrate our network to a new active directory domain. We are running Dynamics NAV 5.0 with windows authentication on a SQL 2005 server. Can anyone tell me what the best practices are when performing such a operation and what I have to keep in mind when changing to domain? Thanks in advance! Best…
-
Errors HY024 and 945
I'm posting the following as a POSSIBLE solution to an issue I had. I will let the experts pick this apart. If I'm way off I apologize...I just wanted to share this in case it is valid and potentially help others. Recently I tried to access a development database from my NAV File dropdown of recently accessed databases. I…
-
dbo owner needed for tables with DataPerCompany=NO ?
We are using NAV 5.0 SP1 on SQL 2005. I want to insert a record in a system table (2000000068) which has the property DataPerCompany=NO. I also have the same issue with a custom table. It seems that I need the DB Owner right on SQL 2005 to do this? Of course I don't want users to have this right. How can this be resolved?
-
help syntax problem
Hi there, In navision table Detailed Vendor Ledg. Entry field name:Doc type-option, In properties: Option string:,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund when i select doc type using sql like this: select doc type from Detailed Vendor Ledg. Entry it will display result: doc type 1 2 3 has anybody…
-
Transaction Log
Hello Maybe a stupid question :? , but anyway: How can I make sure the transaction log does not grow too much? Background: We have a navision db, SQL Server 2005, log type=full, the db and the log are backed up daily by a maintenance plan. In Mgt-Studio 2005, "DB Properties", "General", "Backup ,"Last Log File Backup" it…
-
SQL reporting Services new table fields added
Hi there. I have created a bunch of reports in SQL reporting services and they all work fine. Now I added a new field to a Navision table and I need to filter on that field on my query. when I go to the query designer and look for that field on that table It is not there. Now it makes sense that I have to refresh somthing…
-
SQL Server connection
Hi guy can u actually tell me how to hold a SQL server for many user from different network system to access the database and to work on some database alone. Cirteria:- sql server with 15 connecting system to it and the sql server must have 3 database one can be accessed by all the user and the others can be accessed by…
-
STATE ID : YH000 Cannot Generate SSPI context
Hi everyone, i need your help. I migrate a Navision SP1 SQL2000 to Sp3 SQL2005. The only problem i have is that i want to connect with windows authentication login and i get the following error ....."Cannot Generate SSPI context..... STATE ID : YH000". I have made a synchronization and i got no errors. I also want to tell…
-
No company in NAV 5.0 sp1
Hi, I have just created database on NAV sql client. When I open a company in NAV I cannot see anything, but on SQL server I can see all the tables and companies. I'm running windows vista business, nav 5.0sp1 and sql express 2005. I cannot see what could be wrong. :(