Re: SQL connect error

Hi,

If you are using September CTP, run the SQL Server Configuration
Manager and check which network protocols are running. TCP/IP and
Named Pipes is turned off by default on some editions in that CTP.

If TCP/IP is off then I would expect that you would find it difficult
to connect from the Web.

If that doesn't prove to be the problem please post further details of
your setup.

Andrew Watt
MVP - InfoPath

On Mon, 31 Oct 2005 11:58:26 -0800, "carlomd"
<carlomd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Hi all I've searched and couldn't find anything related to my issue, so I
>started a new post, I'm new to SQL and I installed the CTP for SQL 2005, I
>get this error when I connect off the web, it tests fine off of the ODBC
>admin, so I figured my account settings are correct, anyone can point me the
>direction would be great. thanks in advanced -
>Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'mitch'.
>
>/ConnOpen.inc, line 10

.

Relevant Pages

  • RE: Remote Server using Enterprise Manager
    ... site with Named Pipe but not TCP/IP. ... It seems that maybe your web hosting ... I still can not connect to the SQL database in my internet site neither ... I can now connect using both method in my local network. ...
    (microsoft.public.sqlserver.connect)
  • Re: MS SQL Express
    ... Und da hat A2000 genau so Probleme mit dem SQL2005, wie alle anderen Versionen, die vor dem SQL 2005 rausgekommen sind, wenn es um die Entwicklung der Datenbank Objekte geht, die im SQL Server 2005 abgelegt sind, also View, SPs, Tabellen, etc. ... Es geht hier rein um TCP/IP und darum, dass der SQL Server, wenn auf TCP/IP Konfiguriert, eine Port benötigt. ... Online Hilfe von Microsoft Access ...
    (microsoft.public.de.access)
  • Re: Conversion of Beta 2 Databases
    ... SQL Scott writes: ... the April CTP was the last CTP that was able to read the ... and then move the databases from the April CTP to the RTM ... It may be better to script the database (using the Beta 2 ...
    (microsoft.public.sqlserver.tools)
  • Re: CTP Hell
    ... > with the VS June CTP??? ... Apparently the SQL June CTP only works with VS ... and even that depends on install order. ... but will work with the included SQL Server 2005 Express Edition. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: "OLE DB Provider for Analysis Services 9.0" the 2nd
    ... To install just PTS, double click on the file: ... SQL BI Product Unit ... > now I've got the new CTP. ... >> SQL BI Product Unit (Analysis Services) ...
    (microsoft.public.sqlserver.olap)