Windows authentication for web portal failes with SQL error

Open discussion about the Alloy Navigator Express 5 Web Portal

Windows authentication for web portal failes with SQL error

Postby gecu on Mon Apr 12, 2010 3:45 am

I have set up a new Windows 2003 server with Alloy Navigator Express, and am configuring the web portal..

I have imported a test user from active directory, and have created it in "tools > administrative > user management". I can see information about the user in "contacts" too.

But when I want to visit the web portal with that user, I get the following event in the event viewer of the windows server:

Code: Select all
Event Type:   Failure Audit
Event Source:   MSSQL$ALLOYNAVIGATOR
Event Category:   (4)
Event ID:   18456
Date:      12/04/2010
Time:      9:07:55
User:      N/A
Computer:   SV-HELPDESK
Description:
Login failed for user 'best\ttest'. [CLIENT: <named pipe>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 1b 00 00 00 53 00 56 00   ....S.V.
0010: 2d 00 48 00 45 00 4c 00   -.H.E.L.
0018: 50 00 44 00 45 00 53 00   P.D.E.S.
0020: 4b 00 5c 00 41 00 4c 00   K.\.A.L.
0028: 4c 00 4f 00 59 00 4e 00   L.O.Y.N.
0030: 41 00 56 00 49 00 47 00   A.V.I.G.
0038: 41 00 54 00 4f 00 52 00   A.T.O.R.
0040: 00 00 07 00 00 00 6d 00   ......m.
0048: 61 00 73 00 74 00 65 00   a.s.t.e.
0050: 72 00 00 00               r...   



Strange because I am running the SQL server in "windows authentication mode" (so says bin\MsSQLMod.exe), i'm not using "impersonating"...

Can anyone help me wiith this?
gecu
Newbie
 
Posts: 1
Joined: Mon Apr 12, 2010 2:53 am

Re: Windows authentication for web portal failes with SQL error

Postby eliaslynch on Wed Apr 14, 2010 12:33 pm

Login failed for user 'best\ttest'. [CLIENT: <named pipe>]


first thing I notice is <named pipe>. I wouldn't expect that.

where is IIS in relation to SQL server? same box? different box?

if different boxes, what happens if you enable impersonation just to test. does it work?
--------
Elias
User avatar
eliaslynch
Senior
 
Posts: 212
Joined: Wed Jul 09, 2008 7:03 pm


Return to Alloy Navigator Express 5 Web Portal Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron