MSSQL additional Installation
Date: Mon, 12th September 2005
OS: Windows SBS 2003
Description
After installing Windows Small Business Server 2003 it may not be possible to view or add SQL databases on the server. This is because SharePoint services and SBSMonitoring takes over MSDE.
Solution
Another instance of MSDE needs to be installed and the databases need to connect to those. After the innitial installation of SBS you should have a service pack folder for SQL Server SP4 in Program Files.
You will first need to open a cmd prompt and type the following to navigate to the required folder: "C:\Program Files\Microsoft SQL Server SP4\WMSDE\"
You will now need to run setup.exe with a few switches to tell the install what you intend to do with it. Take a look at the example as follows:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="Y0urPWD01" DISABLENETWORKPROTOCOLS=0
This should install an new instance of MSDE and allow you to create and connect to that instances databases.
