Reskilling for the Full-stack and documenting things I am trying out, learning and doing in that space.
Tuesday, August 19, 2008
SQL Server 2000 - No wizards available in Enterprise Manager -> Tools
If your wizards select screen looks like this in SQL Server 2000, you have probably selected the SQL Server Group rather than a SQL Server or a specific database. The normal screen will appear if you select a database or a server.
Monday, June 9, 2008
SQL Server 2005 Menu items don't show up...
If you install SQL Server 2005 after installing Visual Studio 2005 or 2008 (with SQL Server Express), you may have a successful installation which leaves "Microsoft SQL Server 2005 -> Configuration Tools" as the only menu option.
At the time of this writing, I could find only one article on the net which offered a suggestion, here:
http://articles.techrepublic.com.com/5100-10878_11-6141894.html
You can see from the article that it requires you to remove all SQL Server 2005 pieces...
This is not necessary. All that is truly needed is to navigate to the setup.exe on the installation media and run the following at the command line:
setup.exe SKUUPGRADE=1
This saved me some time, and hopefully it will help someone else out there!
At the time of this writing, I could find only one article on the net which offered a suggestion, here:
http://articles.techrepublic.com.com/5100-10878_11-6141894.html
You can see from the article that it requires you to remove all SQL Server 2005 pieces...
This is not necessary. All that is truly needed is to navigate to the setup.exe on the installation media and run the following at the command line:
setup.exe SKUUPGRADE=1
This saved me some time, and hopefully it will help someone else out there!
Subscribe to:
Posts (Atom)
Transitioning to Front-End Development: My Journey into JavaScript
For years, I’ve been deeply entrenched in the Microsoft stack, working extensively with SQL Server, Oracle Database, and even IBM DB2. Whi...
-
Intro I was recently tasked with making a quick review of setup and high level recommendations for the setup of a MS SQL Server based app...
-
I use OneNote as my virtual notepad. I love being able to have my notes in whatever type of office doc, pdf, etc. sync'd and available...
-
Last week, I attended Jim O'Neils talk at the MSDN roadshow on RESTful programming. ( Chris Bowen's Blog : Announcing the Fall 2008 ...