Linked Server Error..

From: Brett (brett@mcpmail.com)
Date: 11/25/02


From: "Brett" <brett@mcpmail.com>
Date: Mon, 25 Nov 2002 10:18:13 -0800


Hello

I am attempting to connect to SQL Server 2000 cluster sp2
with the hotfix from SQL Server 7.0 server sp1 via linked
server. I am able to make the initial connection.
However, when I attempt to view the tables I get an error
message stating.. "Error 2: Access Denied". Under the
Security Tab I am using "Be made using this security
context". I have tried it under the original security
context of my linked server user as well as 'sa'. I get
the same error message.

Thoughts anyone?

Thank you,

Brett Davis MCP



Relevant Pages

  • Re: hack using xp_cmdshell
    ... I'm no security expert, so please forgive if I'm not using the right ... install SQL Server in Windows Only mode and then Switch down to Mixed mode, ... Is the SQL Server instance a default instance? ... > port 65300, which has never been open on my firewall. ...
    (microsoft.public.sqlserver.server)
  • Re: Why is SQL Server account used?
    ... > have a security monitoring application that monitors security across the ... > enterprise (Windows server, Unix servers and mainframes) and uses SQL ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)