[SQL Server 2005 Std Ed + Windows 2003 Server] 64bit -NAV5.1

andy76

Hello everyone,

I have a customer having a server with Windows 2003 Server and SQL Server 2005 Standard Edition on which we have to add Navision 5.0 sp1 database [only database and not client].
I want to know if it is fully supported and if there are knowns problems or particular configuration to remember.

I read that there weren't problems with NAS and MSQ in previous versions. I ask you if they are solved.

If we will have to install Nassql we will have anyway install it on another server [probably a virtual machine]. Is that supported?

Thank you very much

Andy

andy76

I also ask you if for 64 bit we need:

- some special release or granule of Navision

- use some special extended stored procedure

Thank you

DenSter

Yep that is supported. Make sure though that you use the 64bit version of the extended stored procedures.

All NAV components are 32bit though, so make sure that NAS is installed either on a 32bit OS or in 32bit mode on a 64bit OS.

andy76

About Extended stored procedures...

On CD 5.0 SP1 I have a folder called Sql_esp in which I have a folder x64 and ia64. Which is the difference?
How are these particular Extended stored procedures applied?

--
About Navision flf license: is there something particular or there isn't any difference?

Thanks

DenSter

x64 is for Intel 64 bit, ia64 is for Itanium 64 bit. I'm guessing you have an intel processor, so use x64. Read the readme.txt that is in the same folder for instructions on how to install the extended stored procedures. Instead of using the xp_ndo.dll, use the one in the x64 folder. For 64 bit system, you must put them in manually, because the code that installs them automatically is hard coded to look for the 32 bit version.

Search mibuso for extended stored procedure, and you will find a script that you can run on SQL Server. Make sure you get the script that matches your version of SQL Server.

andy76

I only do not understand your last phrase

"Search mibuso for extended stored procedure, and you will find a script that you can run on SQL Server. Make sure you get the script that matches your version of SQL Server"

The dll present on the cd is not enough?
Do we need some script / SQL statement / stored procedures to run depending of version of SQL Server?
This one is SQL 2005 Standard Edition. If yes where can I find it please?
I already searched a bit on mibuso forum

Thank you

kriki

[Topic moved from 'NAV/Navision' forum to 'SQL General' forum]

DenSter

The dll and the instructions are enough to put them in manually. The script is to install the ESP's automatically.

On SQL Server, anything you can do by selecting menus and buttons, you can also do with T-SQL code. Someone wrote a short T-SQL script that installs the extended stored procedures for you, and then one of the Mibuso members posted this script. Click here for one

andy76

Reading the file README.txt in Sql_esp folder of CD ROM it only explains how to do for SQL Server 2000 - 64 bit.
We will have to do it on SQL Server 2005. Is that the same?

Can you confirm that it is enough to make this things for SQL 2005 64 bit?

"..
From your server computer, access the Navision
Installation CD-ROM. In the folder $:\SQL_ESP, where the
$ is the CD-ROM drive, click the file xp_ndo.exe.
.."
We do not have to click xp_ndo.exe in this case. Or yes?

When prompted, enter the path to the BINN subfolder of the
SQL Server installation folder. (The unzipped xp_ndo.dll
file must be in this folder on SQL Server.)

This step must be done?


When Navision connects to the server for
the first time, the program adds the extended stored
procedure automatically.

I don't think this happens for 64 bit . Isn't it?
So we should add the extended stored procedure as explained following

If the program detects that the server has already been accessed
by Navision, it does not automatically add the
extended stored procedure: you must add the extended stored
procedure manually.

To manually add the extended stored procedures, follow this procedure:

Using a Microsoft tool such as Enterprise Manager, add the
file to the extended stored procedures already installed on
SQL Server. (The name of the extended stored procedure must
be xp_ndo_enumusergroups and xp_ndo_enumusersids.)

Do we have to create 2 extended stored manually and call one: xp_ndo_enumusergroups and the other xp_ndo_enumusersids ad add to each one the same dll
xp_ndo_x64.dll ?

After the extended stored procedure has been successfully added
to the server, you must grant execute permissions to the "public"
role by following this procedure:
- Open Enterprise Manager.
- Expand the server and expand the databases.
- Expand the master database and the Extended Stored Procedures.
- In the right side panel, right-click xp_ndo_enumusersids and
xp_ndo_enumusergroups and select Properties.
- Select Permissions and grant EXEC rights to "public."

Thank you very much.

kine

Yes, same for SQL 2005...