Reply to Re: SQL Server 2K Linked Access 97 Server not working
Posted by David Kirkman on 03/01/06 01:32
Sorry for the delay in replying, I have not had a chance to follow up
your suggestion until today. The database is on the same machine as the
SQL Server and the System account has rights to the directory.
Nevertheless, I restarted SQL Server with a domain account and I am
now able to access the linked server! I have no idea why this worked.