Can't connect to the sql server

I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:

>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;