July 12, 2011 at 11:30 am
I have no idea why, but:
Client has a 64 bit station they're trying to connect to SQL Express running on an XP computer. Of course, the applications always get "Server doesn't exists or unable to login." Their other XP computers can access the database.
It is, of course, development's responsibility to figure out how to use this insane configuration.
Suggestions? Articles to read? App notes to consult?
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
July 12, 2011 at 11:35 am
Have you ruled out any network issues? Can you ping the server's IP address from the 64-bit client?
_________________________________
seth delconte
http://sqlkeys.com
July 12, 2011 at 11:40 am
also express editions don't accept allow remote connections by default; you'll need to right click on the server in SSMS, go to Properties,a nd then Connections:
Lowell
July 12, 2011 at 11:43 am
Yes, they can ping the server by ip address, but not name.
The XP computers that can access the database can also ping the server by ip address, but not name.
Since the XP computers can access the database, it's likely that the server express is configured for external connection.
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
July 12, 2011 at 11:50 am
Is the Windows Firewall turned on for the client?
_________________________________
seth delconte
http://sqlkeys.com
July 12, 2011 at 1:52 pm
A friend tells me:
Go into the NIC settings, on the advanced tab and make sure the Enable NetBios over TCP/IP is checked on.
I can't seem to try it as the silly computer won't talk to my remote support all of a sudden.
"It's your computer that's stupid, not you, right?"
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply