Solved

SBS 2003 R2 Premium edition and SQL installation

Posted on 2007-11-28
5
2,372 Views
Last Modified: 2008-03-10
I have purchased SBS 2003 R2 Premium edition and have the disks on hand.  I am in the process of trying to install SQL 2005 edition that is on the Premium technologies disk.  I assumed when i autoran the premium technologies disk it would have a screen where i could click install SQL 2005 or something to that effect.  It didnt.  On the disk if i browse it, there is disk 1 and disk 2.  In each there are two executables for SQL and the one on disk 1 asks for a cd key and the other one doesnt.  Which one is the proper one to use and should my disk have an install sql 2005 on the autorun menu of the disk?

Any info would be appreciated.
0
Comment
Question by:msha094
  • 3
5 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20364838
please search disk 1 for "SQLinstallsteps.htm", i think it was in the root folder
the steps are straightforward
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20364848
and yes you are right, the autorun should have it

To install a new instance of SQL Server 2005 Workgroup Edition

From the Autorun page of the Premium Technologies disc (D:\Setup.exe, where D is the letter of your CD drive), click Install Microsoft SQL Server 2005.
0
 

Author Comment

by:msha094
ID: 20368342
And should it ask me for my cd key? and if so the windows server cd key should work right?
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20368610
no it should pre-populate that information for you. check this link

http://support.microsoft.com/kb/924000

are you using the latest release media?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 20402115
That KB article is only for those who have installed the initial release of SBS 2003 R2 which had a bug in SQL Server 2005.  The actual documenation for this is here:  http://download.microsoft.com/download/4/0/8/40860507-c351-4308-a876-e1b83ee4e77a/sqlinstallsteps.htm

But just to clarify the confusion about the 2 disks, Premium Technologies Disk 1 has ISA2004 and SQL2005.  Premium Technologies Disk 2 has just the SQL Server 2005 Tools on it.  You need to be using Disk 1, and run the setup.exe from the root directory.  Then choose Install Microsoft SQL Server 2005.  The Key will auto-populate for you.  If it doesn't, you need to contact Microsoft Product Support for assistance.

Disk 2, by the way, doesn't even have a key.

Jeff
TechSoEasy
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question