I am excited i got windows azure subscription, i couldn’t stop myself to create a SQL Server Instance in cloud. Here is my small experience with cloud. Lets create SQL Server instance and access from our client SSMS(SQL Server Management Studio).
Step 1: Go to your portal:
Step 2: Click on +New (Quick Launch for Services) Or SQL Database Symbol on Left pane:
If you click on new, this will give you quick launch of cloud services. You can choose your services like compute (create website, Virtual Machine, Virtual Network, Mobile Services), Data Services (Create Database, Storage, Big-data etc), App Services etc.
Step 3: Choose Data Services/SQL Database/Quick Create:
Step 4: Server is ready:
Then you can see a progress bar there in the portal and at bottom as well. Once that is created we can customize as well. Keep in mind this user name and password will be useful connecting server from client side.
Step 5: Give access to your client machine to access through SSMS:
Click on server name as marked in below image.
You get to another page where you can allow access to clients ip address. Here you can see three textboxes, enter computer name (for your reference only) then starting range of IP and ending range of IP.
You can get your client IP of your system by typing “my IP” in Google; this I thought would be simplest.
Then save the changes. Now if you have given permission for your computer IP then you will be able to use SSMS to connect to the server from the permitted client machine.
Once Server is ready then we can access this database even from our client SSMS tool. For that you need Server Name. For that follow next step.
Step 6:Let’s find server name:
Click on Manage as shown below.
Copy this completely like “xxxxxxxxxxx.database.windows.net”. This is Server name.
Let’s try connecting to the server via SSMS in permitted client machine. As you can see I have given server name as copied as explained in above step.
There you are connected with the server, now you can do all operation in your machine and the changes will be saved in your server created in cloud.
Now you have created a SQL Server Instances in cloud. Enjoy SQL coding…..
