Cannot connect to MSDE

Hi Andrea,

I'm having the same problem. I am working in a peer-to-peer LAN (all XP
stations) and have all my tools installed on one station (MSDE, Visual
Studio, you great DbaMGR2k, Book Online, etc) and things are working
fine, but I can't access SQL from the other stations. All the stations
can see each others and share all other resources.

- I used svrnetcn.exe to make certain TCP/IP protocol was installed, it was
- I tried added named pipes too but it doesn't help
- I logged in as Administrator but still have the problem

Questions:
- Do I need to install MSDE on all the stations?
- Could Windows XP SP2 firewall be the problem?

Thanks

Richard



Andrea Montanari wrote:
 > hi Tom,
 > Tom wrote:
 >
  >>Hello all,
  >>
  >>I have two computers in LAN. Both computers are visible
  >>one to another. First computer has MSDE installed on it.
  >>Second cumputer runs application that needs to connect to
  >>MSDE installed on the first computer. The problem is that
  >>application installed on second computer cannot connect to
  >>MSDE and i cant figure out why is that so.
  >> The application running on first computer(the one that
  >>has MSDE installed on it) can connect to MSDE without any
  >>problems. MSDE is configured to use SQL Server
  >>authentication. Can anyone help me please ?
  >>
  >>Regards,
  >>Tom
 >
 >
 > MSDE installs by default disabling network protocols to prevent external
 > mailcius attacks...
 > you have to manually enable them, bot at install time providing the
 > DISABLENETWORKPROTOCOLS=0
 > parameter to setup.exe boostrap installer and/or later using the Server
 > Network Utility (svrnet.cn.exe) to enable the desired/required network
 > protocol (usually TCP/IP)
 >> Stay informed about: Cannot connect to MSDE 

hi Richard,
Richard Fagen wrote:
 > Hi Andrea,
 >
 > I'm having the same problem. I am working in a peer-to-peer LAN (all
 > XP stations) and have all my tools installed on one station (MSDE,
 > Visual Studio,
 >
 > you great DbaMGR2k

thank's

 >
 >, Book Online, etc) and things are
 > working
 > fine, but I can't access SQL from the other stations. All the
 > stations can see each others and share all other resources.
 >
 > - I used svrnetcn.exe to make certain TCP/IP protocol was installed,
 > it was
 > - I tried added named pipes too but it doesn't help
 > - I logged in as Administrator but still have the problem
 >
 > Questions:
 > - Do I need to install MSDE on all the stations?

no, you don't
 > - Could Windows XP SP2 firewall be the problem?

probably yes...
please have a look at <a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?kbid=841249" target="_blank">http://support.microsoft.com/default.aspx?kbid=841249</a>
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;[LN];841251" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;[LN];841251</a>

personally I always solved my troubles adding an exception to the firewall
for the related TCP/IP port both specifying a subnet range and/or defined
pc's IP ... if you can restrict the IP list your server will appreciate it

for named instance the UDP 1434 port must be opened as well, if you do not
specify an ALIAS on all remote clients pointing to a static defined (and not
dinamically assigned) port
--
Andrea Montanari (Microsoft MVP - SQL Server)
<a rel="nofollow" style='text-decoration: none;' href="http://www.asql.biz/DbaMgr.shtm" target="_blank">http://www.asql.biz/DbaMgr.shtm</a> <a rel="nofollow" style='text-decoration: none;' href="http://italy.mvps.org" target="_blank">http://italy.mvps.org</a>
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
 >> Stay informed about: Cannot connect to MSDE 

Hi Andrea,

Thanks for the links
 > probably yes...
<font color=purple> > please have a look at <a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?kbid=841249</font" target="_blank">http://support.microsoft.com/default.aspx?kbid=841249</font</a>>
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;[LN];841251</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;[LN];841251</font</a>>

I tried what it said and I even tried disabling the XP SP2 firewall on
both PCs but the second PC (the one without MSDE installed) still can't
see the first PC (with MSDE and the databases).

I tried using your utility, DbaMGR2k, on the second PC but when I try to
connect, I get the error message, "429 - ActiveX component can't create
object"

I am new to MSDE and I am not sure if I need aliases, named pipes,
special libaries etc. What I do have configured is TCP/IP protocol and
I checked and it uses the default port 1433. I also only have one
instance, the default, created during installation.

I could try to install MSDE on a third PC with all the defaults and see
what happens, but I'm fairly certain I didn't change anything from the
recommended defaults during the initial installation.

Any ideas why the other stations still can't see MSDE?

Thanks.

Richard Fagen

 >
 > personally I always solved my troubles adding an exception to the firewall
 > for the related TCP/IP port both specifying a subnet range and/or defined
 > pc's IP ... if you can restrict the IP list your server will appreciate it
 >
 > for named instance the UDP 1434 port must be opened as well, if you do not
 > specify an ALIAS on all remote clients pointing to a static defined (and not
 > dinamically assigned) port
 >> Stay informed about: Cannot connect to MSDE 

hi Richard,
Richard Fagen wrote:
 > I tried what it said and I even tried disabling the XP SP2 firewall on
 > both PCs but the second PC (the one without MSDE installed) still
 > can't see the first PC (with MSDE and the databases).

can you reach the MSDE installed pc from the remote client for standard
sharing?
can you ping it?
can you telnet it, in the form
c:\..\>telnet ComputerName 1433;
if the screen becomes black you are in... then just type QUIT to exit..

 >
 > I tried using your utility, DbaMGR2k, on the second PC but when I try
 > to connect, I get the error message, "429 - ActiveX component can't
 > create object"

DbaMgr2k does not provide the SQL-DMO dependencies it relies on becouse of
the presence several international localizations and service pack level..
in the application folder you can find the Depend2k.txt file which lists, in
the SQL-DMO section, all the required files you can get from the MSDE
installed pc and copy on the destination pc.. please fullfill the indicated
hyerarchy and register via regsvr32 the required file (just 1)
please feel free to privately contact me for any question or concern about
the project, as long as for suggestions and feedback, as this is OT in this
public newsgroup...

 > I am new to MSDE and I am not sure if I need aliases, named pipes,
 > special libaries etc. What I do have configured is TCP/IP protocol
 > and I checked and it uses the default port 1433. I also only have one
 > instance, the default, created during installation.

that's ok.. the default instance listens on TCP/IP 1433 (if it has not been
changed) and does not require an ALIAS nor the UDP 1434 port for the SQL
Server Resolution Service to work as it is not needed..

 >
 > Any ideas why the other stations still can't see MSDE?

if all TCP/IP requirements and checks has been satisfied, I do think it's
just a network problem.. please verify your connectivity other then SQL
Server...

again... for my personal tests I just referenced
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?kbid=841252" target="_blank">http://support.microsoft.com/default.aspx?kbid=841252</a> and worked like a
charm...
--
Andrea Montanari (Microsoft MVP - SQL Server)
<a rel="nofollow" style='text-decoration: none;' href="http://www.asql.biz/DbaMgr.shtm" target="_blank">http://www.asql.biz/DbaMgr.shtm</a> <a rel="nofollow" style='text-decoration: none;' href="http://italy.mvps.org" target="_blank">http://italy.mvps.org</a>
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
 >> Stay informed about: Cannot connect to MSDE 

In the service manager, under the named instance where it says "server" and
there is a drop menu, be sure that the server agent service is running.

url:http://www.ureader.com/msg/114932.aspx
 >> Stay informed about: Cannot connect to MSDE