Q: How do I delete a SQL Server Analysis Services database?

A: Deleting a SQL Server Analysis Services database by using SQL Server Management Studio is initially confusing, as the Analysis Services databases aren't shown. The solution is to create a new connection using SQL Server Management Studio. 

Choose the Connect Object Explorer option from the File menu. In the dialog box, make sure the Server type is set to Analysis Services, then select the server. This opens a connection to the Analysis Server and shows all the Analysis Services databases (see screen shot below).


 See more FAQs about Windows, System Center, virtualization, Windows 8, and all things IT at John Savill's FAQs.


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.