Windows Azure SQL Database

Here are my strategies on setting up Windows Azure SQL Database for a development database with a developer login.

  1. Create a new SQL database on a new server.  You will get an assigned server. 
  2. Make sure you have a meaningful database server admin name.  Do not name it for a database “databaseXYZsa”.  Rather, name it like “dbserverXYZsa”.  Why? because you will probably add more databases to the same server and they all will share the same admin account.
  3. Use the admin account to connect to “master” database.  You cannot do “use master go”.  You have to configure a database connection, specifying “master” as the database.  Then you can create a login.
  4. CREATE LOGIN login1 WITH password='<ProvidePassword>';
  5. Then you can connect to your new database and add a user as an dbowner.

     

    reference: http://msdn.microsoft.com/en-us/library/windowsazure/ee336235.aspx

    Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s