SQL 2005 std.edition 64 bit on Windows Server 2008 std. 64 bit

Question

SQL 2005 std.edition 64 bit on Windows Server 2008 std. 64 bit

kenneth.knudsen

SSC Enthusiast

Points: 155
More actions
October 27, 2008 at 8:48 am

#195076

has anybody in this SQL forum any experience with the following config:
SQL 2005 std.edition 64 bit on Windows Server 2008 std. 64 bit ?
Are the any cathes - special considerations to knopw about?
is this a safe SQL design?
regards
Ken

Viewing 5 posts - 1 through 4 (of 4 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

What do you mean "safe?"

It works, more and more people running 64-bit every day. There are issues with some subsystems (SQLMail, SSIS), where things could have issues moving to 64-bit. Some things weren't designed to move, but most of the basic services work the same.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

make sure that any 3rd party ODBC drivers you intend to use are 64-bit.

You can install 32bit drivers on Win64 (odbcad32.exe)..but SQL64 will not be able to use them.

regards gah

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Andrew..Peterson SSCertifiable Points: 6838 More actions · Answer 3

Have not yet done any setup with Windows Server 2008.

We do have SQL 2005 x64 on WS2003 x64. Works great.

The more you are prepared, the less you need it.

tpalmer SSC Eights! Points: 962 More actions · Answer 4

I believe the question is no so much about 64 bit SQL. The question as I read it: is running an older version of SQL (SQL 2005) on the newer OS (Win2008 R2) stable or recommended? Has anyone seen any issues or nuances with the build that people have experienced?