Broken linked server

Question

Post reply

Broken linked server

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

You needn't specify any provider string. What security option are you using.

Thank You,

Best Regards,

SQLBuddy

chulheekim Ten Centuries Points: 1278 More actions · Answer 2

I checked the Be made using this security context. and then I typed the login id and password. I think I already mentioned this. Just to make sure, this is to connect from SQL server 2005 to SQL server 2000. Thank you.

chulheekim Ten Centuries Points: 1278 More actions · Answer 3

Somebody suggested to reboot the server. and The linked server is fixed. Unbelievable.

Thank you so much.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

Glad to hear that fixed the problem has been fixed.

Thank you,

Best Regards,

SQLBuddy