I have a problem connecting with Sql Express. Here is the setup: 3 machines, all running SqlExpress on XP.Machine 1 is a notebook, and machines 2 and 3 are Tablet PC's. I seem to have all 3 set up identically, and can connect between 1 and 2. However, Machine 3 is the problem. From 1 and 2, I can "see" the instance on 3 but not connect, and from 3, I can "see" the instances on 1 and 2, but not connect.
I have read through the docs and have SqlBrowser on and configured, I turned off the firewall on 3, and have Sql SErver enabled for remote connections on all three machines. I have perused the security settings for Sql on 3 and it appears to be the same as the other two machines. I have matching administrator accounts on all 3 machines.
The connection error is the standard one about can't connect or don't have privileges.
I think this is a network problem and here is why: I used to use machine 3 at work. My employer's IT dept set it up to give me network and internet access. Although I can "see" the SqlExpress services in SSMS, I can't expand the network node using Windows Explorer on machine 3, and I can't access the shared folders on machine 3 from machines 1 and 2.
Is there a networking setting that may be preventing me from connecting to the other machines?