SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Installing SQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cnm
Starting Member

2 Posts

Posted - 03/10/2007 :  04:04:11  Show Profile  Reply with Quote
I tried installing SQL Server 2005 for educational purposes.
When I double cliked Setup.exe I get the messege "You computer does not meet service pack levels ....."

I use Windows XP Professional Service PAck 2

what could be the reason

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/10/2007 :  04:29:24  Show Profile  Reply with Quote
Might it be the "Valid legitimate copy of Windows" thingie is missing (sorry, can't remember its name, but it was part of Windows Update in the last 6 months or so)

I've been impressed with the depth of messages that SQL Server 2005 Installer gives - is there no more details explanation of the problem - perhaps some sort of "Click here to se4e more details" type button/link?

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 03/10/2007 :  16:06:01  Show Profile  Visit tkizer's Homepage  Reply with Quote
What version of SQL Server did you try to install? For XP, I'd recommend Developer Edition.

Kristen,

The details are typically in the setup logs. It gives the path to the logs at the end when the installation fails.

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/11/2007 :  01:09:57  Show Profile  Reply with Quote
Thanks Tara. Was there an installation option that I missed about the location for MDF/LDF? I've changed it post-install, but in SQL 2000 there was an option during install.

I'd like to be able to change the location of Backup files too ... each time I do a Restore (SSMS) I have to wait whilst it draws a detailed tree of the default location - which I don't actually want!

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 03/11/2007 :  18:26:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
It doesn't allow you to change that option through the GUI installation. I wonder if it would allow you to change it if you used an unattended installation though, not sure. We just put the system databases at DriverLetter:\MSSQL.n\Data\. Then we put our user databases elsewhere. I guess if you didn't like the path for the system databases, you could move them using that detach/attach MS article.

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/12/2007 :  13:11:12  Show Profile  Reply with Quote
I think I found it ...

... in the "Feature Selection" if you go to Advanced (to choose more specifically WHICH features are required) there is a "Browse" for the path of each item - and amongst all the programmy-things is

Database Services : Data files

and the path can be changed independently of the "program files" EXE-type stuff.

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 03/12/2007 :  14:13:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
Right, but it doesn't allow you to pick exactly which folder to put the files in. It will do this:

DriverLetterYouPicked:\PathYouPicked...\MSSQL.n\Data
So the MSSQL.n\Data is forced upon you.

This is why we just put DriverLetter:\ in the installation. We don't want any extra folders to have to weed through.

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/12/2007 :  22:13:28  Show Profile  Reply with Quote
So I found ...

... mind you, this used to catch me out under SQL 2000 too!

So I now have F:\MSSQL\DATA\... (which I provided) ...\MSSQL.1\MSSQL\Data

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 03/13/2007 :  12:56:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
Uninstall/reinstall!

That's what I've had to do on the very first installation of SQL Server 2000 and SQL Server 2005 to determine exactly what path it uses and what I need to provide during the installation to cut the path down.

We provide DriverLetter:\ only for both 2000 and 2005.

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/13/2007 :  14:41:00  Show Profile  Reply with Quote
You are right I remember doing this with SQL 2000 too ... we had x:\MSSQL\MSSQL\...

It would be handy if there was a note at that point about the Child folders that were going to be created

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35935 Posts

Posted - 03/13/2007 :  14:46:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'm sure it's documented somewhere, but who the heck reads the documentation for an installation!

Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/13/2007 :  14:49:17  Show Profile  Reply with Quote
The rest of were all assuming that you did, and could answer our damn-fool question!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000