Q175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
Q159976 HOWTO: Connect to the Microsoft SQL Server through Named Pipes
While connecting to the Internet, in your browser typing in: mskb q159976 will bring up the article.
--------------------
| From: "Thoades" <PJRhoades@<noSpam>Hotmail.com>
| Subject: IIS / SQL Authentication Failure
| Date: Tue, 8 Jan 2002 12:32:32 -0000
| Lines: 232
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_001A_01C19840.8B820F10"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
| Message-ID: <eHUzs9DmBHA.2024@tkmsftngp03>
| Newsgroups: microsoft.public.inetserver.iis.security
| NNTP-Posting-Host: modem21.netkonect.net 194.164.208.21
| Path: cpmsftngxa09!tkmsftngxs01!tkmsftngp01!tkmsftngp03
| Xref: cpmsftngxa09 microsoft.public.inetserver.iis.security:3122
| X-Tomcat-NG: microsoft.public.inetserver.iis.security
This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your
use. © 2001 Microsoft Corporation. All rights reserved.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q159976
this article is relevent but concenrs the use of asp and iis, if I was connecting from iis on my computer to a remote sever running sql in the data centre then I would expect it
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175671
This one sort of explains it better EXCEPT that it does not say that this impersonation is also undertaken through the SQL Server Management Console. If I was attempting to run code on my machine and access SQL on your server then it would be 100% correct
I have ensured that I am only ever talking to SQL server through IP by removing the named pipes protocol from my client network utility in SQL 7 but the problem seems to persist.
Any further information would be of great interest.
Regards,
Paul R. Rhoades
Overall, I believe the issue is likely within the authention method and what type of security SQL is
applying. Some information is available in
Q247931 INF: Authentication Methods for Connections to SQL Server in ASP
Hope this helps.
--------------------
| From: "Thoades" <PJRhoades@<noSpam>Hotmail.com>
| References: <eHUzs9DmBHA.2024@tkmsftngp03> <mDzHmfFmBHA.1992@cpmsftngxa09>
| Subject: Re: IIS / SQL Authentication Failure
| Date: Tue, 8 Jan 2002 17:15:44 -0000
| Lines: 89
| MIME-Version: 1.0
| Content-Type: multipart/alternative;
| boundary="----=_NextPart_000_0008_01C19868.1B1890A0"
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
| Message-ID: <Ox1$7bGmBHA.2080@tkmsftngp04>
| Newsgroups: microsoft.public.inetserver.iis.security
| NNTP-Posting-Host: p133.nas2.man.opaltelecom.net 62.24.142.133
| Path: cpmsftngxa09!tkmsftngxs01!tkmsftngp01!tkmsftngp04
| Xref: cpmsftngxa09 microsoft.public.inetserver.iis.security:3132
| X-Tomcat-NG: microsoft.public.inetserver.iis.security
This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your
"Thoades Hotmail.com>" <PJRhoades@<noSpam> wrote in message news:eHUzs9DmBHA.2024@tkmsftngp03...
"Roger Abell" <ab...@NOSpam.asu.edu> wrote in message news:ehAckyNmBHA.2024@tkmsftngp03...