Detailed process to integrate MS SBS Premium and MS SQL 2005 requested.

How do I integrate Microsoft Small Business Server 2003 Premium Edition and Microsoft SQL 2005 Standard Edition?

Please provide reference sources to step by step procedures.

I'm new at this. Today will be my 1st SBS install for my SB.

Thanks.
LVL 1
rljack01Asked:
Who is Participating?
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0
 
NJComputerNetworksCommented:
When you buy SBS 2003, you get SQL 2000 with the server software.  This is automatically part of your purchase...  However, if you want to use SQL 2005 instead, then I would suggest placing this on a seperate server.
0
 
rljack01Author Commented:
I want to be able to access the SQL 2k5 DB remotely.
Then, how would one tie SQL 2k5 to SBS 2k3 Premium.

SBS 2003 r2 Premium was released by MS on June 5th I learned from an MS  rep. (I don't think that it will available in the channel until sometime in July) It has SQL 2k5 Workgroup Edition integrated with it.  Perhaps I should look into the upgrade path -- cost or free?????
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
NJComputerNetworksCommented:
Not sure about the upgrade path...  

Do you have another server?  You can buy SQL 2005 and install it on this server.  Access remotely could be obtained by remote Desktop to the server directly (port 3389 has to open through your firewall).  Or you can open firewall ports up through your firewall to access the database directly.
0
 
rljack01Author Commented:
SBS 2k3 Premium to SBS 2k3 r2 Premium upgrade Path:

http://www.microsoft.com/windowsserver2003/sbs/r2/upgrade.mspx
0
 
NJComputerNetworksCommented:
very good link rljack01...  Yes, I believe that this is your most straight forward option for getting SQL 2005 in your environment.  http://www.microsoft.com/windowsserver2003/sbs/r2/features.mspx  (more info about the feature of SBS R2)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.