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

wester

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

GoMaD

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,

wester

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).

GoMaD

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,