Add connection in Netbeans 8 to the SQL Server 2012 database.
If you have added driver for SQL Server 2012, You may set connection to test database. So go to Services window and right click on Database node. Choose New Connection.
You see New Connection Wizard.
Select from Driver list Microsoft SQL Server 2012 driver.
In JDBC URL field write path to database:
jdbc:sqlserver://DORA-KOMPUTER\SQLEXPRESS:1433;databaseName=test
And in User Name write sa and in Password field your pass, mine it is dorota.
Click the Test Connection button.
If connection is good, you see information about it.
Click the Next button. In Select Schema stay dbo.
Click the Next button. You may change Input Connection Name.
In Databases node in Services window you see your new connection.
If you list Tables node, you see mytest table from database test.
In Netbeans you may see data in tables. Right click mytest table and select View Data.
In window you see all data of mytest table.
14
In Security/Logins node you see sa login.
Right click this node and choose Properties.
It is Server Roles tab which have choose only public and sysadmin:
In User Mapping tab for test database it is choose only db_owner and public role.
