O'Reilly logo

Microsoft Azure: Enterprise Application Development by Nathan Duchene, Richard J. Dudley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating our database

Now that we've done everything we need to do to hit our SQL Azure database from an outside connection, let's set up the database by using the Server URL in SSMS and our Administrator Username/Password to connect from there. Once connected, the following scripts will create our application databases, add logins named JupiterMotors for the JupiterERP database and Portal for the Portal database (which we will use throughout the book), and all the tables/keys in the diagram at the beginning of the chapter. Please note that the CREATE DATABASE and CREATE LOGIN commands must be executed separately in the master database, and the CREATE USER command is to be executed in the Jupiter ERP database. Also, we must log into the each database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required