Review the Installation Task and Click Install. SQL Setup will validate the install again. Give the new service the credentials of an account with administrative permissions on the machine.ĭecide if you want to send the install info back to Microsoft, Click Next. Click Next.Įnsure you have enough Disk Space and click Next. SQL Server then validates the Installation to ensure it will not fail. We now need to add Integration Services, so place a check in that box on the next screen and click Next.
Let SQL Install the setup files again, and then choose Add Features to an existing install: Now go to the Installation Element of Setup and choose New Installation or Add features to an existing installation. Good, now I need to add Integration Services to this machine, because it is only running the Database Engine. Inspect the log file if necessary to ensure you’re happy. The next screen will invite you to choose the edition you want to upgrade (EXPRESS), and then click Next. Start the upgrade, enter the licence key if required, and accept the Licence Agreement. In fact, there is no need, since if you use the Maintenance element, there is a handy “Edition Upgrade” option. The result is that you will get so far, and it will stop, declaring there is nothing to upgrade and the helpful message “There is a validation error on this page”.Īt this point, I have seen various suggestions that you should install a separate instance of SQL Server, detach the databases from Express, re-attach them in Standard and remove the Express instance. This will not perform the upgrade if you merely wish to change from Express to Standard 2008 R2. The Setup program gives you various options – it is very tempting to use the Installation element of Setup, which invites you to Upgrade from a previous version of SQL Server. NET Framework if required, and the SQL Server Setup Files.
Start setup.exe from the root of the SQL Server installer folder and install any prerequisites, including the. So, upgrade the SQL Instance – luckily in SQL Server 2008 R2, you get a handy upgrade Edition option. In this instance I need the Business Intelligence Development Studio on my laptop to work on a SQL Server Integration Services project – unfortunately though this is installed with Express, if Integration Services is not running on the machine (only possible with Standard Edition upwards), then you get a nasty error when BIDS starts. I’ve faced this a few times before but its one of the things that keeps coming round to haunt me again – how to upgrade an instance of SQL Server Express to Standard.
0 kommentar(er)
