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
0
Comments
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,
...
Everybody on-line.
...
Looking good!
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).
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,
...
Everybody on-line.
...
Looking good!