Bacon in the fire

I have installed MSDE sp3 with the SAPWD and DISABLENETWORKPROTOCOLS=0
switches set. The server works fine on the local machine but attempts to
access it respond with a 'server does not exist or access denied' message.
How do I verify (via osql) that the NetLib is installed correctly for
TCP/IP? If it is not how do I configure it?
Semper Fi,
Red
Please post to newsgroup only
hi Stephen,
"Stephen J Bement" <spam@.null.net> ha scritto nel messaggio
news:%23RtoNK$nEHA.708@.TK2MSFTNGP09.phx.gbl
> I have installed MSDE sp3 with the SAPWD and DISABLENETWORKPROTOCOLS=0
> switches set. The server works fine on the local machine but attempts
> to access it respond with a 'server does not exist or access denied'
> message.
> How do I verify (via osql) that the NetLib is installed correctly for
> TCP/IP? If it is not how do I configure it?
if you are running Windows XP service pack 2, perhaps
http://support.microsoft.com/default.aspx?kbid=841249 is worth reading
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||the system is running XP sp1 not sp2. It does not have any firewall software
running. It can connect to the Server system (i.e. connect drives copy files
and PCAnywhere) but cannot communicate with the SQL Server.
TIA
Semper Fi,
Red
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2rb1i1F17ftttU1@.uni-berlin.de...
> hi Stephen,
> "Stephen J Bement" <spam@.null.net> ha scritto nel messaggio
> news:%23RtoNK$nEHA.708@.TK2MSFTNGP09.phx.gbl
> if you are running Windows XP service pack 2, perhaps
> http://support.microsoft.com/default.aspx?kbid=841249 is worth reading
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||You might want to check out following article.
BUG: You may not be able to connect to an instance of Microsoft SQL Server
2000 Desktop Engine SP3a or to an instance of Microsoft SQL Server 2000
Desktop Engine (Windows) after you enable the server network libraries
http://support.microsoft.com/?id=827204
To checkout if network libraries are enabled, you can just see errorlog and
see if SQL Server is listening on named pipe and tcp/ip libraries.