java - Can't connect to Sql Server database using JDBC -


i'm trying make connection existing database in sql server 2012n netbeans 8.

using connection wizard select sql server 2012 , enter credentials , fields.

however message connection cannot established.

you can see screenshots of entered fields:

sql server

netbeans connection wizard

i tried using "localhost" instead of "stijn" didn't work. tried default port "1433". didn't worked, port should be? can see port i'm using? maybe error lies in port, otherwise wouldn't know made mistake.

go sql server configuration manager -> sql server network configuration -> protocols sqlexpress -> tcp/ip (double click on properties).

on protocol page set enabled yes. on ip addresses page, scroll bottom. tcp dynamic ports: 54629 tcp port: 1433 apply , ok.

make connection with: host: localhost port: 1433 credentials instance field = blank.

this should work.


Comments

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -