No Open Files and no active sessions

cgeorgeisaac
cgeorgeisaac used Ask the Experts™
on
When we go to files and sharing there is no open files but there are active sessions.
Any idea what could be the reason and how to resolve this please.

Error: Database connection error
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Too little detail.
When do you get the error message?
Why do you expect to see open files?
What database is this about?
cgeorgeisaacSenior Engineer

Author

Commented:
Appreciate your quick response Qlemo:

This is the exact error:

Database Connection Error [Cannot connect to database Socket error on connect. WSAGetLastError return 10060($274C)]

Thanks
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
10060 is a connection timeout on TCP level. But I did not ask for that message ;-).
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

cgeorgeisaacSenior Engineer

Author

Commented:
Migrated Server from Windows Server 2003 to  2013.  All the FSMO, etc was transferred successfully.

When I  go to files and sharing, there is no open files but there are active sessions. I just need to find out what that is.
Does that help.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
You do not need to have open files to have an active NetBIOS session, so this "normal" for a domain controller. E.g. domain members check for group policy changes - you won't see them having open files unless they are doing that just that moment.
So that does not mean anything. It does not stop you from doing anything on the server.
cgeorgeisaacSenior Engineer

Author

Commented:
There are few users under the Sessions folder of Shared Folders.
- I need to  track them down ( where it is originating from, etc)
also,
- Any way to reset it or clear it completly

Thanks.
cgeorgeisaacSenior Engineer

Author

Commented:
When that server is powered off users get the error message mentioned earlier and once server powered on.. computers create the session (with no open files) and everything then works…

Trying to find out why computers are creating sessions with this server when its not supposed to be running anything.
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
There is no Windows Server 2013, so I assume you mean 2012.

Best to go into the good ol' Computer Management, e.g. via Server Manager » Tools. You will find something you are more familiar with ;-).
cgeorgeisaacSenior Engineer

Author

Commented:
This is on Windows Server 2003
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
You'll have to log network access on the server or a client when they start the application, e.g. with Process Monitor from www.sysinternals.com - but that might be something needing a lot of effort to be able to drill-down to the culprit.
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
So this on the old server? Then the first to look at is TCP/IP connections - use e,g, TcpView from www.sysinternals.com to get an overview.
cgeorgeisaacSenior Engineer

Author

Commented:
I have installed Process Monitor.  What exactly should I be checking for please?
cgeorgeisaacSenior Engineer

Author

Commented:
Yes it is on the old server. I installed TCPView.. What exactly should I check for please?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
TcpView displays all active TCP/IP connections. As this is the old server, you should not see any connection. You should press the button right from the A, so you see only connected sessions (versus seeing services listening to new connections).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial