Unable to connect to SQL server since going wireless

[dibbo]

Hi,

a bit of a strange one. A number of our SQL server clients have been put on to a wireless network, since this has happenned 2 out of 3 administrators are unable to connect to the client servers via Enterprise Manager.

further info:
We can ping the clients by both device name and IP.
The 2 admin PC's that are unable to connect - one is win2000, other XP.
The 3rd administrator who can connect has the same XP and SQL server installation(as far as I can tell) as the other XP administrator.
The wireless adaptors ahve the same IP and subnet mask as the old wired ethernet connection.
Basically the only difference is that the clients now have a network card and are enabled for wireless.

Has anyone any ideas?

TIA. David.

 

[chrissie1]

Can the clients ping the server by both device name and IP?

Christiaan Baes
Belgium

"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett

 

[dibbo]

Hi,
thanks for the response. yes can ping by both device and ip.

 

[gmmastros]

Does the wireless router also function as a firewall? (I think most of them do).

If this is the case, then you will need to configure the port forwarding such that the port used by SQL Server is forward (from the router) to the computer hosting the database. By default, SQL server uses port 1433. It can be different, though.

-George

"the screen with the little boxes in the window." - Moron

 

[dibbo]

firewall on the router is not activated.

i tend to think it's not something as a fellow colleague can view the clients via his enterprise manager. Therefore would think it is a setting on our local machine.

not sure whether it is related to our local wireless cards or IP setup or subnet mask...etc.. However, from speaking to our network guys all seems ok...

 

[gmmastros]

How are you connecting to the database?

I would suggest that you try connecting directly to the IP Address of the SQL Server instead of the computer name.

-George

"the screen with the little boxes in the window." - Moron

 

[dibbo]

apologies, I should have mentioned this in my original post.

yes I've tried that aswell to no avail...

 

[gmmastros]

Take a look here: faq962-5481

-George

"the screen with the little boxes in the window." - Moron