Re: sql 2000 and sbs 2003

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Dennis,

That should work just fine. As you probably know, the SBS server will need
to be the domain controller and the other Windows Server can be a member
server. I hope this helps. Let me know if you have any other questions.
Thanks!
--
Spencer Ferguson
Wasatch Software
888-275-8850
http://www.wasatchsoftware.com
spencer@xxxxxxxxxxxxxxxxxxx
Microsoft Sales & Open License Experts


"dennis basham" wrote:

> Yes, that is true. We would be using the the 1st sql server for the main
> database for everyone on that network. The second sql server just for the web
> site. No one would be logging in to that server. it would be strickly a
> backend for the web site for our company. I was just wondering if using a
> standard version of server 2003 with sql 2000 on one one server then using
> SBS 2003 permium edition that comes with sbs would cause any problems on the
> network. I am trying not to pay the full price for a standard edition of
> Windows 2003 server and a full price for Standard SQL 2000 Server.
>
> "Andrew J. Kelly" wrote:
>
> > I am not sure what you are asking. You can not share a database between two
> > servers.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "dennis basham" <dennis basham@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:9C8BFF01-0432-4AD0-860B-CD34054587A8@xxxxxxxxxxxxxxxx
> > > We are about to buy a new server. I was wondering that in Small Business
> > > Server premium edition you get Sql server 2000. We already have a server
> > > with
> > > Server 2003 that is running sql server 2000. We plan on using the new
> > > server
> > > for your web server with a backend of sql server 2000. My question is does
> > > anyone see a problem with running sql 2000 on a standard 2003 server and
> > > sql
> > > 2000 on sbs 2003 server with the same database. If we were able to do
> > > this
> > > it would save us a great deal of money.
> > >
> > > Thanks,
> > >
> > > dennis basham
> >
> >
> >
.



Relevant Pages

  • Re: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS migration
    ... Yes, as you know, the Swing migration method specializes in migration from ... SBS 2000 to SBS 2003. ... server and rebuild the new server. ... Install Windows Server 2003 on the new server box (you should use a ...
    (microsoft.public.windows.server.sbs)