Error with view going across two servers

[erics]

Hi there,
I have a view that combines data on two different servers. In the past this has worked fine, but yesterday we upgraded one of those servers from SQL Server 2005 to 2012. Because of this we had to reinstall the C10_Cm DB.
Now, I'm running into errors with this view and only the cross DB views.
Anyone run into this before?

Eric

[bus_pass_man]

What's the error?

Does it happen only in FM or if you test the view in what ever db that hosts it?

When you say 'view' do you mean a view ( i.e. an object which exists in a data base) or a model query subject?

[Kiran P]

If you are talking about db view then  check to see if linked servers are enabled...


Sent from my iPhone using Tapatalk

[erics]

So, the issue was occurring in a view on the DB.
I solved it by making sure that my user had permissions the linked server.