LJG
asked on
SQL and network disconnect
Question
How do I stop my desktop computer from disconnecting from my SQL Server on my (domain) file server?
What happens?
Everything is working fine on my desktop, and then all of a sudden I'm disconnected from SQL Server on my file server.
When this happens
* All the time I can still get to the internet
* Most of the time I can get to the files on my file server, about half the time I can't get to the files.
How do I reconnect?
If I disconnect my network card and then reconnect, everything works.
* Control Panel / Network and Sharing Center / Change Adapter Settings
* Right click on the Adapter -- Click Disable / then Enable
* Just for info, I've setup a bat file to do this.
Some Facts
Happens many times a day
Window 10 Pro
I have SQL 2008R & 2012 installed on both my server and my local machine.
I'm a programmer and know very little about hardware.
Any help is greatly appreciated
LJG
How do I stop my desktop computer from disconnecting from my SQL Server on my (domain) file server?
What happens?
Everything is working fine on my desktop, and then all of a sudden I'm disconnected from SQL Server on my file server.
When this happens
* All the time I can still get to the internet
* Most of the time I can get to the files on my file server, about half the time I can't get to the files.
How do I reconnect?
If I disconnect my network card and then reconnect, everything works.
* Control Panel / Network and Sharing Center / Change Adapter Settings
* Right click on the Adapter -- Click Disable / then Enable
* Just for info, I've setup a bat file to do this.
Some Facts
Happens many times a day
Window 10 Pro
I have SQL 2008R & 2012 installed on both my server and my local machine.
I'm a programmer and know very little about hardware.
Any help is greatly appreciated
LJG
als315
Try infinite ping to your SQL server (ping -t IP_of_Server) and look at results
Is that the Express Edition of SQL Server or the Standard (or better)?
ASKER
als315 "infinite ping to your SQL server"
* The SQL Server on my desktop or the one on my network.
* Can you tell me where Infinite Ping is in the properties
Eric
* I'm using Express Edition of both 2008r and 2012
I'm a one man shop
Thanks for the response
LJG
* The SQL Server on my desktop or the one on my network.
* Can you tell me where Infinite Ping is in the properties
Eric
* I'm using Express Edition of both 2008r and 2012
I'm a one man shop
Thanks for the response
LJG
ASKER
Just two other thing - i'm not sure it makes any difference
My desktop was disconnected from the file server this morning (standard operation)
* Could not get to the files on the server or SQL Server.
* I can get to the internet
* I Disable / then Enable my network card on my desktop and everything works.
Thought it might be my DHCP lease after some research yesterday - It's not
* Yesterday it showed it expired today. Today it shows it expires tomorrow.
My desktop was disconnected from the file server this morning (standard operation)
* Could not get to the files on the server or SQL Server.
* I can get to the internet
* I Disable / then Enable my network card on my desktop and everything works.
Thought it might be my DHCP lease after some research yesterday - It's not
* Yesterday it showed it expired today. Today it shows it expires tomorrow.
Check the Auto_Close settings. Have a look at http://emoreau.com/Entries/Blogs/2011/11/SQL-Server-Beware-of-the-AutoClose-setting.aspx
ASKER
Eric
Auto_Close if off on all my databases.
I don't think it has to do with the server, because
* Most of the time I can get to the files on my file server, about half the time I can't get to the files.
dir \\xxx My Server\Server_D\My directory
"The system cannot contact a domain controller to service the authentication request. Please try again later."
Any Thoughts?
Auto_Close if off on all my databases.
I don't think it has to do with the server, because
* Most of the time I can get to the files on my file server, about half the time I can't get to the files.
dir \\xxx My Server\Server_D\My directory
"The system cannot contact a domain controller to service the authentication request. Please try again later."
Any Thoughts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry - things are going worse - I'm calling out the network guy.
Thanks
LJG
Thanks
LJG
ASKER
It's fixed now - this is just info in case someone runs into the same problem.
The problem was with my server - The windows update somehow made my server where it was not a domain server.
How you can see the problem on the server
Control Panel\Network & Internet \Network and Sharing Center
Under View your Active Networks
It should have your domain name with "Domain Network" under the domain name.
What make no sense to me - but it solved now so I can move forward
It started out my desktop couldn't communicate at times with SQL Server on the network.
If I Disabled my desktop network card, the enabled it, everything worked.
Then about 2 weeks later the above trick didn't work.
Anyway - thanks all for your suggestions
LJG
The problem was with my server - The windows update somehow made my server where it was not a domain server.
How you can see the problem on the server
Control Panel\Network & Internet \Network and Sharing Center
Under View your Active Networks
It should have your domain name with "Domain Network" under the domain name.
What make no sense to me - but it solved now so I can move forward
It started out my desktop couldn't communicate at times with SQL Server on the network.
If I Disabled my desktop network card, the enabled it, everything worked.
Then about 2 weeks later the above trick didn't work.
Anyway - thanks all for your suggestions
LJG