I am a new user of NAV 4.0 sp3 and also in this group. I am sorry if this is a previously answered question or a silly one. I work for my office and trying to set up NAV on XP with SQL option and everything on single computer.
I installed the .Net framework 1.1, 2.0, SQLXML 3, SQL server 2005 Std. Ed. and than installed the Navision Client with minimal installation (with the minimal installtion mode). I created a “test_DB” and successfully logged in using the windows authentication mode. I need advice regarding few things.
- I can’t access the “test_DB” from the other computer of the network (but it works only from the installation pc), nor I can add an user of another computer using the SQL Server Management Studio to login to the SQL server. I can only see the name of my computer there. So how can I allow other users from the office network to connect to the server?
I attached a screenshot.
- I pasted the Navision Demo Database(4-0).mdf file into “…MSSQL.1\MSSQL\Data” folder, attached it from the Management Studio, but when I try to open it from the client, it gives me the following error:
Is this a collation type error and do I need to install the client again using a proper collation? [:(]
- The official Documentation that comes with the installation CD seems so fuzzy to me (I hate it). I searched for online resources for Nav installation with SQL option, but very few relevant results. Is there any reference that describes step by step installation procedure? I am getting tired of the trial and error. [:(]
Thanks in advance.