64 bit version to host a .net application 1

[bjb123]

Yesterday I ordered a new Dell Power Edge 2900 that comes with a Standard Windows 2003 R2 64x OS and SQL 2005 64 bit. They shipped it today.

The application provider is giving me a hard time because they don't list the 64 bit SQL Server as supported, they do list a 64 bit OS as OK. Absolutely my fault for not paying close enough attention to that.

Is there some kind of issue I'm not aware of that would make them hesitant about the 64 bit version of SQL Server 2005?

If I end up having to get the 32 bit SQL server installed on here will I be able to take advantage of the additional RAM that the 64 bit OS allows or will it be capped at 4GB like the 32 bit version of Standard Window Server 2003?

 

[bjb123]

I forgot to mention that the application is a windows forms .exe written in VB 2005 which will operate on the local workstations, not the server.

 

[mrdenny]

The only real issues with SQL 2005 64bit vs. 32bit is that the 64bit doesn't support SQL Mail, and there can be some issues with SSIS when trying to use the Jet driver to connect to Access, Excel etc. Other than that there shouldn't be any issues.

What Edition of SQL 2005 did you get? If you got Standard Edition SQL will still only use 4 Gigs of RAM. That's a licensing limit not an architecture limit.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bjb123]

We should be fine without SQL Mail, no legacy settings to worry about. Same with SSIS, at present.

It is Standard Edition of SQL Server 2005.

Here is a link to why I am under the impression that the Standard SQL Server 2005 would go to whatever the OS Maximum:

sqlblogcast
Microsoft Product Info


I thought that with the 64 bit system I found an economical way to get a very powerful server with a lot of RAM without needing the Enterprise versions of the OS and SQL Server.

Would there be any issues with running a 32 bit SQL Server on the 64 bit OS if it comes to that?

 

[mrdenny]

I'm thinking of the Standard edition on Windows Standard which would give you a 4 Gig limit. Sorry about that.

There shouldn't be any problem installing a 32bit SQL on 64bit Windows.

If you have to install 32bit SQL you may want to install 32bit Windows as well.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bjb123]

Thanks Denny.

We've had the 64bit up and running in a test environment for a few weeks now and everything is working great.