I have linked servers created on both SQL 70 and SQL 2000 server. Why linked server on SQL 70 server often get lost connections?
But linked server on SQL 2000 server work well always.
Is this version 7.0 problem which is unable to be fixed?
RE: 0x80004005 - you need permission to view its data ... When creating the Access linked server, make sure the data source using UNC ... the SQL server(Both SQL authentication and Windows Authentication work). ... 262177 How to enable Kerberos event logging... (microsoft.public.sqlserver.security)
Linked Servers - Real Post ... I am running SQL 2k on Win 2k. ... a front end for our SQL database.... added the linked server I want, and SQL queries it fine, ... leaving the "local server login to remote server login" ... (microsoft.public.sqlserver.programming)
Linked Server - Issue ... I have to access a Linked Server S2 (SQL 2000). ... In S1 I have setup a linked server using sp_addlinkedserver pointing to S2. ... Both MyAccount and SpecialAccount has access permissions to S2. ... Reason Not associated with a Trusted SQL... (microsoft.public.sqlserver.programming)
Re: Connecting to FoxPro data ... Since you want to "mix" the Fox tables with the SQL tables it sounds like ... Note that when you select data from a VFP linked server you need the three ... the data source string in the example is for a FoxPro DBC or "database... (microsoft.public.sqlserver.connect)
