Labels

Wednesday, 17 February 2016

SQL Server interview questions

What is Telnet ? Why do we need it ?

Telnet is a network protocol that allows a user on one computer to log on into another computer that is part of the same network .

What is Port Number ? Why do we need to open Port Number ?

Port Numbers are associated with TCP / IP network connections used to allow different applications on the same computer to share network resources simultaneously .

What is SQL Server browser ?

SQL Server browser runs as a windows service . It will listens incoming requests for MSSQL Server resources and provides information about SQL Server instances installed on a computer.
If browser services are not running then the components tries to connect to a named instance without specifying port no will be failed.


No comments:

Post a Comment