SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 apps disconnecting
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mccarron
Starting Member

USA
2 Posts

Posted - 08/20/2013 :  19:12:23  Show Profile  Reply with Quote
Just took over our single 2008 OS/2008 sql server when we started having a major problem. Seems that every couple hours user lose connection to their SQL apps (accounting and crm) Paackages from different companies. They reboot and still can't get in. just hourglasses when they try to run the app. No error message at all not ever in event viewer. If I go into computer on the workstation I can see all their mapped drives and they are using dns off the server and can access the internet. I have to re-boot the server and then everything works ok for another couple of hours. Then we start all over again

Any Ideas

Mike McCarron

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 08/20/2013 :  21:03:11  Show Profile  Reply with Quote
Can anyone connect to the database server, or is it only specific users? Assuming it is all users, can you connect to the database server using SQL Management Studio? Although this blog describes procedures that you go through when you are never able to connect to a server from a remote machine, some of the info there may be useful and applicable when you are in that state where you cannot connect http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx
Go to Top of Page

mccarron
Starting Member

USA
2 Posts

Posted - 08/21/2013 :  08:54:37  Show Profile  Reply with Quote
When it happens no one can access the database server, but I can access the management studio. I will read over you link and let you know. Thanks

Mike McCarron
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3557 Posts

Posted - 08/21/2013 :  09:52:24  Show Profile  Reply with Quote
quote:
Originally posted by mccarron

When it happens no one can access the database server, but I can access the management studio. I will read over you link and let you know. Thanks

Mike McCarron

I hope you meant that you can access the database server FROM the SQL Server Management Studio rather than access SQL Server Management Studio itself.

Are you launching SSMS from the computer on which SQL Server is installed or are you doing that from a remote computer? If you are connecting from the server computer, see if you can access it from a remote computer using SSMS.

I don't really have any good guesses as to why you are seeing this problem. Nothing on the SQL Server side of things comes to mind. It could be a network issue (in which case you won't be able to connect using SSMS from a remote computer), or it might be something in the client application.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000