Problems connecting from specific client to specific server

This has me stumped!
Background: Win7 client, Win2kR2 server.
I have my normal user account (local admin) that I use to connect to database servers on my workstation.
I have an admin account (member of domain admin) that I use to RDP to servers.

Suddenly when I try to connect to a specific server from either SQL, ODBC setup or RDP it fails (or succeeds temporarily but with bad performance and an eventual boot).
I can go to another client and RDP without an issue to this server. I can RDP to other servers from anywhere no problem. Other users cannot RDP to the affected server from my workstation.

The issue seems to be between my workstation (any account/program) and this server.
The server and my client have been rebooted. The profile (C:\users\profilename) has been deleted on my worksation in case something was hanging around but the problem still exists.

Any ideas what this can be? The event logs on both the client and server don't offer up any obvious clues.
LVL 29
QPRAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UnHeardOfCommented:
Check your nic speed. Make sure your only using a wired or wireless, not both.
0
JohnBusiness Consultant (Owner)Commented:
Also try a TCP/IP reset on the workstation.

Open cmd.exe with Run as Administrator
Then  netsh int ip reset c:\resetlog.txt
Also, ipconfig /flushdns followed by net stop dnscache followed by net start dnscache
Then restart the computer

Also, why are you still using a Windows 2000 server?
0
QPRAuthor Commented:
Sorry typo is windows 2008 R2.
I can RDP to server A and then RDP to server B (the problem one) without an issue!

I'll try your cmd suggestions and report back
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

QPRAuthor Commented:
Would NIC speed be a factor if I am able to connect to other servers without issue? Also I can use all other networked apps etc no problem. Hardwired LAN here.

Did what you suggested John.
Got on briefly, performance was almost non-responsive despite task manager/perfmon reporting all was well.
Within a minute connection was lost.

Regarding my comment above, in case it was misread, - I can RDP to server A and then while connected to server A, RDP to server B

Something on this workstation is not playing nicely with this server (only).
I can jump on my colleagues workstation and RDP to the server just fine.
0
JohnBusiness Consultant (Owner)Commented:
The issue occurs with all the users on your computer and NOT with other computers. I think I summarized this correctly.

So now think of operating system damage and viruses.

1. Open cmd.exe with Run as Administrator. Run SFC /SCANNOW and allow to complete. Close out. Run Windows Updates and then restart. Test.

2. Scan (full scan) for viruses with your own application and then again with Malwarebytes.

There are deeper steps such as a Windows 7 Repair Install, but let's try the above 2 first.
0
QPRAuthor Commented:
Correct, although I am able to RDP to any other server from my (affected) PC

1. Will try this, can't do updates as these are controlled by policy and cannot be applied manually.
2. Will try this also but believe this may also be policy controlled via Sophos network tools
0
JohnBusiness Consultant (Owner)Commented:
Please get your admin to update the computer. There are a lot of updates out there. Also try updating the drivers for your network cards. The machine sounds like it needs servicing.
0
QPRAuthor Commented:
Updates are rolled out weekly via SUS and all workstations (should) be in the same state.
SFC reported no problems.
Am doing a full AV scan now. This will take a while and it is close to knocking off time so I will see the results in the morning.

Other than this single oddity this PC purrs like a kitten.
0
JohnBusiness Consultant (Owner)Commented:
Other than this single oddity this PC purrs like a kitten  <-- Fair enough. I do encourage you to think outside the box. I have clients (all Windows 7 Pro 64-bit) that hang off Server 2008 and 2012 all day long with zero issues.
0
QPRAuthor Commented:
Anti-Virus reports all is fine on the workstation.
We are experiencing a similar problem that maybe unrelated but is too similar to be ignored.
We have some web services on a test IIS server that "talk" to this development SQL box.
These calls to the SQL server (which is the same server I am having issues connecting to) are failing 9/10 times with transport errors about timeouts. This is very similar to the experiences I am having connecting to the problem server.
Other servers/clients are fine. The web services connect to the SQL box using SQL authentication in the connecion string.

Now something else that may be relevant.
Last week I needed to renew my code signing certificate with the domain CA server. I could not do this as the certificate snap-in within MMC said it was unavailable. I spoke to the system engineer and he had a look. His look turned to panic when he realised something bigger was at play. No idea on the tech detail of this side as it is not my area of expertise. He called in the big guns and they got this back up and running apparently.

Now, when I RDP to either the problem or non-problem server I (and others) get an error saying that we have been logged on with a temporary profile. No idea why and this is not normal.
Errors in the app event log on the problem server mention that the certificate cannot be auto enrolled as you are using a temp profile - which I guess is a symptom.

Talking with my colleagues it would appear (at a guess) that our issues started happening around the same time as the certificate server suffered a problem.

I have no idea if this sheds any light or just confuses the original issue!
0
JohnBusiness Consultant (Owner)Commented:
It would appear your code and its environment is the issue and not Windows 7 (which is no issue to any of my clients with a wide range of business software).
0
QPRAuthor Commented:
Not sure I get you, the code scenario is only one of them.
The code has worked 100% communicating and returning results until recently when we now get either success/timeout cannot find server/timeout while handshaking.

The original issue involves me not being able to RDP to a particular windows 2008 R2 server anymore.
An issue that I cannot reproduce on any other client workstation using the same credentials and same remote destination.

This dev webserver is also experiencing similar not found/timeout issue also which is why I brought it into the thread as it *possibly* highlights that the problem is not isolated to my workstation.
0
JohnBusiness Consultant (Owner)Commented:
All I was trying to say is that the problem belongs to you / your shop. It is not a Windows issue so far as I can see.
0
QPRAuthor Commented:
A 3rd party is looking into this today. Suspicions are that it could be certificate confusion between the old and new CA. Will report back
0
QPRAuthor Commented:
Sorry for the delay, forgot to report back.
The system engineer created a group policy entry that would roll out a piece of software to clients. He forgot to exclude servers! Somebody would have RDP's to this server and the install occurred. Subsequently I had this issue.
It had something to do with .NET trust certificates or something, not my area of expertise but as soon as this install was rolled back everything went back to normal. This was the case with both affected servers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.