can we use two port

Question

Hi All,

Please tell me can we use two port for connecting sql server one is our default 1433 and another one like 1234 foe sql server. if yes then how can we configure this on sql server. 

Regards,

Pawan Singh

---

Thanks

Answer 1

Hello Pawan,

Please have a look at MSDN: Configure the Database Engine to Listen on Multiple TCP Ports

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hello Pawan,

Please have a look at MSDN: Configure the Database Engine to Listen on Multiple TCP Ports

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Hi Olaf Helper,

thanks for quick reply, i did the but when i create endpoint and gives the connect permission to public then all user (except SA) not able to login in server it's given 18456 with state 11 error. can you please describe about this why this happen.

Regards,

Pawan Singh 

---

Thanks

Answer 3

HI Pawan !

You might need to have a look at below article;

http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

Please let me know if this helps. Hopefully i have answered you correctly.

Thanks, Hasham

Answer 4

Hi Rajput,

Go to Sql Server Configuration Manager->Sql Server Network Configuration - -> Protocol for MSSQLSERVER -> double click TCP/IP -> IP Address - > IP4.

In IP4, you should have 1433( in case, its default instance). Add a comma, and type your second port number
say, if you want to add 4567, it will be like 1433, 4567.

You need to restart your sql service.

regards/srinivasan