Friday, 5 February 2016

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

No comments:

Post a Comment