Small Business Server 2003

Question

May have bought the wrong OS. I got a new Poweredge with SBS2003 for the purpose of running Sql Server. It is currently running on Win2000. The network is a small workgroup - don't need a domain controller. Also don't need a dns server, an exchange server or any of the rest of the bells and whistles. If I try to demote the server to a standalone, it wants to shut down with an error - must be a domain controller.   What are my options? I need this machine to be on the same workgroup as some robotics that will be hitting the sql server. I dont' mind that it's a PDC if it will still work as I need it.   Any help appreciated.

Eric BY · Answer

I believe you may have purchased the wrong operating system if you only need a member server w/ SQL server only. I would recommend contacting customer service and working out a solution with them.

helmecj01 · Answer

http://www.systematic.com.hk/course/images/bar/course/mcitp/mcts_big.gif

helmecj01 · Answer

What version of Sql Server ??? http://msdn2.microsoft.com/en-us/library/ms143719.aspx http://msdn2.microsoft.com/en-us/library/ms143516.aspx

helmecj01 · Answer

hi   you wil need a domain controller and DNS server   Server1 Domain Controller (Active Directory) DNS   Server 2 install Sql   Server 3 files server

dbvirago · Answer

Thanks. I will contact them next week.

dbvirago · Answer

I need a domain controller if I have a domain. This is just a workgroup. No server, no logins. I now have 2 machines running win2K. Neither is a domain controller. Both are running SQL Server 2K.

dbvirago · Answer

SQL server 2000

rayaa3 · Answer

you definitely have the wrong OS -   SBS is designed to be a DC - in a single DC domain.  If you don't need a domain - then you bought a lot more software than you need.  What's more - I don't think sbs can be configured as a workgroup (non-dc).    You might benefit from a domain - but if you definitely don't want one, you've got the wrong OS.   Ray

Bernie321 · Answer

Although if you are a small workgroup SBS 2003 Premium Edition should be cheaper than Windows Server 2003 Standard + SQL Server 2000 Standard Licences.   I have never done this but you should be able disable the Exchange Services (to free up ram) allow file server access and SQL Server access to non-authenticated users and will give you room to grow if you need the other SBS Services.   Regards B Message Edited by Bernie321 on 12-07-200612:25 PM

dbvirago · Answer

Thanks, that's what I'm planning depending on what Dell gets back to me with. We already owned Sql server 2000. Being removed from an old Win2K machine and loaded onto new server. Disabling Exchange wasn't a problem.   Thanks all

PowerEdge OS Forum

Was this post helpful?