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 2000 Forums  Transact-SQL (2000)  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGO

Author  Topic  Plotin Starting Member 21 Posts Posted - 2005-12-07 : 12:23:16 Hi I am running the following OpenRowSet statement select Column List from OpenRowSet('SQLOLEDB','Server=ServerName;Database=Databasename;Trusted_Connection=Yes;',TableName) Where Clause and get the following error Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I was able to run this statement fine until I worked with cliconfg and svrnetcn. Enabled protocols in cliconfg are Named Pipes TCP/IP Enabled Protocols in svrnetcn are Named Pipes TCP/IP Any tip is welcomed Thanks Plotin