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
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
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.