RE: Cannot connect in mixed mode after installing SQL2K on client

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 11/22/04

  • Next message: Larry: "Re: Run Multiple Stored Procedures in order with a script??" 
    Date: Mon, 22 Nov 2004 16:06:08 GMT

    First what is the error message that the application generates?

    If you attempt to create an ODBC DSN from your machine to the SQL Server,
    does it successfully connect? Try using both named pipes and tcp/ip and
    both NT and SQL authentication. If not what error does it generate?

    Rand
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: Larry: "Re: Run Multiple Stored Procedures in order with a script??"

    Relevant Pages

    • Re: Connecting to a sql server database
      ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
      (microsoft.public.dotnet.general)
    • Re: Invalid OLEVERB structure error 80040000 on DTS job
      ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
      (microsoft.public.sqlserver.dts)
    • Re: Classic ASP connectionstring to SQL Server 2005
      ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
      (microsoft.public.inetserver.asp.db)
    • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
      ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
      (microsoft.public.security)
    • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
      ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
      (microsoft.public.windowsxp.security_admin)