Linked Server Connection Problem

Question

Linked Server Connection Problem

Viewing 2 posts - 16 through 16 (of 16 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

The issue is around access to the FoxPro share. The SQL Server Service Account needs access to the share. As soon as I run my SQL Server under an account without access to the share then I get an error. When running with an account with access I connect fine.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Gad Friedman Mr or Mrs. 500 Points: 573 More actions · Answer 2

I changed the log on account as you suggested and IT IS WORKING:)

thank you for your help