Connection Problems to Client Sql Server

Hello,
I am using a front end VB application to connect to sql server desktop
engine. Connecting to the (local) server work perfectly. However, I need to
connect to a sql server on a machine on my network that is also running the
sqlserver destop engine and access a database on that computer.
When I try to register the server in the enterprise manager, I receive an
error that the computer cannot connet to servername\guest. By the way, I'm
using windows XP Home edition with this error. When I try to connect to a
computer that is running Xp Pro, I receive the error that 'Login failed for
User(null), Not associated with a trusted sql connection'
Even though I'm trying to manually connect with the server with the
enterprise manager, I ultimately want to be able to connect from my
application that is simple running on the destop version of sql server to
another desktop version of sql server.
I've checked the ports and they are all set at 1433, All my installed
instances of sql server on my network are listed when I choose the server
name in enterprise manager.
Please, could somebody guide me through in how set up a connection to an
instance of sql server on my network.
Your help would be greatly appreciated!!!!
Cornelius
With XP home, authentication is done using the guest account
as simple file sharing is always enabled on XP Home. Refer
to the following for more info:
SQL Server clients are authenticated as guests if Simple
File Sharing is enabled
http://support.microsoft.com/?id=831133
Try using SQL authentication instead. Otherwise you need to
enable the guest account which isn't a good idea.
-Sue
On Fri, 18 Mar 2005 06:19:06 -0800, "Cornelius Wipf"
<ccee@.msn.com> wrote:

>Hello,
>I am using a front end VB application to connect to sql server desktop
>engine. Connecting to the (local) server work perfectly. However, I need to
>connect to a sql server on a machine on my network that is also running the
>sqlserver destop engine and access a database on that computer.
>When I try to register the server in the enterprise manager, I receive an
>error that the computer cannot connet to servername\guest. By the way, I'm
>using windows XP Home edition with this error. When I try to connect to a
>computer that is running Xp Pro, I receive the error that 'Login failed for
>User(null), Not associated with a trusted sql connection'
>Even though I'm trying to manually connect with the server with the
>enterprise manager, I ultimately want to be able to connect from my
>application that is simple running on the destop version of sql server to
>another desktop version of sql server.
>I've checked the ports and they are all set at 1433, All my installed
>instances of sql server on my network are listed when I choose the server
>name in enterprise manager.
>Please, could somebody guide me through in how set up a connection to an
>instance of sql server on my network.
>Your help would be greatly appreciated!!!!