Skip to main content

How to create new MS SQL virtual machine in Azure

How to create MS SQL virtual machine in Azure and how to enable MS SQL Login user.

1. Create new virtual machine with MS SQL server
2. Open a MS SQL port 1433 in azure management for the given virtual machine
3. Log in to the virtual machine
4. Open port in firewall in virtual machine Windows system - 1433
5. IMPORTANT - Set MS SQL setting to the Mixed Mode (Windows Authentication and SQL Server Authentication) (default is only Windows Auth.)


  1. A huge shout out to the writer who poured his soul into this blog.Johnny Chen Houston

  2. Enjoyed every detail of this impressive blog. Specially how the writer has instilled life to it.softwaretesting

  3. Owning a business is a very stressful, but rewarding experience. With all of the many things a business owner has to keep up with, choosing the right workspace is essential in getting it all done.

  4. Very like every detail of your blog. Visit my blog Faribault Web Design

  5. Thanks for the useful information of software testing courses, give more updates on software testing development, First time I visit your blog really nice, I bookmark your blog here after a daily visit. Learn software testing course in Chennai

  6. Those guidelines additionally worked to become a good way to
    recognize that other people online have the identical fervor like mine to grasp great deal more around this condition.

    white label website builder

  7. Bookmark your blog here after a daily visit. Thanks for sharing! Visit my website
    rochester mn web designer

  8. Much appreciated for those suitable data for programming testing courses, provide for All the more updates for product testing development, primary run through i visit your blog truly nice, i bookmark your blog here then afterward a Every day visit.

  9. Its an incredible joy perusing your post.Its brimming with data I am searching for and I want to post a remark that "The substance of your post is magnificent" Great work.  Get into pc

  10. Thanks for such useful information given by the admin... it's interesting to read

  11. This comment has been removed by the author.

  12. Thanks for the useful information of software testing courses, give more updates on software testing development, First time I visit your blog really nice,Bookmark your blog after a daily visit. Thanks for sharing! Visit website

  13. Thanks for guide how to create new ms sql virtual!
    You can visit blog about web design Brooklyn Park Web Design

  14. Choose hostgator coupons and get your first month for a Penny! Web Hosting Made Easy. Unmetered Disk Space. Free Website Templates. Unmetered Bandwidth. 99.9% Uptime Guarantee. Types: Windows Hosting, Linux Hosting, Reseller Hosting, Dedicated Server, VPS Hosting, Cloud Hosting.

  15. On the other hand, you can essentially utilize your creative energy. Just you comprehend what will make you cheerful, so keep running with

  16. Your blog was very interesting & easy to understand. Thank you so much sharing that informative blog.Inventory Audit

    selenium training in chennai

    aws training in chennai

  17. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. document software solution

  18. I am truly thankful to the holder of this site who has shared this fantastic post at here. software website

  19. Now you can win free stuff online, free giveaways, enter every day to win latest iphones, smartphones, macbooks, laptops, accessories, technology and much more.

    Participate, Win & Keep A Free Xbox One X Console

  20. Laser cutting machines deliver unmistakably cleaner cuts and can without much of a stretch cut objects of pretty much any shape.

  21. Sickbits is a library of unlimited hacks for android, ios smartphones. Get unlimited amount of hacks and modes for mac & pc.

    Download latest cracks of mac & pc softwares. You can get full versions of latest games, softwares, applications and many tools.


Post a Comment

Popular posts from this blog

Entity Framework Exception - A referential integrity constraint violation occurred

Entity Framework Exception - A referential integrity constraint violation occurred. When you get this type of the exception it just simply means that you need to match Ids of the related entities.

Exception: A referential integrity constraint violation occurred: The property value(s) of 'Image.Id' on one end of a relationship do not match the property value(s) of 'BaseEntity.SomeImageId' on the other end. 

A typical mistake that cause this exception is:

baseEntity.SomeImageId (type of Image)



Does not match.

So if you change the new added related entity to the negative Ids (see the related blog post), then you also need to modify the parent end of the Id (one end of the relationship as Entity Framework expression goes). So that both "ends" have the same Id value.

Entity Framework exception - adding new Detached Object to the DbContext

Entity Framework exception - adding new Detached Object to the DbContext? How to?

When you see this exception:

Exception: Attaching an entity of type 'Image' failed because another entity of the same type already has the same primary key value. This can happen when using the 'Attach' method or setting the state of an entity to 'Unchanged' or 'Modified' if any entities in the graph have conflicting key values. This may be because some entities are new and have not yet received database-generated key values. In this case use the 'Add' method or the 'Added' entity state to track the graph and then set the state of non-new entities to 'Unchanged' or 'Modified' as appropriate.

This just mean that you need to properly handle detanched entities Ids. This exception means that two of your newly added entities have the same Id. Typically the value of the Id is 0.

So the solution is that you need to manually change Ids. You need to …