March 3, 2009 at 6:10 am
Greetings all. I am very new to the DB world and because of work related issues I have to do a Sql Server 2008 Standard install. I've been following the MS guides, but I cannot find any information on what the recommended operating system is to use. Lots of operating systems are compatible, but which should I choose?
A little more information: we are a small company developing a web hosted application, hosted live on-site with our own servers and a SQL database back end. The early requirements are very small - this is a small demo project at the moment, but could grow rapidly as we get closer to deploy.
I just want to start off right with the proper operating system. Do you need server based software like server 2008? I have installed Vista Ultimate which is supported. I know the difference between server software and non-server software, but I'm not sure what difference it makes in the SQL world.
Any input most appreciated.
March 3, 2009 at 7:10 am
Vista is fine for individual development efforts, but you'll need a copy of Developer edition to be able to install. Since you're talking SQL Server 2008, your best bet would be to go with Windows Server 2008. Windows Server 2008/SQL Server 2008 together allows for service isolation.
BOL: Setting Up Windows Service Accounts
Read the section entitled Using Service SIDs for SQL Server Service Configurations and you'll see what that gains you.
K. Brian Kelley
@kbriankelley
March 3, 2009 at 7:20 am
I have a copy of Small Business Server 2008. Would this be better than Vista?
March 3, 2009 at 9:19 am
That will bring up a domain, etc. SBS isn't exactly a small undertaking.
K. Brian Kelley
@kbriankelley
March 3, 2009 at 9:51 am
I'm up on servers and have built a server 2008 machine for IIS7. Don't have to install or use active directory, and I didn't on the IIS machine. My big problem is that the server software I have is 64 bit and I'd have to build a new box for it......
Remember Samantha from Bewitched? Just wiggle the nose and it all works.....
March 3, 2009 at 10:31 am
There is a big difference between a regular server build, and a Small Business Server build. SBS is intended to provide an all-in-one solution for smaller than enterprise businesses. This includes Active Directory, Microsoft Exchange, Microsoft SQL Server, and Microsoft SharePoint server, all on one server. Yeah. It is NOT a normal server build. Therefore, you want a regular Standard Edition license and media for Windows Server 2008. x64 bit preferably if the SQL Server version you have is x64.
K. Brian Kelley
@kbriankelley
March 3, 2009 at 10:56 am
Thanks so much for your help. I will not use SBS. In fact, for our current use, I may just leave it as it is.
Now I just have to figure out how to move the database from our development machine, to the new SQL server, attach it (see other post) and configure our web server to talk to the database.
This is a GREAT forum. I am studying like mad to get up to speed with SQL, but have a long way to go.
This help tremendously!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply