Navision login using windows authentication

wash64864 · 2007-12-14

I have a 40 database installed on SQL 2000. I have install the nessecary dlls (xp_ndo) and added the windows user to the SQL database and to Navison.

When I try to logon or syncronize the windows users I get the error
"A 'S' is expected here."

Has anyone encounter this problem before and how can I fix this?

Thanks for any help.

kine · 2007-12-15

1) Are you able to catch the error by debugger?
2) Try to run SQL Profiler and catch the commands which NAV sends to SQL.

gaspode · 2007-12-16

Yes - I've had this before.

It was something to do with an invalid record in the Windows Login table that had a blank row. It is expecting something that starts with an 'S' hence the message.

wash64864 · 2007-12-17

Yes I have tried to catch the error using the debug, but I never get a stop on the error. I assume this is happening at the executable level. I will try the SQL profiler, but if it is a lank record in the table then I will try and find the record an delete it.

gaspode · 2007-12-17

Seriously, I have had this before.

It was either a problem in the Windows Login table (note how the SID is a long string that starts with the letter S.

or it was in the Windows Access Control table where the Login SID is also expecting a letter S at the begining.

I had a rogue record in one of these tables (I really can't remember which) and I deleted it and the problem went away.

wash64864 · 2007-12-17

Thanks for the help. I found the problem. You were correct. There was a blank record in my Windows Access Control table. Deleting the reocrd solved the issue.

kriki · 2008-06-05

[Topic moved from Navision forum to SQL General forum]

Navision login using windows authentication

Comments

Categories