cannot Connect to SQL-Server on WinXP Home

[NightZEN]

I am running SQL Server on a WinXP Home Machine. I have a DB I connect to locally via an ODBC driver for an Access Front-End. Works Fine. I used to be able to connect via my laptop and wireless network using ODBC but cannot anymore. I am using SQL Server security with the same SQL account that worked before. I have all Firewalls turned off. I have tried and tried to recreate the ODBC File dsn driver but still cannot connect. Any idea's?!

Thanks!
Keith

 

[abaldwin]

More than likely a network connection problem with DSN on your router.

can you ping the xpHome machine by name from your laptop.
How about by IP address?

Thanks


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[NightZEN]

Yes I can ping the IP address, but not the Computer name.

 

[abaldwin]

Check your DNS settings and psosbily create a Host file on your machine for the SQL server. or try to connect using the ip address.

Do you have the enterprise manager on you local workstation?


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[Amiel]

There can be several things as described by the symptoms you describe. The local machine connects fine... what is the error that you get on the laptop specifically.

For the sake of time the most likely cause is the absence of SQL Server tcp libraries on the server and/or the client.

Does this ring a bell?



Amiel Summers
amiel@asaieast.org