For Those Building New Apps in the Cloud

Azure Cloud on Ulitzer

Subscribe to Azure Cloud on Ulitzer: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Azure Cloud on Ulitzer: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Azure Authors: Liz McMillan, Yeshim Deniz, Elizabeth White, Greg Schulz, Todd Matters

Related Topics: Azure Cloud on Ulitzer, Microsoft Developer

Blog Post

Getting Started with SQL Azure

Accessing SQL Azure with IIS7 Database Manager was a walk in the park

It was quite easy to connect to SQL Azure using IIS 7 Database Manager in my Windows 7 machine. Given the fact that the products are still in initial stages this is very reassuring.

The messages that comes from SQL Azure to IIS 7 Database Server's interface are at best confusing but if you can sweat it out (Keep trying!!!) you will see some light. Other featrures(!) of the connectivity are slow response |No Response etc.

Here is a screen shot of my first attempt at running a stored procedure that I created on MyAzureConnection in IIS7 Database Manager.

Stored Procedure:

CREATE PROCEDURE Test
@p1 int = 1,
@p2 int = 2
AS
BEGIN
SET NOCOUNT ON;

SELECT @p1,@ p2
END
GO

When you run the procedure you may get a pop-up message saying the operation was not successful but you will see that the procedue has returned the correct result.

Executing a stored procedure on SQL Azure in IIS 7 Database Interface

You may also want to read my other connectivity blog post.

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.