Re: sqlserver 2000 sp3 (on windows 2003 server) - access 2002 odbc error

From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 10/22/04

  • Next message: Derrick Leggett: "Re: SQL Desktop server got somehow disconnected" 
    Date: Fri, 22 Oct 2004 01:50:56 -0500

    1. Can he ping the other Windows 2003 SQL Server?
    2. Set up a trace and check for failed logins. Is he making it that far?

    Troubleshoot from there. Let us know the results and we can help you more.

    "Hubert Mayr" <huma1@gmx.net> wrote in message
    news:1098361967.242762@news.liwest.at...
    > Hi,
    >
    > a user of my lan has windows xp installed (sp1 first now sp2). He works
    with
    > access 2002 and wants to link to some sqlserver tables.
    > when he creates a new odbc connection to that sqlserver he gets the
    > following error message:
    >
    > Connection failed
    > SQLState: '01000'
    > SQL Server Error: 53
    > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
    > Connection failed:
    > SQLState:'08001'
    > SQL Server Error: 17
    > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
    > access denied
    >
    > I have a second sqlserver 2000 (SP3) on windows 2000 server running. Here
    > that user has created the odbc connection sometime ago and that is
    running.
    > Only the odbc connection to that second sqlserver 2000 (SP3) on windows
    2003
    > server is not running.
    > When he wants to create it he comes not to the window with the odbc test.
    > When I make a connection from my pc with that windows user I can create
    that
    > odbc connection
    > Sqlserver allows mixed mode user connections.
    > Who has an idea?
    >
    > Thanks!
    >
    >
    >
    >
    >

  • Next message: Derrick Leggett: "Re: SQL Desktop server got somehow disconnected"

    Relevant Pages

    • Getting to the bottom of MSDE network connection problems ...
      ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
      (microsoft.public.sqlserver.msde)
    • Re: Remote connection failed
      ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
      (microsoft.public.sqlserver.connect)
    • Re: Bizzare SQL Network Error
      ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: ODBC to SQL Server Express?
      ... >Server connection, in both the system's ODBC connection manager and the ... >>>Can I create an ODBC connection to SQL Server Express? ... >>>Server Express and Visual Web Developer Express (for a database frontend ... I need to access the SQL Server Express databases via ODBC. ...
      (microsoft.public.data.odbc)
    • Re: Connection Error: ADO.Net and SQL Server 2005
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... I can connect to the server through an ODBC connection ... It is very puzzling because this client doesn't seem to have anything ...
      (microsoft.public.sqlserver.connect)