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.TextThe 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.....

