-
How To Create User
COULD YOU PLS HELP ME IN CREATING A USER. i AM USING SQL SERVER AND NAVISION 4.0 I HAVE CREATED USER THROUGH TOOLS- SECURITY- DATABASE LOGIN- I HAVE CREATED USER AND ROLES. BUT I COULDNT FIND ANY OPTION TO SETUP THE PASSWORD. I WOULD APPRECIATE IF ANYONE COULD HELP ME OUT IN THIS. THANKS IN ANTICIPATION KASH
-
NAV 4.03 on SQL Express
Hi, Anyone tried to use navision 4.03 using SQL Express? Any problem using it with nav? Thanks!
-
Navision login using windows authentication
I have a 40 database installed on SQL 2000. I have install the nessecary dlls (xp_ndo) and added the windows user to the SQL database and to Navison. When I try to logon or syncronize the windows users I get the error "A 'S' is expected here." Has anyone encounter this problem before and how can I fix this? Thanks for any…
-
MBS NAV 4.2 (SQL 2005) - SQL server connections problems
Some clients cannot more access to the server after a net fault. When opening the client ->File - Database and login, this message appears: "Impossibile to find Server 'servername'". Every setting is correct. I have restarted the server, router and switches, clients and also reinstalled the Nav client without success.…
-
Update Certain Navision tables from SQL directly
I've seen many topics on updating SQL tables directly from sql from other sources. It is always suggested to create staging tables, which make sense creating orders, posting journals. Etc. It would take way too much time to replicate the business logic, and you can have inconsistent GL transactions. There is also this…
-
Migration from 4.0 to 5 client fails
We have a Database (SQL on 2005 server) with >120 Companies. Migration to 5.0 SP1 client fails after several hours with SQL Error stating that there is not enough system memory. Is there a way to perform the migraton process on sql-server only? Does anyone have a tsql script, so i can split the process into several…
-
SQL database connection help
I am writing a code to link SQL tables, could anyone tell me the format like 'Provider=Microsoftxxxx;Data Source=xxx'; ? Or anything else I have to look after. Thank you !
-
Optionsting and SQL
Hi everyone, I searched the forum for this topic but I didn't find a proper solution. I want to create a select statement for example on the table purchase header which delivers all fields. But in case of Navision option values I only receive the corresponding integer values. Can anyone tell me how option values are…
-
Limit user to log into SQL using NAV client only
How can I stop users to log to NAV database using SQL connection with third party applications? My client has users that are very good in using SQL, and they often bypass NAV and access SQL database using “enterprise manager” or some other reporting tool. They use their regular user names to access SQL database. How can I…
-
SQL Permission - Can not import objects
Hi All, I have a user thats trying to import two modified objects - Vendor Table and Vendor Card Form - to their SQL 4.0 DB. This user has SUPER role & using windows login - but, gets the following permission issue/error when trying to import fob file: "The following error message occured while accessing the Vendor Table.…
-
BASETABLENAME, adVarWChar
Hello. I want to select the value of the BASETABLENAME-Property of an SQL-Record-Field. // autRS.Fields.Item(x).Properties.Item("BASETABLENAME").Value This should give me the name of the attached SQL-Table. The problem is, that Navision-CSIDE does not (yet?) support the type of this property: 202: adVarWChar. :-k Can you…
-
SQL user problem
I have created new sql databse(.mdf) in navision by restoring the .fdb database,that contains the userID "SUPER" and PASSWORD IS blank,the .mdf database has sucssessfully restored,then I have closed that database(.mdf) when i again OPENING THAT DATABASE BY USING USEDID SSUPER AND PASSWORD BLANK,THEN IT GIVES ME THE ERROR…
-
Unique names
Hello all, My client some time ago has moved from native database to sql one (version NAV3.7 - SQL 2000). Now when I want to import new addon functionality I receive following error message: Column names in each view or function must be unique. Column name "Allow Posting From" in view or function 'User Setup' is secified…
-
Permissions to save object with an id < 50000
What SQL Permissions are needet for a user to give him the right so save objects with an id smaller than 50000 ??? This is not an liscense problem, thinks worked perfect when the user super was sysadmin on the sql server. Since i took away this permission the user is not able to save anythink with an id smaller than 50000.…
-
SQL Server 2005 + Dynamics NAV 5.0 User logins
Hi All, Am having problems when trying to add Database users to Dynamics NAV 5.0 Am getting the followinf message when running the syncgronisation from navision : 'The SQL Server login USER1 does not exist on the MYSERVER server.' I have been looking for similar issues for hours with no success. The following link is…
-
SQL Version
Hi All, I know this has nothing to do with NAV but I am have troble identifying which hotfix SQL 2005 is using? The following is the version of SQL 2005 on my machine: SQL Server 9.00.2050.00- SP1 (Enterprise Edition). Now how do i know which hotfix it is using? Does 2050 stand for hotfix? Please help me! [-o< Regards, BKS
-
Table Data delete
I want to delete data from transaction tables through SQL commands.Which command will be more help full, "Trancate" Or "Delete"??? Suggest me
-
Recommendation for Right Memory Settings (AWE, PAE, 3GB)
I am looking for a recommendation or an overview for the memory settings in the OS and SQL-Server in different versions. What do I have to activate in the boot.ini when I have 4 GB or 8GB Memory, when I have Windows-Server 2003 Standard, Enterprise in 32 or 64 bit. What do I have to avtivate in SQL-Server2005. Are there…
-
Security Between Client Server Access
Hi, Just a simple question... What kind of security (encryption/ssl/??) is used when NAV client connects/interchange data with SQL DB Server? Soumya
-
Communication between SQL & Oracle
Hi, Has anybody worked on communication between Navision SQL Server & Oracle database? Does Linked server work with SQL & Oracle to transfer data from SQL to Oracle? Can two databases talk with linked server if they stand at the same location. I have gone through two options in documents - Linked Server & Biztalk Server…
-
Error when using ADO withing NAV
When running a stored procedure in NAV, I'm getting the following error: The funny thing is, when I go in and make any change to the object, and then try to rerun, the error goes away. It seems like this might be a problem with a variable not being cleared - but I'm not sure which one -- I clear the codeunit before running…
-
SQL 2005 on 64bits died....no more odbc connections
GOt this at a customer: no more connection possible, reboot necessary of sql server..... Got into errorlogs : Lazywriter: warning no free buffers found Got onto internet: http://forums.microsoft.com/MSDN/ShowPo ... 8&SiteID=1 So server is 64bit with 64bit sql with 4gb internal mem. No awe used.... If i understand correctly…
-
Advantage of Enterprise Edition? (Compared to Std. Edition)
I have seen the edition comparison from Microsoft (http://www.microsoft.com/sql/prodinfo/f ... tures.mspx) but I have heard a few more NAV related differences. Can anyone please confirm these differences: * Ability to rebuild indexes and statistics without locking. (Guess this is the "Online Indexing" section) * Better…
-
Navision 2.6 FDB db to SQL 2000
hi guys, I am now trying to update my Navision 2.6 FDB db to SQL 2000. I need to know the complete procedure to import from FDB to SQL in details. plz. help. regards, Shata
-
Columns missing (or not shown) in some NAV Tables in SQL
When I opened NAV Tables through SQL Management Studio I can see that some columns are missing or not shown. For example the 'Table Name' column of Table 405 - Change Log Entry. There are columns missing in other tables such as Windows Login, Windows Access Control etc. These are the one I noticed. Can anyone help me to…
-
NAV5SP1 ready for SQL2008?
This links say it is ready: https://mbs.microsoft.com/partnersource ... _nav50.htm This link say it is expected to be ready 3 months after it's release: https://mbs.microsoft.com/partnersource ... er2008.htm Anyone who knows the truth?
-
Navision and Database mirroring
Does anybody know where i can find white papers or other documentation on Navision and Database mirroring. I'm trying to find out how Automatic failover using a witness server works with the Navision Client. Thanks in advance. Mark
-
Optimization level
Hello, is it possible to see in a sql database the optimization level of the tables like in a C/Side database? :?: Thanks for your help in advance! Kind Regards Alex
-
SQL 2005 Database Mirroring
Is anyone running Database Mirroring in production? We have a client that wants to implement it and I am just trying to find if there are any known issues. I ask this to Microsoft and their basic response was "try it, let us know if it works". Which modes did you test and which one did you decide to use? What was the…
-
Couple of questions concerning SQL 2005 server setup
We do a lot of sql installs, and always have some discussions on some settings when installing a sql server, so why not throw it into this group and see what the opinions are: 1) collation sequence of sql server: Needs to be Case Sensetive and accent sensetive, otherwise possible problems with tempdb? (collating sequence…