"ByLoCK" <bylockQUITAESTO@telepolis.com> wrote in message
news:Xns93DE703107CEbylockterraes@213.4.130.20...
> One of my problems with XP:
>
> From EM on my w2k+sqls2k, I can't change start msde account or sqlagent
> msde account on XP computer+msde.
>
> I think it is problem. because both computers don't have trusted
> connection.
>
> And, if I want add msde+xp to my EM with NT_AUNTENTHICATION it says me
> that the Guest account doesn't have access to the system. It doesn't
> catch my system account and replace it with Guest account.
>
> Thanks
>
>
> "Denny" <mrdenny@gamespy.com> wrote in
> news:#EG$ET0ZDHA.1740@TK2MSFTNGP10.phx.gbl:
>
> > ok.
> >
> > From the Win2k server can you access the SQL Server on the XP machine
> > at all?
> >
> > From the machine that is working try connecting to the xp machines sql
> > port (normally 1433). From a command prompt type "telnet
> > xpmachinename 1433" and hit enter. If you get a flashing cursor that
> > is what is suppose to happen. If it says that it can't connect then
> > something is blocking the port.
> >
> > If the port is blocked on the XP machine open EM, and right click on
> > the local database server and click properties. Then click on the
> > Network Configuration button. Make sure that TCP/IP is on the right
> > hand side. And that it's configured for port 1433.
> >
> > Check the SQL Log on the XP Machine and make sure that the server
> > started listening on port 1433 for the real IP of the machine (there
> > will also be an entry for 172.0.0.1:1433). If it's listening on
> > 172.0.0.1 and not the actual IP then stop and restart the service.
> >
>