THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Installing Microsoft Atlanta

Since my previous post on Microsoft Atlanta, I've been asked how someone can get started with it. Go to and click the Create Account button using a Windows Live id such as a Hotmail account. If you don’t have Silverlight installed, you’ll be prompted to install it somewhere along the way. I encourage you to install Atlanta and try it out. It found something I'd overlooked and it may prove useful to you. The product is still being developed (in other words, it's free for now) and your early feedback can make a difference.





When you click Download Registration Certificate, you’ll be prompted to save a file named RegistrationCert.pfx. I suggest making the name more descriptive. I know I’m not going to remember what it’s for. Clicking Download Atlanta Gateway and Agent Setup prompts you to save a file named AtlantaSetup.exe.

Notice the “Click here for detailed deployment information…” in the Add Server screen capture above. It takes you to this web page where you can read about the advanced scenarios.

This is what you see if there’s no gateway installed:


There’s a “click here” in the pale yellow ribbon. It just takes you back to the Add Server dialog box shown previously.

When you run AtlantaSetup.exe, you are presented the following command window:


I chose option 3. You’ll need to specify the location of the registration certificate.


After installing the gateway and the agent, click the Servers icon to see that your server is being monitored.


That’s all there is to it! My previous blog post on Atlanta indicated that I found it useful. My point here is to show how simple it is to install and use Atlanta. It could be a good way to monitor the proliferation of SQL Server Express instances that so many organizations experience. We’ll have to wait and see if the pricing model for Atlanta will make monitoring of SQL Server Express instances affordable.

Published Sunday, January 16, 2011 9:00 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse currently studying to be a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement