Interesting fix to SQL connection failure for SPS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

tpmulhern_at_gmail.com
Date: 03/15/05 

Date: 15 Mar 2005 07:42:58 -0800

Just posting a fix that may be helpful to others...

Issue: WSS sites work but SPS does not

Fix: Add an entry to the local hosts file on a SPS front-end server for
the sql instance

Details:

(1) MSSEARCH.LOG and W3WP.LOG showed the following error when
connecting to the SQL server instance:

"Microsoft OLE DB Provider for SQL Server" Description:
"[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
found."

(2) An "ipconfig /displaydns" on our front-end Sharepoint server showed
the following DNS cache entry for our SQL server instance:

     sql01\portal

     ----------------------------------------

     Name does not exist.

(3) Adding a host entry for the SQLServer\SQLInstance on the SPS
front-end server fixed the problem

sample hosts file modification:
w.x.y.z sql01\portal

Relevant Pages

  • slow connections with jdbc driver and no entry in hosts file
    ... We have had a problem with connections taking 30+ seconds to our sql server ... with sp1 and sp2 versions of the jdbc driver. ... We shouldn't have an entry in our hosts file. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Sharepoint as a way of managing projects
    ... SQL Server 2K but nothing for WSS) and thus not at the price levels of SPS. ... The WSS newsgroup is microsoft.public.sharepoint.windowsservices ... > involved (contact details, task lists, documents, specifications, ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Same query - different execution plans??
    ... Next, we ran the query from QA, it added an entry to syscacheobjects. ... Books Online does not specify which bit ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • SPS 2003: Catastrophic failure ????!!!
    ... I had a very weird message from SPS 2003 all of a sudden. ... I searched newsgroups and it seemed that it was a SQL server issue and ... checking logon accounts in all the related services including ... then restored it through the restore utility. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: How to DTS SQL Files to update Procs?
    ... the SPs on another. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... I would like to create a folder called "Finals" that is sub to the stored> proc's folder. ... > I'd like to read each proc found in the folder and run them to update all 30 ...
    (microsoft.public.sqlserver.dts)