SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 316 Page Views: 

Which Port is assigned to run SQL Server? Can the Default port be changed?



Posted By: Avi Date: 1 October 2010 10:54:06 AM
 Answer:

1433 is the TCP/IP port which is required to run SQL Server . Yes, default port can be changed for the security purpose so that no other program can use the port specifed by you for SQL Sever. The syntax for changing the port is:- <% ss= "Provider=SQLOLEDB;" & _ "Data Source=,;" & _ "Initial Catalog=;" & _ "Network=DBMSSOCN;" & _ "User Id=;" & _ "Password=" set conn = CreateObject("ADODB.Connection") conn.open ss ... %> One more way to change the port number is:- Open Netwok Utility the TCP/IP properties. There you can change both the client as well as servers port number.


Posted By: avibtech

Date: 1 October 2010 10:54:06 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image IOCM74
Related Questions
SQL Server : Why there is a need to use secondary database file when the same work can be done with primary databse files?

Why there is a need to use secondary database file when the same work can be done with primary datab....

Secondary files can be spread over multiple disks which will enhance the I/O operations.
Category: SQL Server Date: 10/1/2010 11:40:07 AM
SQL Server : What will be the result of the following query ? Explain your answer. create table tempo (sno INT, item_code nvarchar(2)) ; insert into tempo select 1, '0' UNION select 2, '11' UNION select 3, '12' UNION select 4,'0' UNION select 5,'0' update t

What will be the result of the following query ? Explain your answer. create table tempo (sno INT,....

The given query will result inot 3 rows. Sno item_code 1 4 5 ....
Category: SQL Server Date: 10/1/2010 11:38:07 AM
SQL Server : What is the purpose of sp_lock?

What is the purpose of sp_lock?

sp_lock is a stored procedure which returns the detailed information regarding the locks. The follow....
Category: SQL Server Date: 10/1/2010 11:37:07 AM
SQL Server : Define Phantom?

Define Phantom?

From SQL Server Online Books Phantom is defined as:- Phantom behavior occurs when a transaction att....
Category: SQL Server Date: 10/1/2010 11:36:07 AM
SQL Server : What does OBJECT_ID specifies?

What does OBJECT_ID specifies?

Object_ID is the option used in the SELECT statement which returns the object's idebtification numbe....
Category: SQL Server Date: 10/1/2010 11:35:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories