[NAV 5.0 SP1] xp_ndo_enumusergroup missing

kizin

Hello,

I'm trying to install Nav 5.0 with Microsoft SQL server option for Microsoft Dynamics NAV
- Windows Server 2008 (32bits)
- SQL Server 2005 (32bits)

I want to activate Windows Authentification. When I create the database in the Microsoft SQL server option tool, a message shows that xp_ndo_enumusergroup is missing

I have copied xp_ndo.dll found in the Sql_esp/xp_ndo.zip folder in the installation CD.
But only the xp_ndo_enumusersids stored procedure could be found in the extended stored procedures of the master table. :-k

Anybody knows where i could find it?

Regards,

ara3n

change the security model to Standard. Login as SA, and File->database->alter->advance tab->security model to standard.

ara3n

If you really want to be on enhance security model run the following script on sql sms

please change C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo.dll to where the actual dll is.

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

kizin

Thanks for your answers.

Maybe, i'm not clear in my explanations.

In fact the problem is to create the database in using the Windows Authentification.

I've already copied the "xp_ndo.dll" file in the Binn folder of SQL Server but only 1 extended stored procedure appears : xp_ndo_enumusersid.

When I attempted to create a new database, the systems asks me to Grant Exec rigths to xp_ndo_enumusergroup, but this extended stored procedure does not appears.

Regards

Slawek_Guzek

kizin,

The stored procedures do not 'appear' automagically. You have to create them manually, either by using graphical facilites of SQL Server Management Studio, or by executing two simple queries from ara3n post.

In fact you need to have two stored procedures: xp_ndo_enumusergroups and xp_ndo_enumusersids. You need to create them both manually.

1. Copy xp_ndo.dll to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\' path.

(If your directory structure is non-standard and you dont have 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\' directory copy the file to 'MSSQL\Binn\ subdirectory of the directory where you (or someone) have installed MS SQL Server.)

2. Open your SQL Server Management Studio, connect to your server, create new T-SQL query and copy this code:

USE [master]
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusergroups', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE ON [dbo].[xp_ndo_enumusergroups] TO [public]
GO
EXEC dbo.sp_addextendedproc N'xp_ndo_enumusersids', 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll'
GO
GRANT EXECUTE ON [dbo].xp_ndo_enumusersids] TO [public]
GO

3. Execute the query using F5. Before executing it remember to change C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ path to whatever place to which you've copied xp_ndo.dll file

If you run 64bit SQL you need xp_ndo_x64.dll file, but the whole procedure is the same.

You need to have some admin rights on the SQL to run above T-SQL code.

After completing above you may try to create your database, but still your windows account needs to have enough priviledes on SQL box.

Regards,
Slawek

kriki

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

kizin

Thanks for this clear explanation.

regards

paddypower

Thank you for this Slawek!!

You are a star =D> and you understand that not all the users in the real world are all techies!!!

Thanks


Paddy Power