April 7, 2010 at 2:11 pm
Hey all,
Helping out a developer here and having some issues. He has multiple linked servers setup to talk to his visual fox pro db's, and they only work when setting up the linked server with authentication "be made without using a security context" AND the service account for SQL be set as local system. As soon as I changed to a domain account (which has local admin rights on the server - which houses both this SQL instance the VFP db's), I get this:
The OLE DB provider "VFPOLEDB" for linked server "VFPDATA" reported an error. Access denied.
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "VFPOLEDB" for linked server "VFPDATA". (Microsoft SQL Server, Error: 7399)
As soon as I change the service account back to local system, it works like a champ. The problem here is though, I need to run this instance under this domain account as he has another linked server setup to talk to another SQL instance, which uses the login's current security context.
My alternative is to run it as local system and use a remote login for the SQL linked server, but obviously I'd prefer to run SQL as my service account. Any thoughts to as why I can't talk to the local VFP db using a service account for SQL?
Thanks
April 7, 2010 at 2:17 pm
Actually, disregard, found a post on how to fix this.
Simply added the service account to the MSDAINITIALIZE security properties: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a525b569-77ca-41da-96e1-2ba1938dd32d
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply