SBS 2003http://192.168.2.20/forums/7.aspxCommunityServer 2008.5 SP2 (Build: 40407.4157)Re: How to upgrade Sql Server 2005 Workgroup to Standard version in SBS Server 2003 Premiumhttp://192.168.2.20/forums/thread/4749.aspxWed, 12 Sep 2007 09:48:51 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:4749Clinton Grant0http://192.168.2.20/forums/thread/4749.aspxhttp://192.168.2.20/forums/commentrss.aspx?SectionID=7&PostID=4749<p>hi david</p> <p>So then from a risk assessment point of view it would be better for me to get an addition Server&nbsp; as a windows 2003 STD member and migrate the Databases across</p><div style="clear:both;"></div>Re: How to upgrade Sql Server 2005 Workgroup to Standard version in SBS Server 2003 Premiumhttp://192.168.2.20/forums/thread/4748.aspxWed, 12 Sep 2007 08:29:42 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:4748David Overton0http://192.168.2.20/forums/thread/4748.aspxhttp://192.168.2.20/forums/commentrss.aspx?SectionID=7&PostID=4748<p>SQL 2005 Std should work on SBS, but it is not a SBS option, so you would have to buy SQL Std and CALs (or per proc licensing).&nbsp; When you install SQL, unless you give it an existing instance name, it does NOT upgrade the existing databases.</p> <p>&nbsp;</p> <p>ttfn</p> <p>David</p><div style="clear:both;"></div>Re: How to upgrade Sql Server 2005 Workgroup to Standard version in SBS Server 2003 Premiumhttp://192.168.2.20/forums/thread/4746.aspxWed, 12 Sep 2007 08:05:19 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:4746Clinton Grant0http://192.168.2.20/forums/thread/4746.aspxhttp://192.168.2.20/forums/commentrss.aspx?SectionID=7&PostID=4746<p>Hi David</p> <p>&nbsp;Just wanted to say this is a wonderful site. Anyway my question to you is in your above statement you mentioned &quot;SBS R2 support SQL 2005 Workgroup Edition&quot; does this mean this version of sbs only supports workgroup edition and not standard? Second question is I have a SBS 2003 Premuim Server with ISA Server and sharepoint and Backup Exec&nbsp;installed will&nbsp;this automatically upgrade these databases or will there be a risk factor where SBS 2003 R2 Premuim Technologies will be incompaitable?</p> <p>Regards</p> <p>Clinton</p><div style="clear:both;"></div>Re: How to upgrade Sql Server 2005 Workgroup to Standard version in SBS Server 2003 Premiumhttp://192.168.2.20/forums/thread/3725.aspxSun, 13 May 2007 11:46:06 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:3725David Overton0http://192.168.2.20/forums/thread/3725.aspxhttp://192.168.2.20/forums/commentrss.aspx?SectionID=7&PostID=3725<p>Technically I am not aware of any difficulties, however....</p> <ul> <li> <div>SBS 2003 R2 support SQL 2005 Workgroup Edition</div></li> <li> <div>Your SBS Licenses will not cover your SQL installation</div></li> <li> <div>You can not update all databases as some applications require SQL 2000 / MSDE still</div></li></ul> <p>Other than that you are fine.&nbsp; I had SQL 2005 running on my server before I moved it to a R2 system.</p> <p>&nbsp;</p> <p>ttfn</p> <p>&nbsp;</p> <p>David</p><div style="clear:both;"></div>How to upgrade Sql Server 2005 Workgroup to Standard version in SBS Server 2003 Premiumhttp://192.168.2.20/forums/thread/3177.aspxMon, 12 Mar 2007 22:53:04 GMT72050d9c-4f41-4a16-9f70-ebbf2c98a2c7:3177sqllady0http://192.168.2.20/forums/thread/3177.aspxhttp://192.168.2.20/forums/commentrss.aspx?SectionID=7&PostID=3177<P>Hello,</P> <P>&nbsp;</P> <P>&nbsp;&nbsp; <img src="http://uksbsguy.com/emoticons/emotion-2.gif" alt="Big Smile" />Has anyone upgraded Sql Server 2005 Workgroup edition to Sql Server 'STANDARD' edition in SBS Server 2003 premium?&nbsp; If so, any</P> <P>problems I should be aware of?&nbsp; I am currently studing for the Small Business Specialist exam and own a copy of Sql Server 2005 standard</P> <P>version and want to install it on my SBS 2003 server premium and need to know if this can be done.</P> <P>Thanks in advance.</P> <P>&nbsp;</P> <P>&nbsp;</P><div style="clear:both;"></div>