Where is my SQL Server 2008 R2 for Small Business Product Key?

[Today’s post comes to us courtesy of Moloy Tandon from Commercial Technical Support] Windows Small Business Server (SBS) 2011 Premium Add-on includes Microsoft SQL Server 2008 R2 Standard Edition for Small Business. If the product was purchased via Microsoft Open License – Volume Licensing program, the product key is pre-keyed when you run the setup… Read more

How to Migrate Companyweb to a SQL 2008 R2 Standard Instance on SBS 2011 – Part 2: Premium Second Server

[Today’s post comes to us courtesy of Shawn Sullivan from Commercial Technical Support] In Part One of this series we discussed how to upgrade the preinstalled instance of Sharepoint on the SBS 2011 server to SQL 2008 R2 Standard in order to migrate a larger content database. This particular post is targeted to those who… Read more

How to Migrate Companyweb to a SQL 2008 R2 Standard Instance on SBS 2011 – Part 1

[Today’s post comes to us courtesy of Shawn Sullivan from Commercial Technical Support] For those of you who are operating with a WSS 3.0 site that has a content database approaching or larger than 10GB, you will have to take database size limits into account if you are planning a migration to SBS 2011. SBS… Read more

How to diagnose "Operating system supported for edition" pre-requisite errors while installing SQL 2008 Standard Edition for Small Business

[Today’s post comes to us courtesy of Damian Leibaschoff from Commercial Technical Support] The requirements to install SQL 2008 Standard Edition for Small Business are documented on this post: http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx Under certain circumstances, you may encounter the block even though all the requirements seem to be met, here is a checklist of things to verify:… Read more

SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash

[Today’s post comes to us courtesy of Damian Leibaschoff and Justin Crosby] Under certain conditions, the Windows SBS Console may show one or several of the following symptoms: The Other Alerts in the Home tab will show as “Not Available” The Console.Log may also contain exceptions like this one: [5164] 090620.094247.9164: Exception: ————————————— An exception… Read more

Error While Installing SQL 2005 Express on SBS 2008

[Today’s post comes to us courtesy of Justin Crosby, Shawn Sullivan, and Mohammed Sabir Chandwale] You may receive the following error when trying to install SQL Server 2005 on an SBS 2008 server: Microsoft SQL Server 2005 Setup SQL Server Setup failed to modify security permissions on the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\MSSQLServer\SuperSocketNetLib for user… Read more

Requirements for Installing SQL 2008 Standard Edition for Small Business

[Today’s post comes to us courtesy of Damian Leibaschoff] Windows Small Business Server 2008 Premium includes SQL 2008 Standard Edition for Small Business (http://www.microsoft.com/sqlserver/2008/en/us/small-business.aspx). This version is feature by feature the same as SQL 2008 Standard with the difference that it must be installed in an Small Business Server domain or, if purchased separately, an… Read more

SBS 2008: Released to Manufacturing!

On behalf of the SBS team, I am extremely pleased to announce that Windows Small Business Server 2008 software has been finalized!  Today both SBS Standard and Premium are being released to manufacturing, which means we begin the process of finalizing international versions, creating media, building packaging, delivering the product to distribution channels and handing… Read more

Cannot Access CompanyWeb After Installing 948110

[Today’s post comes to us courtesy of Damian Leibaschoff and Justin Crosby] SharePoint users who upgraded from SQL Server 2000 Desktop Engine (WMSDE) to any other edition of SQL Server 2000 (for example, SQL Server 2000 Standard Edition) may be incorrectly offered a WMSDE update for 948110. This problem can occur if the SQL Server… Read more

2nd UPDATE: Installing Hotfix 948110 on SBS 2003 Servers

We have received a few reports of hotfix 948110 causing issues with SharePoint (Companyweb) on SBS 2003.  At this time please hold off on installing this patch on your SBS 2003 server.  Installing this hotfix may prevent the SharePoint WMSDE instance from starting.  We are currently investigating the issue and will update this blog post… Read more