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

2011/08/05

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.