What is a default TCP/IP socket assigned for SQL Server? - 1433 is default tcp/ip socket sql server.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL

DETAILS

Question: What is a default TCP/IP socket assigned for SQL Server?

Answer: 1433 is default tcp/ip socket sql server.

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6691 users
Added on	5/20/2013
Views	69027
Rate it!

Question: What is a default TCP/IP socket assigned for SQL Server?

Answer:

1433 is default tcp/ip socket sql server. Source: CoolInterview.com

Answered by: Aman | Date: 11/29/2008 |

Contact Aman

A SQL Server 2000 custom installation, if TCP/IP is the only selected protocol and all other protocols are disabled, SQL Server may not initialize and listen on TCP/IP sockets. The Server Network Utility shows that it is listening only on TCP/IP port 1433 even though it is not. Source: CoolInterview.com

Answered by: chiranjeevi | Date: 8/12/2010 |

Contact chiranjeevi

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What’s the difference between a primary key and a unique key?	View Answer
	How to retrieve the image from the database?	View Answer
	How to find the second highest salary from employee table? and how to write it?	View Answer
	How to transfer some amount from one person's account to another's ?	View Answer
	Advantages and disadvantages of attributes.	View Answer
	What is sql? what is the difference between sql and pl/sql?	View Answer
	Why do we use cache and no cache in sequences? What is the benefit we have in using them?	View Answer
	Write short notes in XSU & java ?	View Answer
	How to generate OIDS ?	View Answer
	What is output of following query Select 2 from employee;	View Answer
	What is normalization and different kinds of normalization?	View Answer
	How to testdata loading in database testing?	View Answer
	What columns would you use as a clustered index on a retail store address table?	View Answer
	what is the query for to select multiple columns to generate single row in the sql and how come we can bring grid views in sql for getting those datas are demolished	View Answer
	What is a clustered index?	View Answer
	What is the difference between @@identity and SCOPE_IDENTITY()?	View Answer
	1. How to create a new table? 2. How to insert another column into the table?	View Answer
	What is the use of indexes?Explain about it?	View Answer
	lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d	f1 f2 f3 f4 f5 f6 ... ... .. ... - SQL Interview Questions & Answers"> View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Interview Questions & Answers - Exam Mode / Learning Mode