Problems loggin in after N4.0 SP2 update on SQL ?!

westerwester Member Posts: 33
Hi there

I've implemented a Navision 4.02 environment on SQL. I also installed the SP2 update preventing the 2 cm right margin to show up. This works on Native, but running SQL I cannot log into Navision anymore. It simply says, that username or password is incorrect?! Even user SA is rejected!

I've checked almost everything (I guess), and when I return the original files to the client it works again.

Have anyone experienced that? Any ideas how to solve that?

Thanks, in advance


/Wester

Comments

  • GoMaDGoMaD Member Posts: 313
    The first thing you can try is to open the SQL Enterprise Manager (SQL Server Management Studio for SQL 2005) and then make sure that the
    databaseuser accounts of you native database are created in the Security
    part of the SQL EM. Also check that they have access rights to the SQL navision DB. If thus not help, make one of your users inside the SQL EM a member of the group sysadmin.

    After that this user can access the db with the client.

    Hope this helps,

    Regards,
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • westerwester Member Posts: 33
    Hi there

    I've checked that out. All users have "God" rights (access to everything).
    Even SA can't login...

    I haven't changed anything on the SQL Server 2000. The files in the update package has just been overwritten on the client PCs, and then SQL Server rejects the user (wrong username or password).
  • GoMaDGoMaD Member Posts: 313
    Can you check if your sql server is working in mixed mode or not.

    Mixed mode meaning that Windows Authenticatio and Database authentication are allowed. If this isn't the case only windows authentication is allowed and the SA account won't work.
    You can find this in the properties of the sql server instance itself.

    Can you also check if the users have access rights to the database itself.

    Did you add the xp_ndo.dll to the binn directory of you sql serer and did you add the extended stored procedures in the master database (xp_ndo_enumusergroups and xp_ndo_enumuserids)?

    Regards,
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
Sign In or Register to comment.