2005 on 2008(OS)

Question

2005 on 2008(OS)

Viewing 7 posts - 16 through 21 (of 21 total)

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

EdVassie SSC Guru Points: 60481 More actions · Answer 1

The warning is because SQL Server 2005 does not recognize W2K8.

The situation is the other way round. W2008 is throwing this message out because SQL 2005 RTM is known to be not fully compatible with W2008.

But as you point out, this makes no difference to the solution - install SQL 2005 then apply SP3.

When you do the SQL 2005 install, some registry entries are created by W2008 Program Compatibility Assistant to prevent the compatibility message appearing the next time you do a SQL 2005 install on the same box. If you want you can add these values to the registry before you do a SQL 2005 install, then you get no messages - this can be useful if you want to do an unattended install. I have taken this approach (update the registry) in FineBuild, so that SQL 2005 installs silently on W2008 and W2008 R2.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Tara-1044200 SSCoach Points: 15951 More actions · Answer 2

guys.. I am using dedicated ports, installed SP3 already but still not able to connect.

EdVassie SSC Guru Points: 60481 More actions · Answer 3

Have you opened ports in your firewall?

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

paul.knibbs SSCoach Points: 15320 More actions · Answer 4

I would suggest firewall as well--the one in 2008 R2 is quite a bit more complex than the one from 2003 (and I think the one in 2003 was turned off by default anyway, but I could be wrong on that).

Tara-1044200 SSCoach Points: 15951 More actions · Answer 5

does that mean i have to turn off firewall? which firewall Doamin,Home or Public?

Steve Jones - SSC Editor SSC Guru Points: 736642 More actions · Answer 6

Do not turn off the firewall. That's not the solution. On the computer with a SQL Server instance, you can open ports 1433, 1434 for connectivity. Or ask the firewall to notify you when a request comes through (need to be logged onto that server) and open the ports.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 7

1. Is it a named instance and Is the Browser Service running on the server ?

2. Or Are you specifying the Port number when connecting to the SQL Server instance ?

Pls let us know..

Thank You,

Best Regards,

SQLBuddy