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.

Author: Mika Sutinen

Hi, My name is Mika Sutinen and I'm a Senior Database Administrator for a company called Tieto. I've been working in IT-industry for two decades and I've spend most of my career working with healthcare information systems. I've worked with SQL Server for most of my career, starting with version 6.5 a long, long time ago. My other interests are high availability, everything related to performance (testing, monitoring, etc), Windows operating systems and I'm currently learning more about Azure.

3 thoughts on “Part 3: Setting up your SQL Server!”

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