Installing SQL Server Express in Vista 64-bit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Recruiter - 28 Jul 2008 16:23 GMT

My new PC needs to be returned to the manufacturer due to a faulty MB. My PC
runs Vista 32-bit. I will be borrowing a notebook, so I can stay in business
in the interim, but that runs Vista 64bit Home Premium. The business app
runs fine in 32 bit, but needs a workaround in 64-bit. The workaround
requires:
.net 2 framework for 64 bit
.net 3 framework for 64 bit
SQL Server Express 2005
Vista comes with .net 2 & 3. I simply have to be sure .net 3 is on.
When I try to install SQL Express I get stuck on the install. I get to the
point where it shows, "ASP.net Version Registration Requirement (Warning)".
I have tried to install by bypassing this error, but my app won't run
properly.
I have gone to KB 934162 on how to install a 32 bit version of SQL Reporting
Services on a computer running 64-bit Windows.
Unfortunately for me, they are talking about uninstalling the 64-bit
Reporting Services, IIS, enable ASP.net, etc. I'm not too advanced. I don't
know where this info is.
Can someone give me some clear, concise, easy to follow instructions on how
to install it, it would be tremendously appreciated. Thanks.

Reply to this Message

Ekrem Önsoy - 28 Jul 2008 18:06 GMT

Hi,

SQL Server 2005 does not require .Net 3.x (if some of your apps need it,
it's a different story), it needs .Net 2.0 as a system requirement.

"KB934162" is about installing Reporting Services. I think you are trying to
install SQL Server 2005 Express Edition, not the SQL Server 2005 Express
Edition with Advanced Services or Reporting Services of another edition of
SQL Server. So in this case this KB isn't for you.

It seems you are trying to install a x86 version of SQL Server 2005 Instance
then I think you'll need an x86 version of .Net Framework 2.0 installed on
that (x64) machine as well. Do you have it installed? (Unfortunately I don't
have an x64 test machine to test it...)

And I'll suggest you to read the following blog (Not tested by me yet):
http://www.tryexcept.com/articles/2007/07/18/installing-sql-server-2005-express-
in-windows-vista.html

Signature

Ekrem Önsoy

> My new PC needs to be returned to the manufacturer due to a faulty MB. My
> PC
[quoted text clipped - 23 lines]
> how
> to install it, it would be tremendously appreciated. Thanks.

Reply to this Message

Recruiter - 28 Jul 2008 19:19 GMT

> Hi,
>
[quoted text clipped - 41 lines]
> > how
> > to install it, it would be tremendously appreciated. Thanks.

My business app requires both .net 2 & 3 to operate with a 64 bit OS. .Net 2
for 64-bit comes preinstalled, and I simply need to turn on all the .net 3
features. I am not sure if it needs Advanced Services and Reporting Services
or not. I haven't been able to get that far yet with the install. My 32bit
app shows, under sql server, Configuration Manager, Error and Usage
Reporting, and Surface area Configuration.
The link the software company supplies is to:
SQL Express 2005 64-bit version
sqlexpr.exe from the Microsoft website @ 55.3 MB in size.
Tonight, I'll check the Windows features to make sure the instances need
are turned on, based on the article I was sent to. I am wondering about the
command line they show. He suggests "cscript
%SystemDrive%inetpubAdminScriptsadsutil.vbs set
w3svc/AppPools/Enable32bitAppOnWin64 1".
According to the Microsoft KB I was using, the command line should be
"cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set
w3svc/AppPools/Enable32bitAppOnWin64 1". Which one is correct? Thanks again.

Reply to this Message

Ekrem Önsoy - 28 Jul 2008 20:57 GMT

"cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set
w3svc/AppPools/Enable32bitAppOnWin64 1

This must be the correct one. Because apperantly "inetpub" is a directory
used by IIS and you must use back slashes to seperate folders in a path.

Signature

Ekrem Önsoy

>> Hi,
>>
[quoted text clipped - 71 lines]
> w3svc/AppPools/Enable32bitAppOnWin64 1". Which one is correct? Thanks
> again.

Reply to this Message

Recruiter - 28 Jul 2008 21:08 GMT

Thanks:
I'll give it a try tonight

> "cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set
> w3svc/AppPools/Enable32bitAppOnWin64 1
[quoted text clipped - 77 lines]
> > w3svc/AppPools/Enable32bitAppOnWin64 1". Which one is correct? Thanks
> > again.

Reply to this Message

Recruiter - 29 Jul 2008 02:06 GMT

I tried to install it, and it wouldn't go through. I ran the command line,
and got the following error message:
Permission denied
ErrNumber: 70 <0x46>
Error Trying To Get the Object: w3svc/AppPools
On a whim, I tried to see if I could get anywhere with the install, but got
to the same point:
ASP.net Version Registration Requirement (Warning)
It seems I'm back to where I started from. Is there anything else I can do?

> Thanks:
> I'll give it a try tonight
[quoted text clipped - 80 lines]
> > > w3svc/AppPools/Enable32bitAppOnWin64 1". Which one is correct? Thanks
> > > again.

Reply to this Message

Ekrem Önsoy - 29 Jul 2008 08:42 GMT

When I see a warning\error in Windows Vista, it makes me believe it has
something to do with Vista' s User Access Control. Is this feature of Vista
enabled? This feature might be the responsible for this error.

Signature

Ekrem Önsoy

>I tried to install it, and it wouldn't go through. I ran the command line,
> and got the following error message:
[quoted text clipped - 117 lines]
>> > > Thanks
>> > > again.

Reply to this Message

Recruiter - 29 Jul 2008 15:07 GMT

Hoorah!! It finally worked. I've been trying for almost a week on this.
I disabled the User Access Control, but I also thought of something else.
When I went to the command line, I simply ran the command at the prompt.
This time, since it would keep coming through as access denied, I ran it as
Administratrator. I don't know which one finally was the key, all I know is,
it flew right through it. Thanks for all your help!

> When I see a warning\error in Windows Vista, it makes me believe it has
> something to do with Vista' s User Access Control. Is this feature of Vista
[quoted text clipped - 121 lines]
> >> > > Thanks
> >> > > again.

Reply to this Message