Tuesday, 15 May 2012

sql server 2005 - Trying to read VIEWS in SQL but getting error -



sql server 2005 - Trying to read VIEWS in SQL but getting error -

instance version 9.0.3042

instance on white circle instead of green, should not concern.

i have total access database, don't understand why able read couple of views not other views. right click on view , select top 1000 rows.

the error getting is:

( msg 18456, level 14, state 1, line 1 login failed user 'nt authority\anonymous logon'. )

i found out problem reason not able connect because of linked server, connects different linked server , don't have access to. other question how identify linked server connects to?

any possible explanation.

sql sql-server-2005 sql-view

No comments:

Post a Comment