[FIXED] Cannot establish a connection to jdbc:sqlserver in Netbeans AND MMC could not create snap-in in SSCM

Issue

I m trying to set up the Connection between ***SQL SERVER 2012***and ***Netbeans Java***, I was establishing connection with the help/reference of a youtube video https://www.youtube.com/watch?v=IwE7vzBIXxs. My problem is that when I was on the way for connection in java, In customize connection after filling all fields the following error occurs

Cannot establish a connection to jdbc:sqlserver://127.0.0.1\SQLEXPRESS:1434; 
databaseName=URMS using com.mic

You can view it in this image

And when I go for the settings in ***SQL SERVER Configuration Manager*** When I open it, It shows the following ERROR

MMC could not create the snap-in

I have provided the second image in comments please go through it

Before this error in 'Sql Server Configuration Manager, I was working on previous install ofSQL SERVER 2012In that installation 'Sql Server Configuration Manager was working, But the problem was that under `SQL Server Network Configuration' the protocols was missing for that purpose I reinstall the SQL SERVER 2012 but the problems increased

Previous Installation ***SQL SERVER 2012 32 bit*** windows 10 64
New Installation ***SQL SERVER 2012 64 bit*** windows 10 64

Please guys help me get me out from these ERRORS.

Solution

As far as the first part of your question is concerned, you could refer to this: cant-connect-to-sql-server-database-with-netbeans

Just add integratedSecurity=true; to the end of your connection string if you are using Windows Authentication, or false otherwise, and it should work.

Answered By - James Chalmers
Answer Checked By - Marilyn (JavaFixing Volunteer)