Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS SQL Server

Posted on 2006-06-25
8
Medium Priority
?
323 Views
Last Modified: 2010-03-19
I need to install MS SQL server on a windows 2003 Server Machine does it come with Small Business Server?
I can't find where to install it.
0
Comment
Question by:jimmysupport
[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
  • 5
  • 3
8 Comments
 
LVL 13

Accepted Solution

by:
itcoza earned 2000 total points
ID: 16980288
Hi jimmysupport,

You need to have purchased The Premium Edition of SBS to allow you to use SQL server on the SBS box.  If you have, you will find a separate CD Named "Premium".
Insert this into the CD/DVD drive to commence the installation.

Regards,
M
0
 
LVL 13

Expert Comment

by:itcoza
ID: 16980293
Hi jimmysupport,

Do you need more information?

Regards,
M

==========================================
  Don't forget to grade and allocate points.
==========================================
0
 

Author Comment

by:jimmysupport
ID: 16980307
So, can I install it separately, I have standard edition. Will it work on this edition?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 13

Expert Comment

by:itcoza
ID: 16980313
itcoza,

I suggest you download SQL 2005 Express edition and rather install that.  The cost of purchase for full version of SQL does not make sense if you are going to install it on the SBS server.  If you plan to install on a member server, that's fine.

*****************************
Regards, M
   
0
 

Author Comment

by:jimmysupport
ID: 16980318
OK M - because I have a copy of Premium with SQL 2000 and service packs to 3. Thought I would use that.
Will the Express Edition work ok for one dtabase I have?
0
 
LVL 13

Expert Comment

by:itcoza
ID: 16980336
Express is great. Make sure you choose the one with all the management components  - the bigger download.

http://msdn.microsoft.com/vstudio/express/sql/download/ 

Choose the optiond on the right of the download options.  234MB as well as the SP1
0
 
LVL 13

Expert Comment

by:itcoza
ID: 16980338
It will work just fine for the DB.
0
 

Author Comment

by:jimmysupport
ID: 16980353
Well, thank you so much for the fast response, and good answer. I have it downloading now.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

604 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