• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

How do I get the SQL Server up and running on SBS 2003 Premium?

I recently installed SBS 2003 Premium but didn't install the SQL Monitor nor Sharepoint.  The SQL Server icon is in the system tray with no server name or default service.  How do I get these SQL services started post install?  And how do I install other applications that require a SQL database?  (I know this sounds like a dumb question, but SBS is a lot different than the real thing.).  Is it possible to use MS SQL Server Express 2005 if I should choose to do so?  
0
lasthope
Asked:
lasthope
  • 3
  • 3
1 Solution
 
dhoustonieCommented:
If you purchased the OEM version of SBS 2003 after March 1st you'll be able to upgrade to SBS 2003 R2 with SQL2005 Workgroup Edition when it has finished beta.
Did you install SQL from the Premium technologies disk? Disk 5 in the original media or disk 6 in the Service Pack One media.
To install SQL, it is not part of the normal install procedure so you have to install it after you have finished installing SBS. Full details are included on the Premium technologies disk to install as Best Practice.
The icon is most likely just a single instance of SQL Desktop Edition, which could have been installed by a number of products. If you look in service for a MSSL$**** where **** is an instance name.
In the app beside the clock use SBSServerName\**** and you will connect to the instance of SQL.
If you have SQL 2000 server why do you want to use SQL 2005 Express where you do not have all the features?


Hope this helps,

David
0
 
lasthopeAuthor Commented:
The SBS 2003 Server Premiun Edition was purchased with the Dell server.  No CD's.  The SQL service manager is in the system tray next to the clock, but it does not provide the server name as an instance to connect too.  This is the problem and I don't know why.  

The typical MSSQL$SBSMonitoring and MSSQL$Sharepoint, and SQLAgent$SBSMonitoring and SQLAgent$Sharepoint SBS2003 services are displayed, but will not start (they are not disabled).  I'm not sure how to deternime if SQL Sever is installed nor how to install it if it isn't.  I don't have the CD's.

 
0
 
dhoustonieCommented:
If it was purchased from Dell, Dell are obliged to give you the disks, it is part of the condition of sale, so I would get onto them and give them hell.
Oka you currently have an msde instance installed to access it from the SQL service manager you should use the server name SBS\Sharepoint.

Too check if SQL is installed there should be a folder in the start menu for the SQL tools. It sounds as if it may not have been installed if those are the only services.

Could you list all the programs installed in Add/Remove Programs?

Thanks,

David
0
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!

 
lasthopeAuthor Commented:
Add/Remove has the MSDE's for SharePoint and Monitoring.  Does not have SQL 2000, nor is the SQL admin in the programs list.

I cannot find the SQL Server install on the server itself, so I assume I need the CD's which were not included.

I will contact Dell to find out why?

Thanks, I'll get back with you on what I find out.
0
 
dhoustonieCommented:
You should have received the media as it is to be shipped with all machines installed with a Microsoft Product.
I'll assume that they do not have ISA installed either, it would be under Programs.
Is there a Certificate OF Authenicity on the Dell Server?
The sticker with the product code?
If not there should have been one, again this is part of the criteria Microsoft has put down to OEMs to ensure against software piracy.

Hope this helps,

David
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
As you can see from this document, the CD's should be there:  http://support.dell.com/support/edocs/software/wsbs_sp1/multlang/Premapps/PremApps0.pdf

The official document on how to install premium parts of SBS is here:  
http://www.microsoft.com/downloads/details.aspx?FamilyId=87A48D35-54AB-4F63-90A3-A884311202E1&displaylang=en

Jeff
TechSoEasy
0
 
lasthopeAuthor Commented:
David,

I finally figured it out.  The SQL server installation is on the Service Pack CD (not sure what the logic is).  (50 pts)

TechSoEasy,

The link to the installation instructions was very helpful.  (75 pts).

Thank you both for your assistance!  I hope this point split is OK with everyone.



0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now