Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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.
0
rljack01
Asked:
rljack01
  • 3
  • 2
1 Solution
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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