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