Creating a function in SQL 2005

[lalitha1]

We migrated to from SQL Server 2000 to SQL Server 2005. 2005 has been configured in mixed mode authentication.

When I try to create/save a function from my client (local) machine I get the following error: "Login failed for User xxx". I should mention that within the function, there is reference to a Linked Server.

When I remotely login to server and try to create/save a function, it works fine.

Any Ideas...?

 

[mrdenny]

Change the linked server from using pass though authentication to using a SQL account on the remote server to connect to it.

You are hitting the NTLM double hop issue.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog