Login failed for user 'NT AUTHORITY\ANONYMOUS LOGO

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

SQL Server Development (2000)

Author

Topic

Plotin
Starting Member

21 Posts

Posted - 2005-12-07 : 12:24:06

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

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-07 : 13:45:36

good old connection strings
http://www.connectionstrings.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources