installing 64bit SQL2000 EE on 32-bit Windows 2003 Enterprise server

Will my SQL server work like 32-bit or 64-bit if I installed 64bit SQL2000 EE on 32-bit Windows 2003 Enterprise server?
Did it install ? I don't think it should.Certainly doesn't on my PC
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dipesh" <anonymous@.discussions.microsoft.com> wrote in message
news:8C50C76F-8EF4-4B09-BB17-4A7FABEE5B1E@.microsoft.com...
> Will my SQL server work like 32-bit or 64-bit if I installed 64bit SQL2000
EE on 32-bit Windows 2003 Enterprise server?
>
|||It installed fine. I am just concerned about if 64-bit functionality will be available to me or not. Is there a way to verify.

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

I am in the process of installing SQL 2005 on a new server that is also going to have MS CRM 3.0 installed

CRM needs the .net 1.1 which has you run "cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1"

I installed .net 1.1 32-Bit and 2.0 64-Bit on the server. Then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

During the initial stages of the SQL install I receive the foloowing warning:

- ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit).

Do I need to run cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0 before the install of SQL and then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 after?

Or do I need to install SQL 2005 64-bit without reporting services and then install SQL 2005 32-bit reporting services on the same server?

Here is a thread containing a workaround (including your cmd line questions). My guess is that you'll want to run them both and then launch the installer again.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=798330&SiteID=17

Thanks,
Sam Lester (MSFT)

Installing 64-Bit SQL 2005 on a 64-Bit server which needs .net 1.1 for CRM installed.

I am in the process of installing SQL 2005 on a new server that is also going to have MS CRM 3.0 installed

CRM needs the .net 1.1 which has you run "cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1"

I installed .net 1.1 32-Bit and 2.0 64-Bit on the server. Then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

During the initial stages of the SQL install I receive the foloowing warning:

- ASP.Net Version Registration Requirement (Warning)

Messages

ASP.Net Version Registration Requirement

32-bit ASP.Net is Registered. Required 64-bit ASP.Net to install Microsoft Reporting Services 2005(64-bit).

Do I need to run cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0 before the install of SQL and then cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 after?

Or do I need to install SQL 2005 64-bit without reporting services and then install SQL 2005 32-bit reporting services on the same server?

Here is a thread containing a workaround (including your cmd line questions). My guess is that you'll want to run them both and then launch the installer again.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=798330&SiteID=17

Thanks,
Sam Lester (MSFT)