ODBC cannot connect to MSDE 2000a

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.
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.shtmhttp://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
|||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...
> server.
> exist
> 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.shtmhttp://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
>
|||hi,
"Yair Sageev" <geekyheeb-news@.yahoo.com> ha scritto nel messaggio
news:eFIcuAkeEHA.3792@.TK2MSFTNGP09.phx.gbl...
> 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?
>
before reinstalling, pleas have a look at
http://support.microsoft.com/default...06&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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