First I tried to connect through Netbean's "New connection.." and successed in connecting to the database but stumped when it asked for which schema to use?
So I selected a random one then tried to create a table but got CREATE TABLE permission denied.
Afterward I tried using DriverManager. Connected to the database but also don't have CREATE TABLE permission.
my connection code part
connection = DriverManager.getConnection("jdbc:sqlserver://mssql*.gear.host:1433;databaseName=database***", "*******", "*******");
is sql management studio 2016 the only way to use the database?
edit: somehow resetting primary user password and using "dbo" schema let me create|select like normal.
Issue is no more now.