Warning - this blog contains opinions, strong language, occasional bold text, and HTML. Viewer discretion is advised.


SQL Server Browser Service

Doing an upgrade from SQL Express 2005 to SQL Standard 2005 using the SKUUPGRADE=1 option?

Once the process is done and everything appears to be running okay, but isn't, try restarting your SQL Server Browser service. It could save you a day of troubleshooting and planning a server rollback. Or just reboot the box, that would have been helpful.

That is all.