Can't find solution ANYWHERE

Sorry, but I'm about to rip my hair out...

I have 3 machines..1.serverbox with xp pro and sqlexpress...2 laptop1 with xp pro visual studio 2005....3 Laptop2 with xp Home edition.

I wrote an application in visual basic 2005 (Laptop1) that connects to an SQLserver on an xp pro box.

I used Network Wizard to set up my home network on 3 machines. serverbox, laptop1 and laptop2

I set up user1 in sqlexpress with the db1 access...and password.

conn.ConnectionString ="Provider=SQLOLEDB;Data Source=" & logServer.Text &";Initial Catalog=" & logDatabase.Text &";User ID=" & logUsername.Text &";Password=" & logPassword.Text

The application I wrote is on my xp pro laptop. It works. (wireless and cat5 connected) It connects to the servebox and SQLexpress and I see all the data. I use SQL authentication (Mixed Mode)..It works in debug mode and published .exe mode.

When I install and run my application on Laptop2 I get login error serverbox\Guest ALL THE TIME.

Server box has Guest Turned Off

I checked everything i could and can't find out what the problem is. All suggestions from sqlexpress forums I got were implimented...siimple fileshareing is turned off......Firewall setup to allow ip address....even turned off firewall......SQL set up to allow remote connections...BUT NOTHING WORKS.......

Is there anyone out there in Microsoft Land that can help me with this CRAZY PROBLEM.....

[1770 byte] By [nglow] at [2007-12-25]
# 1

Have you tried using a userid and password in your connection string for a local windows account on the server box (not a sql user account) and made sure that windows user has access to the database?

You might also take a look at this article (and related) http://www.microsoft.com/germany/technet/prodtechnol/winxppro/reskit/z04d621675.mspx

This article states that "File sharing is implemented by using the Guest account".

rkimble at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2
Yes I tried that as well....it worked on my laptop1 (xp pro) but not on laptop2 (xp home)
nglow at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 3

I suggest that you create a windows firewall exception for the SQL server service executable file on both of the client and the server and don't depend on making the firewall is off.

AmrOuf at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 4

I'm curious... what is the exact error message?

It sounds like you're describing an authentication error - which would indicate that the computers are establishing a connection, they are just unable to negotiate data transfer due to a problem with the requestor's credentials.

As a test, you should try enabling the guest account on the server; just to see if it works that way.

rkimble at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 5
When you say guest account on the server...do you mean sqlserver or the serverbox
nglow at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 6

Based on the error message you posted it would be the windows server itself.

Can you post the entire, exact error?

rkimble at 2007-9-3 > top of Msdn Tech,Visual Basic,Visual Basic General...