SQL/Network issue

[Pooky]

Here's what's happening:

There is an SQL database on a Windows7 Professional PC. Other PC's need access to this at any given time.

Now what would cause the network on this SQL machine to get the little orange ! mark and say no internet access.

When it does this the SQL database is not accessable and one has to restart the machine; all the networked computers are still available though.

It does this randomly.

 

[SauRoNZA]

Is it using a Static IP?

 

[Messugga]

Here's what's happening:

There is an SQL database on a Windows7 Professional PC. Other PC's need access to this at any given time.

Now what would cause the network on this SQL machine to get the little orange ! mark and say no internet access.

When it does this the SQL database is not accessable and one has to restart the machine; all the networked computers are still available though.

It does this randomly.

Duplicate IP addresses on the network come to mind. Perhaps you assigned it a static IP within the DHCP dynamic IP range, which is populated when a machine comes onto the network?

 

[guest2013-1]

You don't have to reboot the machine, just "repair" it's network connection. It's usually just a lost connection to the DHCP/DNS servers which means xyz\sqlserver won't resolve etc

I'd say give it a static IP address / add it's DNS servers and see how it copes

 

[Tim the Techxpert]

Hi There,
make sure that you are using a static IP address on that PC. You may then need to re-link your applications to the SQL database.

Regards

Tim

 

[Pooky]

It is using a static IP address, as are all the machines on that network.

I went into services, and found that the actual database was stopped. I started it and it's working now but it seems that it may just be randomly stopping the service...

 

[Messugga]

It is using a static IP address, as are all the machines on that network.

I went into services, and found that the actual database was stopped. I started it and it's working now but it seems that it may just be randomly stopping the service...

Services don't "randomly" get stopped. Usually they stop because of an error of some form. You can set them to start "automatically" and that should have them restart on failure, but it will result in your connections being dropped, so isn't exactly a solution. Is there a Windows domain handling user authentication?

 

[Pulserider]

Try to disable the Windows 7 - Build-in Firewall. If you not using TCP/IPv6 which I'm totally sure you don't - disable that aswell on the network adapter. Get the latest network card drivers.

 

[syntax]

Services don't "randomly" get stopped. Usually they stop because of an error of some form. You can set them to start "automatically" and that should have them restart on failure, but it will result in your connections being dropped, so isn't exactly a solution. Is there a Windows domain handling user authentication?

Agreed on the services, check the error log for the reason the service stopped.