linked server error

Question

linked server error

Pyman

SSChampion

Points: 13830
More actions
July 23, 2012 at 4:15 pm

#264464

I have created a linked server successfully between sqlserver 2008 r2 and sage mas90 database and I am able to select data. But if i connect to the database with a different account which is a windows autentication with sys admin permission I am getting the below error. But if I run my query with the user with which i created the linked server connection I am able to select data from mas90 tables.
Error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error.
Need you valuable advise. In this case both the users are windows authentication users and sys admins.
Thanks.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Are you running SSMS as an Administrator? It may be UAC interfering and causing the errors to crop up.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Pyman SSChampion Points: 13830 More actions · Answer 2

SQLRNNR (7/23/2012)
Are you running SSMS as an Administrator? It may be UAC interfering and causing the errors to crop up.

i have disabled uac...but it still wont work.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Pyman SSChampion Points: 13830 More actions · Answer 3

Sapen (7/23/2012)
SQLRNNR (7/23/2012)
Are you running SSMS as an Administrator? It may be UAC interfering and causing the errors to crop up.
i have disabled uac...but it still wont work.

Error:

OLE DB provider "MSDASQL" for linked server "link2mas90" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible".

Msg 7306, Level 16, State 2, Line 1

Cannot open the table "ar_customer" from OLE DB provider "MSDASQL" for linked server "link2mas90".

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

In Feb, a similar post was raised, check the link:

http://www.sqlservercentral.com/Forums/Topic1255325-391-1.aspx

Might be of help.

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

DBA328 Hall of Fame Points: 3952 More actions · Answer 5

Do you have permission to access table on link2mas90?

Pyman SSChampion Points: 13830 More actions · Answer 6

DBA328 (7/24/2012)
Do you have permission to access table on link2mas90?

One of the accounts I am trying to connect to sqlserver is the sysadmin and also a domain admin and I am able to query mas90 data without issues. But that is my account and I want to let the developers make use of the linked server I set up. Since this is a test environment I made developers (group) a sysadmin on the sqlserver and being a member of developers group i tried to query the mas90 through link server and I dont get the data but the error I pasted before. In this case both accounts have sysadmin rights.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams