SQL 2005 on Server 2008 R2 not finding instances

  • Greetings all,

    New to this site and it looks like just the place I need to ask about this problem.

    Little background on the problem. We had an old server that was running Windows Server 2003 and on it had our TimeClock Plus program, which had a SQL 2005 instance on it. It worked all fine and dandy, but about 2 weeks ago the RAID controller went totally belly up. So we invested in a new server for the company and decided to do a bit of upgrading. Got a nice Dell PowerEdge 2950, installed Windows Server 2008 R2 64-bit on it. Everything was going along well till we tried to install the timeclock software, it gagged saying it wanted 64-bit SQL. OK. Got that installed, got the SQL database transferred without a problem, and everything works fine on the server. It even has no problems with the 3 remote timeclocks where people punch in and out.

    Problem I am having is, nobody can remote connect to the SQL instance. I have set the firewall ports 1433, 1434, and 1711 (saw this one elsewhere on these forums) open. I have made sure it's enabled via TCP/IP. I have tried turning the firewall completely off (just to test) and still nothing.

    Now comes the fun part. On my desktop computer, which is Windows 7 Pro 64-bit, I can go to the ODBC Data Source Administrator and try to connect to the SQL it comes in both 64-bit and 32-bit. On the 64-bit version I can connect to the instance with no problems, the 32-bit it connection fails with:

    Please, if anyone can help me to get past this it would be most appreciated. I am sure it's probably something so simple.

    Thank you,

    Jeremy Armer

  • Just wanted to reply. Think I got it solved myself. A few more hours of mucking around in server's newer firewall and it magically turned on about 20 minutes ago.

    Added the dynamic ports, SQL Server exe and SQL Browser exe to the firewall. And also adjusted a few settings in the TCP/IP settings of the SQL Instance. I don't think the latter did much, but as it is working.. I am so not changing them back at this point. 😀

  • glad it's working for you. Usually if you install with defaults, the firewall isn't too much of an issue, but it can be frustrating to get it working.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply