I had an interresting case today. Someone had installed SQL Server 2008 R2 evalutation edition and then the server had gone into production after the installer had left the building. Nobody knew that it was evaluation version that were used. Today the evalutation period expired and the server stopped!!!!
After some troubleshooting we found what happened and started to think about what to do. Luckily there were an easy way out without using the backups and reeinstalling.
The link below explains what to do.
http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx
After doing the necessary steps the SQL Service started fine but the SQL Agent didn´t. I got an wmi error when i tried to change the agent service back to automatic. Apparently this is a bug in SQL Server which appears after the service have been set disabled and you can read about it here.
Maybee this can be of any help to somebody in the future.
Stefan
Prenumerera på:
Kommentarer till inlägget (Atom)
0 kommentarer:
Skicka en kommentar