Can I install 32-bit SQL2000 on 64-bit W2K3 R2 OS?

Maybe this is a stupid question, but we're ordering a new server, and we get our choice of OS with it. So I'd like to have 64-bit OS if I can.

In the larger plan, is there any problem upgrading from 32-bit SQL2000 to 64-bit SQL2005?

Thanks!!

You can, but SQL 2000 32-bit must be fully patched in order to be stable on 64-bit hardware.

I haven't heard of any issues during migration from 32-bit 2000 to 64-bit 2005. I advise doing that as soon as possible to reap the benefits

-Ryan / Kardax

|||Thank you so much! That was exactly what I needed to know!

can I connect asp 1 to sqlserver 2005

Hi All,
I hopen this isnt a stupid question but can I connect asp 1 to sqlserver 2005? i want to update the database used on a ASP.net 1 project, I seem to be able to get it to connect but cant get it to see the tables?
Thanks for any help
LeeHi,
Were you able to try the connection to an SQL 2000, or other DBMS DB? I'm not up to speed on SQL Server 2005 yet (and as it's still hasn't been released, you may be having a problem peculiar to the beta version. Try posting your connection string (with any sensative parts x'ed out), along with more info on the particulars of your project. It always helps to provide enough information. BRN..|||

Hi Brian,

Thanks for helping!.

the connection string I am using in the web config is
<add key="ConnectionString" value="Server=xxxxx\SQLEXPRESS; Network=DBMSSOCN; Database=xxxxxx; Uid=xxxxx; Pwd=xxxxxx;"/>
SqlConnection sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlDataAdapter xxxxx= new SqlDataAdapter(strSql, sqlConn);

The error I get is
Invalid object name 'tbBob'
I forgot to mention I am using sql server 2005 express
Lee

|||There are two possible reasons for that, one you are in SQL Server Express without the Express Manager installed and two you are in the developer edition without management studio installed. Both are separate install the management studio is under management tools. Try the link below to download what you need. Hope this helps.
http://forums.asp.net/1069636/ShowPost.aspx|||Hi Caddre,
I am confused sorry...I need express manager to run a web page?
The error I get is from a web page .. the database isnt even on the same machine?
Lee|||No you don't need Express manager to run web pages but you need Express manager to manage SQL Server Express and there is no need for the database to be on the same machine. I am sorry did not intend to confuse you. Try the link below for Microsoft provided SQL permissions tutorial. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/paght000010.asp