SQLStarters

Part 3: Setting up your SQL Server!

At the final part of my three-part series on how to set up your own test environment into Azure, we’re joining our SQL Server into Active Directory and downloading a database to use for testing.

Before you can join your computer into Active Directory, we need to do some changes in the networking settings. Namely we’re just adding DNS server you created during Active Directory creation. This is done from the Server Manager, choose a Local Server and then your Ethernet configuration.

azure_dns1

It’ll open up your Network Connections. Choose the one there, right-click it and open up the Properties.

azure_dns2

Choose IPv4 and select settings, which will open up the TCP/IPv4 Properties. Here you can add your DNS server manually.

azure_dns3

Then click Advanced, in the Advanced properties choose the DNS tab and enter into DNS suffix for this connection field your DNS suffix, then click OK twice and finally close.

azure_dns4

Joining Windows Server 2012 server into a domain is rather simple. Start up your Server Manager again, go to Local Server and click on the Workgroup.

azure_adjoin1

In the window called System Properties, there’s a button called Change in the Computer Name tab. Click it.

azure_adjoin2

Choose Member of Domain and enter the FQDN name of the Active Directory you created previously.

azure_adjoin3

It’ll ask for you Domain Administrator account and Password next, enter them and hit the enter. If you did remember your account and password, you should be seeing something like this.

azure_adjoin4

Your server will want to reboot after this operation. Log in using your local administrator account (your Domain account wont be able to log into SQL Server). Once you’re logged in you can download your favorite testing database in there. Personally I like to use AdventureWorks, which you can download from CodePlex.

There are datafiles available as well as a full database backup, whichever works for you. There’s also an OLTP and DataWarehouse to choose from, again pick the one you’d like to try out. One of the reasons I like AdventureWorks is, that there are plenty of examples and other material available from Microsoft to play with.

After your download is completed and you have copied your datafile (or your backup) to proper location, fire up the Management Studio and either restore or attach your database.

azure_ssms1

After your database is available, it’s a good idea to run DBCC UPDATEUSAGE, sp_updatestats and finally DBCC CHECKDB on it.

azure_dbset

And there it is, your own SQL Server test environment on Azure.

Read the rest:

Part 1: Create Azure Network and Storage.
Part 2: Create Virtual Machines and Active Directory.

Published by

3 responses to “Part 3: Setting up your SQL Server!”

  1. […] Part 1: Create Azure Network and Storage Part 2: Create Virtual Machines and Active Directory Part 3: Setup your SQL Server for testing purposes! […]

  2. […] Part 2: Create Virtual Machines and Active Directory Part 3: Setup your SQL Server for testing purposes […]

  3. […] Part 1: Create Azure Network and Storage Part 3: Setup your SQL Server for testing purposes. […]

Leave a Reply

%d bloggers like this: