I have created a linked server. I have created a view to reference data in the linked server:
CREATE View dbo.[zBS2_ACCOUNTS] AS
Select ID, Account
>From BS2.BS2.dbo.[ACCOUNTS]
I can open the view, and I see all the rows. However, it seems to be a
read-only view. I cannot add, remove, or change info in the table. Both are
SQL servers, and the link is using sa for a login, so I don't think it's a
permission issue.
Re: Create Linked server user ... Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server...Target Machine -- The server to be accessed from the above linked server. ... A user account needs no special rights to use a linked server defined on ... (microsoft.public.sqlserver.setup)
Re: Linking AS/400 with SQL ... > I followed your guideline on how to create the linked server,... the Account that SQL Server is running MUST be a user account. ... AS400 ODBC configuration is by user, even though it is a system DSN - ... (microsoft.public.sqlserver.connect)
OLE DB provider MSIDXS reported an error. Access denied. ... I've added a linked server to a development box. ... I ran the same command on my local Sql box. ... OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandPrepare::Prepare ... The development sql instance is running under a local system account.... (microsoft.public.sqlserver.fulltext)
Re: add linked server problem ...read/write/execute access for the login account.... I saw an image of a linked server named "SQLB". ... > query is sys admin account. ... (microsoft.public.sqlserver.odbc)
Re: Create Linked server user ...Target Machine -- The server to be accessed from the above linked server.... A user account needs no special rights to use a linked server defined on the ... (microsoft.public.sqlserver.setup)
