SQL Server Performance

confusing about SQL server error 1396 and 67

Discussion in 'General DBA Questions' started by johnson alonso, Apr 22, 2007.

  1. johnson alonso New Member

    Dear All SQL server Experts,
    I am new bie here and I have a problem where the client PC can't connect to server to open a database using GUI installed in the client's PC. The error message is:
    Connection failed:
    SQL State: '01000'
    SQL Server Error: 1396
    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(CreateFile()).
    Connection failed:
    SQL State: '08001'
    SQL Server Error: 1396
    [Microsoft][ODBC SQL Server Driver]Client unable to establish connection

    I have browsed in microsoft support and find the solution but there is a little bit different with the above mentioned error message. The error message in the Article ID274383 is:
    Connection failed:
    SQL State: '01000'
    SQL Server Error: 67
    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(CreateFile()).
    Connection failed:
    SQL State: '08001'
    SQL Server Error: 67
    [Microsoft][ODBC SQL Server Driver]Client unable to establish connection

    I am really confusing about the difference. does it make sense or both of them are same ?
    So, the solution suggested in the article could be used. I apreciate your answer. TIA


    Rgds,


  2. MohammedU New Member

    Try to connect using TCP/ip and see what you get...<br /><br />Like in QA connection:<br />tcp<img src='/community/emoticons/emotion-7.gif' alt=':s' />ervernameinstancename,portnumber <br /><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  3. johnson alonso New Member

    Tks for you quick reply. It means that the answer provided in the article are for both type of the problem. You wrote:

    quote:

    Try to connect using TCP/ip and see what you get...

    I have checked and confirmed to our client. Anyway, they said that if they use DNS server address, preferred or alternate, it works. they did it after I told them to change client configuration in ODBC data source administration localserver (SQL server) from named pipes to TCP/IP. Another place to using TCP/IP is in the client network utility and server network utility.
    I'll confirm soon.


    Rgds,
  4. satya Moderator

    Error 1396 causes, by the way Users, Groups, Rights, and Permissions are configured. Specifically, IIS does not have permissions to open a Named Pipe connection to the SQL Server if it is involved. Change the anonymous user on the IIS computer to be a domain account so that the NT/SQL computer can verify this account against the domain controller. To change which account is used, open the WWW Properties dialog box in the Internet Service Manager. Change the Anonymous Logon Username and password.

    Take help of this KBAhttp://support.microsoft.com/kb/138541 to see whether the connectin is reaching SQL server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. johnson alonso New Member

    Tks for your reply. I have browsed to the link you've provided and I'll try to inform to our client so that they could resolve the problem.
    Anyway, I have posted a message/topic about "can't open SQL server 2005" in SQL 2005 General DBA Questions, but I could not find it anymore, where did it go ? was it be deleted without any confirmation ?



    Rgds,
  6. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Dont' worry, I have moved it to appropriate forum as the thread seems to fit there.<br /<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20929>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20929</a> and you should have get an email when it is moved.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>

Share This Page