question

shwetha avatar image
shwetha asked

Linked server from sql 2012 to sql 2008 r2 not compatible?

we have a linked server set up from sql 2012 to sql 2008r2 . After 2days the credentials are lost and if i query from sql 2008r2 to sql 2012 and vice versa i get the NTAUTHORITY/anonymous logon. I have to reboot my PC and the creditials will work for another 2days and again the same problem appears. I am wondering is this anything to do with compatibility issue? Linked server from sql 2008r2 to sql 2012 works well but not the other way around. Can somebody please help me on this.
linked server
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

shwetha avatar image shwetha commented ·
Loin's password is not expired.
0 Likes 0 ·

1 Answer

·
bmurali09 avatar image
bmurali09 answered
did you tried to use public ip to connect linked server connection with 'sa' credentials?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

shwetha avatar image shwetha commented ·
It works, but would like to use the windows account credentials instead sa.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.