Solved

SBS 2003 R2 Premium edition and SQL installation

Posted on 2007-11-28
5
2,377 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server how to create a DYNAMIC TABLE? 11 50
semaphore timeout period has expired 1 28
mssql 7 32
SQL Server Pivot 5 39
I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 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