Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mccarron
Starting Member
2 Posts |
 Posted - 2013-08-20 : 19:12:23
|
| 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 againAny IdeasMike McCarron |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-20 : 21:03:11
|
| 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 |
 |
|
|
mccarron
Starting Member
2 Posts |
Posted - 2013-08-21 : 08:54:37
|
| 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. ThanksMike McCarron |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-21 : 09:52:24
|
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. ThanksMike 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. |
|
|
|
|
|
|
apps disconnecting