Upgrade to SP3

Hi,

I am doing some upgrade to SP 3 in my test DB.

I have done the following steps.

  1. Create a Navision 4SP2 full backup2, Open Navision 4SP2 SQL Client3, Create a new test database4, Restore the backup5, Uninstall Navision 4SP2 on the pc6, Install Navision 4 SP3 on the pc7, Open Navision 4Sp3 SQL Client8, Open the new test database Message “Do you want to convert the database?”

9, Click Yes, The database is converted to 4 SP3.

  1. Open the navision and change security to ’ Standard’ and untick back ’ a single user’

after click OK then the screen is when blank.

so basically I try to open it again…

there is an error message says:

" The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo. dll is not available on the msNAVTST1 server.

Untill the procedure and libary have been added. It will not be possible to connect to this server from Micro Bus Soil Na wuth window authentication, but you will be able to connect with DB server authentication. "

I have checked my server has xp_ndo_x64.dll and we don’t have any problem with window authentication in SP 2.

I ask my vendor and he said that I should try in different test server. and later on in live …I should ask their reps to do it.

I don’t believe that…

How do I solve this problem? Can anyone help me

Thanks,

Susan

In client CD you should have that extended stored procedure.

You could also properly install the Extended Stored Procedures with this TSQL:

USE master
GO

EXEC dbo.sp_addextendedproc N’xp_ndo_enumusergroups’,
‘C:\Programme\Microsoft SQL Server\NAV\xp_ndo.dll’
GO

GRANT EXECUTE ON “xp_ndo_enumusergroups” TO PUBLIC
GO

EXEC dbo.sp_addextendedproc N’xp_ndo_enumusersids’,
‘C:\Programme\Microsoft SQL Server\NAV\xp_ndo.dll’
GO

GRANT EXECUTE ON “xp_ndo_enumusersids” TO PUBLIC
GO

Change the DLL Path to point to the required xp_ndo.dll (or 64bit equivalent).

so you mean I use xp_ndo_x64.dll instead of xp_ndo.dll

Does this affect anything? currently we also have Navision DB with SP2

USE master
GO

EXEC dbo.sp_addextendedproc N’xp_ndo_enumusergroups’,
'C:\Programme\Microsoft SQL Server\NAV\xp_ndo_x64.dll
GO

GRANT EXECUTE ON “xp_ndo_enumusergroups” TO PUBLIC
GO

EXEC dbo.sp_addextendedproc N’xp_ndo_enumusersids’,
'C:\Programme\Microsoft SQL Server\NAV\xp_ndo_x64.dll
GO

GRANT EXECUTE ON “xp_ndo_enumusersids” TO PUBLIC
GO

Thanks,

Susan

Hello,

I need your opinion on this.

when I run the quiries above

Does this affect anything? currently we also have Navision DB with SP2

I am just not confidence enough

Thanks,

Susan

Hello everyone<

Merry Christmas and Happy New year.

Can anyable to answer my query above?

Thanks,

Susan