Database

1. connect to local sql server from DBVisualizer

• find host name for sql server

1. localhost or under cmd window type host to find out

• find port number for sql server

1. open sql server configuration manager
2. sql server network configuration -> protocols for (dbinstance) -> enable tcp/ip -> properties -> ipall (can see the port number, change to default 1433)
3. restart server

references:
1. solving sql server connection problem