I installed a new instance and changed the default tcp/ip port and configured the applications. based on request i have changed the port to default 1433. now the problem is, the instance is not coming up. Then I restored the port now its working fine. But the application user wants 1433. could you please tell me why the instances is not comming up if the port is 1433? Thanks in advance
We have default instance "MSSQLSERVER" with Port number 1433. We Installed another Instance "MGMT" on the same windows server, it came as same Port number "1433".
We decided to Change the Port number for Instance "MGMT".
1. We changed the port number for "MGMT" to like "1234"
2. After the change we did telnet to "MGMT" Instance with "1433", it worked.
3. Then we changed the Port number for Instance "MSSQLSERVER" also to like "4321".
4. After change of these setting and followed with rules framed in link as said: http://www.databasejournal.com/features/mssql/article.php/3689846
5. Now we did telnet with changed port number, it works fine.
6. We can not do telnet with Port number 1433 for both Instances "MSSQLSERVER" and "MGMT".. This is fine, what we want, and what we intent to do...
Question to MVP OR SQL Gurus:
A) If you want to change port number to Second Instance, shall we need to change for Default Instance?
B) How the port numbers will be configured? please advice.
Hi there, I want to change the default sql-server port number 1433 to a new one. Can i do that? If yes, how? Also, i have noticed that there is no port number option in the sql server 2005 management studio login window. So, what if the server has changed its port number? Any suggestions would be appreciated. thanks
How can i define a different TCP/IP port number , other than the default 1433; to replicate the database over a firewall on the source and the destination servers ? My source servers are SQL SERVER 7.0 with SP3 on Windows NT Server 4.0 and the destination servers are SQL 2000 with SP2 on Windows 2000 .
Where do i have to make changes in SQL server and Windows NT ? And further how secured it is to use this way for security ?
hai all, I need to change the default port number of the SQL server from 1433 to some other port number. i know that it can be done thru SERVER NETWORK UTILITY. Can some one confirm that. It will be helpful. Also i want to make sure that port to given is free port. how can i find that particular port is free.
Hi,I want the change the SQL listen port of a named 2005 sql instance.Is there a way I can run an sql query against the named instance whichgives me back which registry setting I need to use.so MSSQL.1 MSSQL.2 or MSSQL.3Or is there another way I can set the listenport through script orvbscript for only a specific named instance so if there are other sqlserver instances running they don't get affected.Thanks Bob
Version: SQL SERVER 2012 enterprise edition and SP2.
Due to one of the security reason, I have changed default port 1433 to another port number in configuration manger tools->protocols for MSSQLSERVER->TCP/IP --> IP ALL section mention another port number.
After restarted service, SQL SSMS able to connect server itself and new port number also LISTENING.
But SQL client SSMS not connected to one of the PC side after changing default port.
Hi, I hope someone can help me! I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!
My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start:
IP1 Active Yes Enabled No IP Address aaa.bbb.ccc.111 TCP Dynamic Ports TCP Port 0
IP2 Active Yes Enabled No IP Address aaa.bbb.ccc.222 TCP Dynamic Ports TCP Port 0
IP3 Active Yes Enabled No IP Address aaa.bbb.ccc.333 TCP Dynamic Ports TCP Port 0
IP4 Active Yes Enabled No IP Address 10.1.1.1 TCP Dynamic Ports TCP Port 0
IP5 Active Yes Enabled No IP Address 127.0.0.1 TCP Dynamic Ports TCP Port 0
IPALL TCP Dynamic Ports 2020 TCP Port 2020
Interestingly, the ip address that the server is listening on aaa.bbb.ccc.444 is not reported in the list of IP addresses in the configuration manager for this instance, yet it is when I view the available IP addresses for the other two instances - is this significant?
I have tried failing to the other node, changing it there, changing it at the console and also while logged onto the the virtual machine remote desktop, rebooting both nodes, etc, etc. There are two other instances on this cluster that are still working fine but I hvae not attempted to change the TCP ports they listen on.
I used the same method to change this default instance as I did for a named instance on a similarly configured cluster and it worked fine. How to fix this?
Regards, Mike
2007-02-27 12:03:17.69 Server Server is listening on [ aaa.bbb.ccc.444<ipv4> 2020]. 2007-02-27 12:03:17.71 spid9s Starting up database 'tempdb'. 2007-02-27 12:03:17.72 Server Error: 26023, Severity: 16, State: 1. 2007-02-27 12:03:17.72 Server Server TCP provider failed to listen on [ aaa.bbb.ccc.444<ipv4> 2020]. Tcp port is already in use. 2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1. 2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa. 2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1. 2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1. 2007-02-27 12:03:17.75 Server Error: 17826, Severity: 18, State: 3. 2007-02-27 12:03:17.75 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. 2007-02-27 12:03:17.77 Server Error: 17120, Severity: 16, State: 1. 2007-02-27 12:03:17.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I have set up a new web server in my DMZ. This web server needs to "talk" to an application server located on my LAN. It communicates via a COM + Component.
I would like to keep the access that is open between the DMZ & LAN to minimal, obviously for security reasons. Does anyone know what port is used for COM + communication?
24/7 Production Call Centre server running NT4.0 and SQL 6.5 with all the latest service packs.
SQL mail fails(with dull regularity) and the SQL server services stop.
When the SQL server Services are restarted an error message appears stating that Port 1433 is in use after which nobody can connect via TCP/IP. Obviously the port believes the previous SQL session is still running, and won't release the port to the "New Application requesting it".
On a unix system you can force a port reset so you don't need to shutdown and restart the box. Can you do this from either SQL or NT?
Any solutions would be greatly appreciated the DBA's are 100 Miles from the Servers, so restarts are reliant on other people!
Does anyone have an idea on why when using IP with port 1433 that on the SQL 2000 Server a bind failure happens on port 1433 and are not able to get to the SQL using IP but you can use Named Pipes.
I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.
Iwant to know PORT number of B on A server. Iam following the following process to get B PORT number.
1) Loging to server A. 2)Opened SQL Server Configuration Manager. 3)Opened SQL Server 2005 Network Configuration. 4)Opened TCPIP properties of Protocol for B. 5)On that opened IP Address TAB 6)Got PORT number from TCP Dynamic Ports
Am i going n right way. If not please advice me the right way to get port numbers.
1. Is there a quick way to find out what port number SQL is listening to? I have 10 instances running on one server and I could find out by going to SQL log but it's bit time consuming.
I'm trying to setup SQL Server 2005 Express to communicate through a non standard port. I can connect to SQLServer on a remote machine using port 1433 when it is set as such but when I change the server to another port and try and connect using SSMSE I can't get through. I'm specifying the ip address and a colon followed by port number to connect.
For example: 123.123.123.123:1234
Any ideas?
---------------------------------- Standing on the shoulders of giants
Not sure how this particular topic should be labeled but I figured I would start here.
I have a third party Time and Attendance program that uses SQL 2000 and IIS on top of Win2003. It also uses a client side program that sits on an XP box that pulls Time clocks entries than passes that info to the SQL server. We recently needed to move to a different service, still utilizing the same Time and Attendance program but a different client utility that pulls the Time clocks. Both the client and Time and Attnedants program are developed by the same company. All that being said the new clock utility cannot connect to the SQL service. The difference between the 2 utilities is the first utility uses UDP, the second uses TCP and requires port 5405. Basically the way I€™m seeing things is that the server does not have port 5405 open this also confirmed by the company the wrote the program. There is no firewall on this server. RRAS is installed but does not have any filters enables which I believe means it will receive and pass all protocols to all ports. Using a port scan utility it shows port 5405 not to be open How can I get port 5405 open?
Just wanted to find out what port does SSIS utilizes when communicated with a remote SQL Server. Is it 1434, 1433 or something? I have a SSIS Package on Server 1, which which does inserts on SQL DB on Server 2. I think between Server 1 and Server 2, some ports are being blocked because the 2 servers are separated by a firewall. When SSIS makes connection to Server 2 (SQL), what ports does it use? Also, any other tips would also help. Here is the error I am getting:
Cannot connect to 10.xx.xx.xx.
===================================
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
The powers that be at my company have decided to redisign our network. The big change is that they are completely separating the two domains, whereas I guess right now one runs inside of the other.
What this means to me is that I need to get a document together which shows all the connections between different SQL servers, web pages and services that I've created over the last year.
My question is, what ports do all of these things use to communicate with SQL Server 2000? I believe the only connections right now are using ADO/ADO.NET, or straight SQL Linked Servers.
Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.
Is there a way I can specify a port for the server to listen to?
Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.
Everything is on my local machine, this is a development database.
Is there a way I can specify a port for the server to listen to?