NAV 4.0 sp3 installation with SQL server 2005 std. Ed. on XP and everything on single computer


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.

  1. 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.

  1. 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? [:(]

  1. 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.

I really hope this is a joke. Why should anyone dig out so many dead horses - the mentioned versions of NAV, SQL and WIN are absolutely outdated, out of lifecycle and out of support for about a decade. I’d say that system is a rotten corpse in a desert …

If you seriously attempt to get this thingy up running, well, on the product CD there’s a w1w1isql.pdf to guide you through installation - good luck …