In Lab 1, Exercise 1, Step 4, configure a SQL DataSource to the Region SmartObject

Under point 25, when I click Test Query, I got an error,

"There was an error executing the query. Please check the syntax of the command and if persent, the types and values of the parameters and ensure they are correct.

The request failed with HTTP status 401: Unauthorized."

All I have done in lab was adding 4 Items under a list in WSS, and created smartObject to access it. Then I open a ASP.NET Form and added SQLDataSource and connect to that SmartObject.

 

---

Regards
Ken Lin, Kam Hung
Founder and VP of Hong Kong .NET User Group(http://HKNetUG.com)
MCP, MCP+I, MCDST, MCSA, MCSE, MCITP
MCSE+I, MCDBA, MCSD, MCAD
Microsoft Community Star(Hong Kong & Taiwan)
Microsoft Most Valuable Professional(.NET since 2003)
MCT2004 - 2008

It sounds like the user credentials aren't being passed to SharePoint.  Does your web app have anonymous turned off, Windows Integrated turned on in IIS and Identity Impersonate=true in whe web.config?

---

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.

I already turn off the Anonymous and enabled Windows Integrated.

---

Regards
Ken Lin, Kam Hung
Founder and VP of Hong Kong .NET User Group(http://HKNetUG.com)
MCP, MCP+I, MCDST, MCSA, MCSE, MCITP
MCSE+I, MCDBA, MCSD, MCAD
Microsoft Community Star(Hong Kong & Taiwan)
Microsoft Most Valuable Professional(.NET since 2003)
MCT2004 - 2008

Is  <identity impersonate="true"/> set in the web.config?

Is the client you are browsing from, the web app, K2 and SharePoint all on different machines?

---

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.

Web Forms application in my computer, K2 Server and Workspaces one one server and WSS in antoher server

---

Regards
Ken Lin, Kam Hung
Founder and VP of Hong Kong .NET User Group(http://HKNetUG.com)
MCP, MCP+I, MCDST, MCSA, MCSE, MCITP
MCSE+I, MCDBA, MCSD, MCAD
Microsoft Community Star(Hong Kong & Taiwan)
Microsoft Most Valuable Professional(.NET since 2003)
MCT2004 - 2008

I think Kerberos may me needed here since the AD credentials have to go from your machine to the K2 Server to the SharePoint server.  In these "double hop" scenarios Kerberos is usually the answer.

 

---

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.

I second Bob's answer.

I checked K2 Server's event log, I was already using Kerberos to access to K2 Server from my Client machine.

 Update: check from the sharepoint server log, found out that the smartobject is trying to get data in SharePoint from K2, and the log showing that K2 is using Anonymous Logon to K2.

---

Regards
Ken Lin, Kam Hung
Founder and VP of Hong Kong .NET User Group(http://HKNetUG.com)
MCP, MCP+I, MCDST, MCSA, MCSE, MCITP
MCSE+I, MCDBA, MCSD, MCAD
Microsoft Community Star(Hong Kong & Taiwan)
Microsoft Most Valuable Professional(.NET since 2003)
MCT2004 - 2008

Which confirms credentials aren't being passed. It sounds like you have Kerberos setup between your web app and K2, which is a good start, but Windows will prohibit those credentials to be passed on to the next hop to SharePoint unless you enabled Kerberos on SharePoint also.  Below is a link to a Microsoft KB article that describes how to enable it in SharePoint.

http://support.microsoft.com/kb/832769

---

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.

Kerberos was already enabled to be using in the WSS. Any other chance? Do I need to do anything in K2 Server?

---

Regards
Ken Lin, Kam Hung
Founder and VP of Hong Kong .NET User Group(http://HKNetUG.com)
MCP, MCP+I, MCDST, MCSA, MCSE, MCITP
MCSE+I, MCDBA, MCSD, MCAD
Microsoft Community Star(Hong Kong & Taiwan)
Microsoft Most Valuable Professional(.NET since 2003)
MCT2004 - 2008

Did you ever resolve this issue?

I am having the same problem!