Hi all, I have a silly problem.
For various reasons I have just installed SQL2005 and Navision 4sp3 on two different Laptops.
The first was Vista Home (don’t ask) I installed SQL first, then Navision, then copied an existing SQL mdf to the local drive, then using SQL management studio I attached to the mdf, then installed the extended procedure, ran Navision, and all worked fine.
Now today I did similar, and Navision can not see SQL. But there are differnces:
1/ OS is XP media edition. Not Vista home.
2/ I installed Navision BEFORE I installed SQL. First time I installed SQL first.
3/ I set SQL to mixed mode security. First time was just Windows logins.
I am 99% certain that everything else was exactly the same, but now if I even try to create a new navision db, it simply can not see the SQL server. I am guessing that this is a security issue, and I would assume I can just ninstall everythign and start again, but I would really like to know for sure what I did wrong.
Any comments at all are appreciated.
Btw it looks like its now impossible to buy XP Pro anymore, that was one damn fast death.