RE: Cannot connect via Linked Server

From: Frank Jones (frank_at_bogusfiosincfake.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 09:51:03 -0700

Yuan, we have tried creating a SQL Server without using the OLEDB provider and this failed in the same manner as the prior failures. Both the openquery and the four part fully qualified name queries failed with Error #17, SQL Server does not exist or access denied.

The MDAC is 2.7SP1 on Server1, 2.8 on Server2...

Any help at this point would be greatly appreciated...

Thanks,
Frank
     
     ----- "Yuan Shao" wrote: -----
     
     Hi Frank,
     
     This issue is very strange. Please try the following steps to see if they
     are helpful.
     1. Try to create a new linked server using SQL Server directly but not OLE
     DB provider for SQL Server. In the meantime, please specify a SQL account
     in the general tab to connect to Server2\instance2 server. After creating
     this linked server, please try to perform the following sql statements. It
     is best to grant the admin permission of server2\instance2 to this test SQL
     account.
     
     Select * from OPENQUERY(<Linked Server Name>, 'SQL statements')
     
     Select * from <Linked server Name>¡­<Table Name>
     
     Does the same error message "SQL Server does not exist or access denied"
     still persist? Is there any other error message occurring? It is
     appreciated you can provide the completely error message.
     
     2. Please use MDAC checker on your Server1 and provide the result.
     HOW TO: Check for MDAC Version
     http://support.microsoft.com/default.aspx?scid=kb;EN-US;301202
     
     I am looking forward to hearing from you soon.
     Regards,
     
     Michael Shao
     Microsoft Online Partner Support
     Get Secure! - www.microsoft.com/security
     This posting is provided "as is" with no warranties and confers no rights.
     
     

Relevant Pages

  • RE: Login failed for user NT AUTHORITYLOCAL SERVICE.
    ... The error message did indicate that the login user doesn't have sufficient ... permission access the target database, and since you mentioned the error ... so thats SQL Server Engine I think? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Event 1000 Windows SharePoint Services 2.0 Error
    ... First off what exact error message do you get? ... I've not seen Exchange pop connector get mangled by removing SQL so lets debug that separately. ... I had all SQL server instances to a complete stop. ... And this morning when I came to work, I discovered that when I try to access http://companyweb/, I receive the "Cannot connect to the configuration database." ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)