HELP: A 'S' was expected here Error

Arhontis
Member Posts: 667
Hi all HELP!!! ](*,) ](*,) ](*,)
I am trying to login with windows auth in sql server 2000 with nav 4.0 sp1 in an existing database and server that a few minutes ago used to work and I get the message "A 'S' was expected here." and returns to the database connection dialog...
Users already connected in the database and server work ok, but if they close the application and open it again, then it doesn't open!
Has anyone seen that before?!?
I am trying to login with windows auth in sql server 2000 with nav 4.0 sp1 in an existing database and server that a few minutes ago used to work and I get the message "A 'S' was expected here." and returns to the database connection dialog...
Users already connected in the database and server work ok, but if they close the application and open it again, then it doesn't open!
Has anyone seen that before?!?
0
Best Answer
-
"A 'S' was expected here."
Hi Arhontis,
I had this error about a year ago. When I remember correctly the cause was a strange entry in Navision:
Go to the Windows Logins and look if there is an entry with no ID (empty).
if the user doesn't exist anymore the ID looks like
"S-1-5-21-1102201369-1425392959-26340124-1008"
now the the first "S" ... is the "S" in your Error Message.
try to delete the empty entry... I say "try" because the the navision - server - service may crash under certain circumstances.
hope this helps6
Answers
-
This lets me think you have in the shortcut something like
NTAUTHENTICATION=S??? as parameter (or another parameter with =S???).
Use "NTAUTHENTICATION=1". This is language independent.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
No, no... No shortcut used... Only the File->Database->Open dialog...
(And when I use a shortcut I always use the NTAuthentication=1)0 -
I have already tested enabling debugger and break on triggers also, but it doesn't go through any code. Not even to reach cu1 yet...
Maybe it is on the domain controler and the authentication, because I can login with database authentication or it is in the extended stored procedures...
I have notified the IT dept to check the domain and the in general if there is an error there...
Any more ideas? I am going crazy...1 -
"A 'S' was expected here."
Hi Arhontis,
I had this error about a year ago. When I remember correctly the cause was a strange entry in Navision:
Go to the Windows Logins and look if there is an entry with no ID (empty).
if the user doesn't exist anymore the ID looks like
"S-1-5-21-1102201369-1425392959-26340124-1008"
now the the first "S" ... is the "S" in your Error Message.
try to delete the empty entry... I say "try" because the the navision - server - service may crash under certain circumstances.
hope this helps6 -
It's ok now...
I opened the Windows access control table with enterprise manager and saw that there was a record with no Login SID. I deleted that record and it worked just great!
Thanks kriki,Waldo for the fast reply and for your effort to help me and especially wakestar who pointed at the right direction...\:D/ =D> =D>
Really thanks guys... I appreciate it...
P.S.
I traveled 50 km through Athens in 30 minutes to come and see in person what was going on... lol2 -
Today we tried to open a 4.01 db with the new 2009R2 Classic Client and it gave back the same error.
Also in this case the problem was records inserted into the windows login.
After adjusted them we were able to open the db.
Thank you for sharing :thumbsup:.~Rik~
It works as expected... More or Less...0 -
This is now a quite older thread but it saved my day!
I had the same problem in NAV 2009 R2 i was editing a user profile asked to synchronize that single logon and got (in portuguese "era esperado um ‘S’") a "'S' was expected error".
I then got into this thread and made a select in the "Windows Access Control" table and discovered that the last line was with an empty SID, I placed the SID of the user that I wanted to have access and "voilá". Thanks Arhontis! PIGS Rule!0 -
I have already tested enabling debugger and break on triggers also, but it doesn't go through any code. Not even to reach cu1 yet...
Maybe it is on the domain controler and the authentication, because I can login with database authentication or it is in the extended stored procedures...
I have notified the IT dept to check the domain and the in general if there is an error there...
Any more ideas? I am going crazy...
Though this post is 19 years old it helped me today in 2025. A big thank you!!!
0 -
It's ok now...
I opened the Windows access control table with enterprise manager and saw that there was a record with no Login SID. I deleted that record and it worked just great!
Thanks kriki,Waldo for the fast reply and for your effort to help me and especially wakestar who pointed at the right direction...\:D/ =D> =D>
Really thanks guys... I appreciate it...
P.S.
I traveled 50 km through Athens in 30 minutes to come and see in person what was going on... lol
Sorry, this is the reply I meant to quote. Thanks again after 19 years!!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions