August 2009 Archives

Getting Connected

| 1 Comment | No TrackBacks

Another day lost. As many times as I’ve helped others get connected, nothing worked today as I tried to connect from one system in a Workgroup to a SQL Server on a local (trusted) domain. I tried everything imaginable including:

  • Checking to see it the server properties were set to permit remote connections. They were.
  • Was the SQL Browser service running? It was.
  • Did the SQL Server Configuration Manager say that the right protocols were enabled? Yes, they were.
  • I tried to Telnet to the IP address and port being used (based on SSCM). It worked locally but not over the network.
  • I stopped the Windows Firewall service as I was running Small Business Service and it thinks it knows best about configuring client firewalls (despite the fact that I have other firewall hardware). That made no difference.

Nothing made any difference. I could not connect from other domain-based systems either. The rest of the story? Well, I remembered having installed Windows 7 on top of an existing Windows Vista system. I had assumed that it had joined the SBS domain correctly (I ran “Connect” which was supposed to do that). Apparently it didn’t. When I dropped the offending system from the domain, went into SBS, dropped the system there, and rejoined the domain it worked fine. Everyone could see the SQL Server. That only took 6 hours of fiddling to figure out. I’m hesitant to run connect again…

Sigh. How does anyone get any work done if all we do is frutz with systems?

Bill

After updating a working Vista system to Windows 7 several things happened that made what seemed like an easy transition to Windows 7 from Vista less than productive. I detail these issues to help you avoid the same issues. Yes, Windows 7 is worth the pain. It’s noticeably faster at every step, the UI is different but I get it. It’s more secure, but that’s a PIA sometimes—and that’s not a Primary Interop Assembly.

Pages

Powered by Movable Type 4.21-en

About this Archive

This page is an archive of entries from August 2009 listed from newest to oldest.

June 2009 is the previous archive.

September 2009 is the next archive.

Find recent content on the main index or look in the archives to find all content.