Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Authentication Issue?

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2009-08-13 : 10:59:02
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 when I remotely login to server and try to create/save a function, it works fine.

Any Ideas...?

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-13 : 11:17:28
Can you check the SQL Server Error Log?
What is the state of the "Login failed" error?

This may help: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
Go to Top of Page
   

- Advertisement -