SharePoint web part database access

[mhiney]

I'm unsure if this properly belongs here, in an ASP .NET forum, or in an IIS or SQL Server forum...

Basically, I have a SharePoint webpart doing some database access. The SharePoint site is on MACHINEA, the DB on MACHINEB. SQL Server is set up for mixed SQL Server/Windows authentication, and the Domain Users group has read access to the relevant tables and execute on the relevant SPs used by the webpart.

When I access the page from IE on MACHINEA it works perfectly fine. When I access it from any other machine, using any user account I care to mention, I get "Logon failed for user '(null)'".

Changing to Windows only authentication does no good at all, and playing with the connect string hasn't gotten me anywhere.

I'm pretty satisfied at this stage that the web site is not passing credentials to the Database server, so the basic question is where do I start to look for a solution?

Any help or pointers would be mucho appreciated, cheers.

 

[mhiney]

Bit more info - it's a double-hop issue.

http://msdn.microsoft.com/library/d...ting_authentication_problems_on_asp_pages.asp

I'll post the solution that worked for me here when I get it working