Installing SQL 2005

[Jay]

Hi, I just got Vista Biz on my laptop.
I am a seasoned Windows user/developer but brand new to Vista....
I am trying to install SQL 2005 on my laptop. I have the developer
version.
I run setup and I am told that in order to run it I have to run setup
from the command prompt specifying the skuupgrade=1 parameter.
Apparently I already have a verion of SQL installed(!) I am not sure
if this is some trimmed down version that comes with Vista or
something to do with the 101 pre-installed HP utilities that seem to
infest the laptop.

Anyway I do this and I get a warning report to tell me that IIS is not
installed or has been disabled and therefore certain features can't be
installed. I want reporting services!
IIS is installed and service (web publiching) is running. I go to IIS
- default website and the stop option is highlighted (meaning it's
started).

What gives?

Also I still get a warning saying I need to run it with skuupgrade=1
from the prompt... I did that!
I tried setup skuupgrade=1 and setup /skuupgrade=1

Anyone know why vista thinks that IIS is not running and why it
doesn't see I am providing the skuupgrade parameter?

Please note, at this stage the laptop is 100% standalone. The laptop
seems somewhat confused that it could be running without Internet
access as I get prompts left right and centre from apps/utils that
want net access.
Not to mention those irritating little prompts telling me that my
permission is required to allow a program to continue. There is one
user on this laptop. Me - the administrator.
TIA

 

[Mr. Arnold]

I run setup and I am told that in order to run it I have to run setup
from the command prompt specifying the skuupgrade=1 parameter.
Apparently I already have a verion of SQL installed(!) I am not sure
if this is some trimmed down version that comes with Vista or
something to do with the 101 pre-installed HP utilities that seem to
infest the laptop.

Maybe, you need to Run As Administrator, which can be applied to the
Set-up.exe or any program for that matter.

No telling what's on the machine but I would suspect SQL server is not part
of the O/S, like previous versions of the NT based O/S(s). Well, it wasn't
on Vista Ultimate.

http://vistasupport.mvps.org/run_as_administrator.htm

Anyway I do this and I get a warning report to tell me that IIS is not
installed or has been disabled and therefore certain features can't be
installed. I want reporting services!
IIS is installed and service (web publiching) is running. I go to IIS
- default website and the stop option is highlighted (meaning it's
started).

What gives?
http://www.google.com/search?hl=en&q=how+to+install+IIS+7+on+vista&btnG=Google+Search


Also I still get a warning saying I need to run it with skuupgrade=1
from the prompt... I did that!
I tried setup skuupgrade=1 and setup /skuupgrade=1

Anyone know why vista thinks that IIS is not running and why it
doesn't see I am providing the skuupgrade parameter?

Please note, at this stage the laptop is 100% standalone. The laptop
seems somewhat confused that it could be running without Internet
access as I get prompts left right and centre from apps/utils that
want net access.

You have a few things to learn about Vista.

Not to mention those irritating little prompts telling me that my
permission is required to allow a program to continue. There is one
user on this laptop. Me - the administrator.

http://www.jimmah.com/vista/security/uac.aspx

I downloaded SQL Server 2005 Express, VS 2005 Express and installed them on
a pre install Vista Home Premium HP laptop, that didn't have the full
version of IIS 7 running. I upgraded to Ultimate and completed the installs
with no problems.

Vista Business should have the full version of IIS as well.

The best I can tell you is if you have an installation CD/DVD upgrade or
otherwise, then boot off of the CD/DVD, format the HD and lay down Vista
fresh or you may be stuck for awhile.

Your other choice is to get on the phone with HP or MS as you're under
software warrantee with them.With H, you're under warrantee until you
upgrade or replace the existing O/S on the machine. With MS, you have 180
days of support with a retail version of Vista.

 

[Jay]

Maybe, you need to Run As Administrator, which can be applied to the
Set-up.exe or any program for that matter.

I set up 1 user when I first turned it on. Me. When I look at mu user
account it says I am administrator. Should I need to still run as
admin?

No telling what's on the machine but I would suspect SQL server is not part
of the O/S, like previous versions of the NT based O/S(s). Well, it wasn't
on Vista Ultimate.

http://vistasupport.mvps.org/run_as_administrator.htm

You are right. Previously I have always built my PCs from scracth (OS
wise). This is my first purchase of a "brand name" computer. Sometimes
it's hard to tell if HP or Microsoft built this UI

http://www.google.com/search?hl=en&q=how+to+install+IIS+7+on+vista&bt...

Thanks, I'll check that.

You have a few things to learn about Vista.

Indeed. 24 hours ago was my first look at it.
Work will be around 6 months away from upgrading so I'm getting a leg
up.

From a DBA/developer point of view.


http://www.jimmah.com/vista/security/uac.aspx

I downloaded SQL Server 2005 Express, VS 2005 Express and installed them on
a pre install Vista Home Premium HP laptop, that didn't have the full
version of IIS 7 running. I upgraded to Ultimate and completed the installs
with no problems.

Vista Business should have the full version of IIS as well.

It does, and I added it. The service is up and running when I get the
msg from setup that it isn't.

The best I can tell you is if you have an installation CD/DVD upgrade or
otherwise, then boot off of the CD/DVD, format the HD and lay down Vista
fresh or you may be stuck for awhile.

I have an MSDN subscription so I will do exactly that.
The laptop came with vista preinstalled - no disk

 

[Mark Rae]

I have an MSDN subscription so I will do exactly that.
The laptop came with vista preinstalled - no disk

That's definitely the best solution.

FWIW, I have 64-bit SQL Server 2005 Developer Edition running on Vista
Business - haven't had a single issue with it...

 

[Mr. Arnold]

I set up 1 user when I first turned it on. Me. When I look at mu user
account it says I am administrator. Should I need to still run as
admin?

Yes, in some cases like starting the .Net IDE, you need to be running with
Run As Admin checked on via the exe or its short-cut or you won't have the
proper privileges, even if you are Admin on the machine because of UAC.

You can also disable UAC, but that can lead to other applications
terminating because UAC has been disabled.

 

[Larry Maturo]

Hi Jay,

Just to add the the discussion, the "admin" you are logged into
Vista as, does not have full "admin" privelegs in Vista, to protect
you from yourself, so yes, you still need to right click on the exe/msi
file, and select run as admin to really get full admin priveleges.
Although this is somewhat of a pain, once you get used to it, you
don't even think about it anymore.

-- Larry Maturo

 

[Jay]

Hi Jay,

Just to add the the discussion, the "admin" you are logged into
Vista as, does not have full "admin" privelegs in Vista, to protect
you from yourself, so yes, you still need to right click on the exe/msi
file, and select run as admin to really get full admin priveleges.
Although this is somewhat of a pain, once you get used to it, you
don't even think about it anymore.

-- Larry Maturo











- Show quoted text -

Thanks all for your replies, I'll take them all onboard.
Seems Vista is a massive change in a lot of ways from Xp and others!
Not least IIS7.0 - Now *that* is what I call an upgrade!

 

[Jay]

Thanks all for your replies, I'll take them all onboard.
Seems Vista is a massive change in a lot of ways from Xp and others!
Not least IIS7.0 - Now *that* is what I call an upgrade!- Hide quoted text -

- Show quoted text -

Have found my answer SSRS is not "aware" of IIS7 you therefore need to
turn on IIS6 compatibility in Vista prior to the install.