Accessing a remote SQL instance

Post moderated by XIII, please leave out the "irrrggent" in the subject line:

i'm using a SQL Server 2000.
now want i want is to make one of the machine on my local network
Machine one: i've installed the SQL Server 2000 with these settings
1) Use Local System
2) MixMode (Use Windows Authentication and SQL Server Authentication)
USER ID = sa
Password = sa
FromMachine tow which has the program: the connection string is:

<<< Me.SQLConnection_Search.ConnectionString = "packet size=4096;integrated security=SSPI; Persist Security Info=true; data source= "the name of the instance on Machine ONE"; user id=sa; password=sa; initial catalog=DBNEW; Server="Machine One Name">>>>>>>

when i connect --> "connect faild to MachineOne\Guest"

when i changed the SERVER to SERVER = "Machine One Name\User Account of the windows"
this message appear : "SQL Server does not exist or access is denied"

So what can i do.??

I'm not sure what your doing but the way I connect to local database is:
Dim cn As SqlConnection = New SqlConnection("workstation id=yourcomputername;packet size=4096;integrated security=SSPI;data source=yourcomputername;persist security info=False;initial catalog=yourdatabasename")