Error login MS SQL Option with MBS 3.70

Bernat_Real
Bernat_Real Member Posts: 10
edited 2007-04-11 in SQL General
Hi, a have some problems to login on a MS SQL server option for MBS 3.70. I have various server running this option and I only have problems with one.
At this one when I try to login MBS Client shows this message:

"User\Password Incorrect, try with another user\password."

Analizing the process with SQL Analizer I observe that the diference from another server in wich, same process is succesful is that this instruction return this error:
/*
EXEC [master]..[xp_ndo_enumusersids]
*/
Mensaje 50500, Nivel 1, Estado 50500
Internal error : a Win32 function returned error code 1008 (0x3f0)

But in another server the same command returns a list with: user,sid and name of the valid users in SQL and MBS Option DB...

On both servers run Microsoft SQL Server 2000 - 8.00.760 (Intel X86) (Enterprise SP3), both have same Regional Options, same code page, the used dll (xp_ndo) are the same and users have same level access.

Anybody knows where is the problema ?

Comments

  • RobertMo
    RobertMo Member Posts: 484
    Does xp_ndo_enumusersids have public EXEC permissions?
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Bernat_Real
    Bernat_Real Member Posts: 10
    If you see the "Installation&System Management: Microsoft Business Solutions Navision SQL Server Option" manual at page 3 It explains that tihs option don't work with NT Fibers actived on SQL server...
    :cry:
  • kriki
    kriki Member, Moderator Posts: 9,127
    [Topic moved from Navision e-Commerce forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories