-
SQL syntax problem
Hi there,In Navision, they have global dimension 1 code which table related to dimension value.code with condition global dimension = 1 and global dimension 2 code which table related to dimension value.code with condition global dimension = 2 I want to create report with query Select posting date, global dimension 1 as…
-
SQL Security synchronize.
Our Customer got 44 Companies in Navision, which means on SQL approximately 951 Tables (+SIFT tables etc) * 44 = 41844 Database tables in SQL. 18 Windowslogins and 4 Active Directory Groups. Multiplying 41844 Table with each login * 22 = 920568. So I think it has to synchronize somewhat 920568 tables/times in total. This…
-
SQL Views and Permissions issue
Hi! Basically we have created a Table in Navision which is linked to a SQL View. The SQL/Nav User has permissions to access the table data of this view. The user is set only as guest and we cannot set the user as db_owner. When we run the table inside Navision no data is loaded into it. However if we log on to SQL…
-
[NAV 5.0 SP1] xp_ndo_enumusergroup missing
Hello, I'm trying to install Nav 5.0 with Microsoft SQL server option for Microsoft Dynamics NAV - Windows Server 2008 (32bits) - SQL Server 2005 (32bits) I want to activate Windows Authentification. When I create the database in the Microsoft SQL server option tool, a message shows that xp_ndo_enumusergroup is missing I…
-
log file is full
Hi, Urgent! Our log file is full and we canot access the Navision. Help!!!
-
Case sensitive user IDs in SQL
I have an occasional issue that I am having problems diagnosing. Basically I have cases where I create a SQL backup from a clients server then restore it to my local machine, I can not use DB logins to connect to that database. I am trying to narrow this down, but its not easy. basically it seems that I only get the issue…
-
SQL Stored Procedure Creation
Hello I tried following codeCREATE PROCEDURE dbo.proc_MyStoredProcedure @CompanyNameAS SELECT * FROM dbo.[@CompnayName$Item] to return all lines of the item table which belong to the company that I want to specify while calling the stored procedure. To my surprise, SQL created a stored procedure without murmuring :D . But…
-
DB user password
Hello! I have SQL 2008 server and 4.0 SP3 Navision database. Currently I’m playing with Database Server Authentication. Actually everything is working fine. Only, when I used semicolon char in password for database user I could not anymore log in to database. Are there some restrictions on SQL passwords or am I something…
-
SQL Server run as a service for both? server+ client pc
Hi there my client want to use sql server 2005, so i refer navision manual,according to the w1w1isql.pdf, 'In the sql server Option by Dynamics NAV, SQL Server is run as a service. The SQL Server Option for Dynamics NAV requires that SQL Server is able to look up Active Directory to get lists of Windows user groups for…
-
Nav 5.0 and SQL Server 2005
Hi, there.. My client want to use Nav 5.1 and SQL Server 2005 and also SS reporting services. I have several ques: :?: 1)If for the server I install this 3 things, need i to install SSRS for the client? 2)If at the server, user can view all the report from the http://localhost/ReportServers, and how the client user want to…
-
SQl Server 2008
Will Microsoft Business Solution Nav 4.03 be compatible with a pc running sql server 2008?
-
Access report using username and password
Hi there, I want to create user name and password for client pc when they want to view/access report at [url=http://]http://[/url]<servername>/Report Have anybody know how to do that? Thank you..
-
Optimization Problem
My clients Database increases too much Day By Day.Database is in SQL.Database size is 19 GB with in 8 months.If I will optimize that DB then wht will happen?What r advantages and Disadvantages of optimization?When I go in File->Database->Information there it shows me size 19 GB.Is it contains size of .mdf,.ndf and.ldf…
-
Numer of procesors for parallel execution
Good Morning, In my company, we have a Dell PE6600 server which has 8 1.6GHZ CPU. I am having a problem on setting number of processors for parallel execution. Please help me with it. We are on NAV 3.60 with NAV 3.70b run time, SQL option & Win 2003, 14GB RAM. Thanks, Coubepu
-
QUESTION: SQL Server Option and data consistency
Hello! This is just a question about theory, I don't have any specific problem (I'm just studying for an exam and I had a doubt, so moderators could even move this question to the certification Forum). In one of the preparation volumes (sorry if I quote): This says that if user A runs a report, let's say "Trial Balance",…
-
User Synchronization Error
Hi all, I have an issue when I try ti synchronize the user Windows Login. The message is 'The Microsoft Solution-Navision and SQL server security system have not been synchronized successfully. 'The database user MAFS does not exist in the NAV database.' I have tried to remove from NAV Windows Login and SQL. And syn again.…
-
Compare SQL and Native network requirements?
I have always found NAV being very demanding regarding low latency for the network connection. We usually uses the NETTEST results (the Performance table) to compare the network capability of different sites. We have ended up recommending Citrix for sites not capable of delivering at least 3000 packets of 100bytes a second…
-
User name
I have a Report where a User Table record, find an user and show user name. Now whe have migrated to SQL Server, and any users start with: "Windows Authentication". They are not in Users Navision table... How can i obtein their names with "Windows Aut.". Likely ENVIRON('computername')??
-
Sql Database with linked table (SQL view) Restore errors
NAV 5 sp 1, sql server 2005. I want to restore a sql database with linked table (sql view). I have read this post: http://www.mibuso.com/forum/viewtopic.php?f=23&t=27236&hilit=restore+linked and i create a dummy view, after creating database from NAV. It starts restoring database without problems (without dummy view, it…
-
Database close automatically
I am using Navision SQL 4.0 sp3 database.They r using SQL 2005.Their recovery model selected in SQL is full.When users are accesing Database then their Database shut down automatically after 15 mins. by giving following error: Your connection to the 10.203.10.37 server is no longer responding.This is probably because of…
-
How to Insert txt file into SQL table(DB2)
Hi can anyone help me with a sample code that i can use to insert a txt file into an SQL database table in DB2. Below is the file to be inserted:…
-
LOG Entry
Hi All, Anybody help us to stop the SQL Log entry generation, SQL Log entry become 19GB.
-
Connection failure error
Hi all, we are getting Connection failure error message with following reason. 1. The server has been shutdown, either manually or as a result of an error. 2. Your session has been by administrator. 3. A netowrk failure has occured. 4. A hardware failure has occured on the server computer on your computer. some time we are…
-
Incorrect Logon-type showed in the Session table?
NAV5SP1 with update 1, SQL2005SP2 with update 8 I have a single pc which always seems to login to our database using Windows Authentication. No matter if the user logs in using Windows or Database Authentication. We have tried to restart Windows. Then we tried re-installing NAV. Nothing helped. Other sessions are shown…
-
How I know what 's application connected to dbms ...
Dear Sir.. I have to see in sysprocess and found program name is 2007 Office system ... so I want to know 2007 office systems that connect to SQL Server is what's appliction ... Access , Excel ,Word ... How can I check it
-
Server Missing
i setup 1 server and 1 client. i install sql server 2005 in the server. i also install C/SIDE Client for Microsoft Dynamics NAV 5.0 Complete in server and Minimum in client. i open the microsoft dynamics nav sql server option and when i lookup in the server list i only find one server and that is the name of the client....…
-
NAV 4 SP1 compatible with Windows Server 2008/SQL Server2008
Hi i am considering a migration and would like to know if this is possible for above - any opinions appreciated thanks Ajmal
-
Case-sensitive User-ID :-(
NAV5SP1 with upd. 1 - SQL 2005 SP2 with upd. 8 I have a client using Database Authentication and therefore needs to create users in Server Mgt. Studio before creating them in NAV. But when users login they need to enter their user-id exactly (uppercase/lowercase) as created in Server Mgt. Studio. I guess this is because of…
-
Import users
Hello, We are installed SQL. The problem is... We have more than 500 users in Navision. How can we create SQL users automatically? Any process to do this? Regards
-
Accent problems with Restore - character not valid
Hello, we have this problem: a backup of a database NAV50SP1 on Sql Server2005 made with backup of client NAV (on the server side) cannot be restored on another server Sql Server 2005 on a new database. It seems it can not convert the accented words in record of type code. I attach an example of the message that comes…