sbs2003 but NOT domain server?!!

osaddictosaddict London, UK
edited October 2006 in Science & Tech
Hey all,

We have a nice new server comming in the next week or so.

Due to time and budget constraints (and instruction from above) we are not going to go for a domain server. (I know many of you think this is crazy, and a waste of a server- I kinda do too- but hey, my hands are tied, pretty much)

So...

How would I go about setting up this box with sbs2003 premium to literally just be a central file store?

Presumably thats pretty straight forward?-- Choose certain folders on the drives- choose to share them and then map them on the clients?

We will also be running sql on it too- just for 2 clients to connect to- I guess migrating that over from the existing server and from 2000 to 2005 could be a bit tricky...

Comments

  • ShortyShorty Manchester, UK Icrontian
    edited October 2006
    I wouldn't even bother to get SBS if you are only gonna run a file server off it, XP could do that :)

    SBS doesn't come with SQL Server 2005, so Im assuming you are buying that seperately..?

    Migrating from 2000 to 2005 is easy. There are multiple ways, backup/restore through SQL Enterprise manager... replication between boxes, restore to 2005 and use log shipping to keep them in sync. Id try option 1 first. Run the 2005 server in 2000 compatibility mode ;)
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited October 2006
    sbs2003 just automatically installs a domain.
  • osaddictosaddict London, UK
    edited October 2006
    It does come with sql server if you get the premium edition and its R2...

    SQL 2005 Workrgroup edition.

    I am guessng that if I just select a folder choose to share it, then make sure everyone has permissions to access it, map it from their pc's etc it should work fine.

    (Yes, SBS is not really needed for this- but it is for the SQL side of things for us)
  • ShortyShorty Manchester, UK Icrontian
    edited October 2006
    What version of SQL Server 2000 do you currently have..? Why do they want to change to 2005..?

    Once you have bought SQL 2000 licenses, they are yours. Changing to 2005 won't bring huge amounts of improvements unless you are going to utilize the new "enterprise" tools and options :)
  • osaddictosaddict London, UK
    edited October 2006
    sql 2000 at the moment, with me running a demo version of 2005,

    as i type this post- dell have just delivered (read 'thrown') the new server and a heap of flatscreens in to the office...

    the fun begins...
Sign In or Register to comment.