Re: ODBC cannot connect to MSDE 2000a

From: Yair Sageev (geekyheeb-news_at_yahoo.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 12:33:46 -0400

I am having the exact same problem. I'm using SQL Server 2005 beta.

In the SQL manager utility I did what you suggested, which is to enable all
network protocols, and am getting the same issue.

It doesn't matter what client configuration I use for ODBC -- shared memory,
named pipes, tcp.

Should I uninstall the DB, delete all registry settings related to it, and
then reinstall?

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:2n9m2eFti527U1@uni-berlin.de...
> hi,
> "Padji" <gil.pajany@free.fr> ha scritto nel messaggio
> news:410f60ea$0$1890$636a15ce@news.free.fr...
> > Using MSDE 2000a (w/spk3a). XP Pro. Cannot connect w/ ODBC driver to
> server.
> > Have tried many things.
> > Below is the error when trying to connect via ODBC.
> >
> > Help!
> >
> > GIL
> >
> >
> >
> > ---------------------------
> > Microsoft SQL Server Login
> > ---------------------------
> > Connection failed:
> > SQLState: '01000'
> > SQL Server Error: 10061
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> > (Connect()).
> > Connection failed:
> > SQLState: '08001'
> > SQL Server Error: 17
> > [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
> exist
> > or access denied.
> >
> >
> >
>
> please verify your instance has netwrok protocols enabled... run Server
> Network Utility (svrnetcnexe) to check that and, eventually, enable TCP/IP
> as needed..
>
> eventually, run Client Network Utility (cliconfg.exe) and make sure TCP/IP
> are enabled .... try to make an alias using TCP using SQL server name and
> test connection. if it still fails, try creating an alias with the IP
> address of the SQL server.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

Relevant Pages

  • Re: SQL Server VPN problems / Help
    ... Create Alias to SQL server from your machine using CLIEN NETWORK UTILITY, ... I want to use the remote SQL as ...
    (microsoft.public.sqlserver.server)
  • Re: Network Utilities
    ... Below are the relevant excerpts from the SQL Server 2000 Boons Online: ... The Server Network utility is used to manage the server Net-Libraries. ... Most users will never need to use the Client Network utility. ... users can specify only the network name of the ...
    (microsoft.public.sqlserver.server)
  • RE: Is this the bug in SQL2000?
    ... The "Client Network Utility" is only used to configure how clients connect. ... The "Server Network Utility" controls what connections SQL Server will ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 7 Encryption Using Multiprotocol Network Library
    ... You mention that the client is properly configured, ... Did you run the Client Network Utility on the Client to ... SQL Server is installed on Windows 2000 Server. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Not listed in Browse list on Query Analyzer
    ... Happy Trails ... Server Network Utility ... >on the server itself and make sure that SQL Server is ... >locally using the alias. ...
    (microsoft.public.sqlserver.setup)
Loading