Change Of Port Number For Replication .
Jul 4, 2002
Hello ,
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 ?
Can i get some on this matter please .
Thanks in advance
Sandra .
View 2 Replies
ADVERTISEMENT
Aug 7, 2007
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
View 4 Replies
View Related
Jul 15, 2004
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.
Thanking in Advance, awaiting Quick response.
Signing Off
Venkatesh.V
View 1 Replies
View Related
Jul 20, 2005
Hi allI'm struggling to find an answer to this one!We've configured our SQL boxes to run under a different port number,e.g. from 1433 to 4533. This works fine under our Citrix enviornmnetwhere the dsn is configured to use the new port. The problem comes interms of SQL Server management. For example, when you try andconfigure SQL Replication, it is not possible to add the subscriberunless the SQL Servce runs under port 1433, the default port. Thesame goes when you try to add the server as a registered server withinthe Enterprise Manager MMC.Does anyone know how you can configure SQL Server to run under adifferent port number, without naffecting SQL REPLICATION, etc?Many thnaksNikJoin Bytes!
View 2 Replies
View Related
Jan 31, 2003
Is there any way that I can avoid using 1433,1434 port on the clustered servers?
I have a active/passive (SQL1-active,SQL2-passive) cluster server and another active/passive cluster (SQL2-passive,SQL1-active).
(Its a Quassi active/active server)
I want to change all the sql server ports to other than 1433 and 1434.
Should I change in the registry
Localmachine-software-microsoft-mssqlserver-client-supersocketnetlib-tcp
or
Localmachine-software-microsoft-mssqlserver-mssqlserver-supersocketnetlib-tcpport
or
anywhere else?
Any suggestions are always welcome
View 7 Replies
View Related
Nov 8, 2006
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
View 7 Replies
View Related
Aug 23, 2007
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.
2. quick way to change the port number?
thanks
View 1 Replies
View Related
Apr 22, 2004
How many people have actually change their sql port from 1433 to something else
View 1 Replies
View Related
Jan 30, 2008
Hello All,
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.
Thanks, Jay
View 1 Replies
View Related
Dec 15, 2000
Does anyone know how to change the default port number of 1433 to somethinig else?
Thanks!
View 1 Replies
View Related
Mar 1, 2004
Hi,
Can anyone tell me how to find out on what port number a paticular sqlserver named instance is running...
thanks..
View 5 Replies
View Related
Feb 6, 2007
Where - in SQL Server Profiler - can I see the port number that someone has used to connect to a database?
e.g. given the connect string "tcp:MACHINE1INSTANCE7,3045" - where in Profiler does it tell me that the connection is using port 3045? I looked at "audit login" and "existing connection" but I don't see a port number...
Any other SQL/Windows tools that I can use to monitor connections to databases on specific ports?
thanks
View 1 Replies
View Related
Dec 4, 2006
Hi,
Are there any one who give a example of SMO or WMI to set SQL Server port number?
View 2 Replies
View Related
Mar 8, 2007
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
View 1 Replies
View Related
Aug 31, 2006
How can I configure dbdesigner to connect to a sql server that is listening on a different port number ? For those of you not familiar with debdesigner:
http://fabforce.net/dbdesigner4/index.php
I can connect to a local instance just fine but not to a sql server that is listening on a specific port (named instance)
[edited to add]
it works ! I just had to use the name instance notation
server instance_name
It wouldnt connect with iport_number syntax
hooray !
View 1 Replies
View Related
Feb 13, 2008
I know the ..Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog on the server contains the information. But that needs I to RDP to the server or open the file remotely. Is there any other way to find out the port from my SSMS connection?
I remember in SQL Server 2000 you could find the information by choosing Properties of a connection in EM and click on the Network Configuration button. (I know it works when you are ON THE SERVER! But when I tried from my desktop, pressing the button didn't do anything)
Canada DBA
View 2 Replies
View Related
Jul 23, 2005
Hello,I have SQL Server 2000 Enterprise Edition, and I'd like to change thedefault port to something else (we'll use 2033 for this example). I'vetried to connect from another computer on the same subnet using"ServerName:2033" as the server, but it doesn't connect. It will connect ifI change the Server to use the default port and change the server to connectto on the client to "ServerName", but either I"m not referencing the newport number properly or ????Any help you could provide would be great.Thanks In Advance!Rick
View 1 Replies
View Related
Oct 19, 2007
Hi All,
I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.
Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?
Any help on this will be great.
Cheers
Raxso
View 3 Replies
View Related
Feb 19, 2015
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.
View 3 Replies
View Related
Jun 21, 2015
I have TWO named SQL Server instances (on the same machine) and I need to know the port of each of them, how can I do that? Is it write to check the following:
Which one to take: "TCP Dynamic Ports" or "TCP Port"? and what is the difference between them anyways?
Can the two instances (or more) on the same machine use the same port?!
View 12 Replies
View Related
Dec 1, 2006
Hi,
I want set a specific port number of SQL Server(express) during installation not by Configuration Manager after install.
Is it possible?
View 1 Replies
View Related
Apr 16, 2007
Hi all,
I have to create a DSN for SQL-Server. Therefor I use the function "SQLConfigDataSource" from "ODBCCP32.DLL". But the problem is that the SQL-Server does not use the Standard-Portnumber 1433. I've tried to make the DSN with "SERVERNAME xxxx" where xxxx is the Portnumber, sometimes it works, but often it does not. When it does not work, then the Checkbox in the ODBC-Configuration-Tool is checked, so the connection is searching for the standard-port. How can I tell the system that it shall NOT use dynamic configuration?
Thanks for help,
Franz
View 6 Replies
View Related
Feb 27, 2007
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.
View 11 Replies
View Related
Aug 24, 2005
I can't map other sql servers without creating alias with proper port number on client network utility. Other users using same version of the client tools, MMC, SQL DMF etc. I need to map 70 sql servers on using my client tools.
Any help is appreciated.
thanks,
View 3 Replies
View Related
Jun 30, 2015
Is there a way to identify who have changed the SQL port number other than the DBA's?
For example through c2 audit or any other triggers?
View 3 Replies
View Related
Oct 15, 2015
How do I populate a SQL Server express 2014 table from an impinj speedway reader via http address and port number...
View 6 Replies
View Related
Sep 27, 2007
I have a new named instance (SQL Server 2005 x64 SP2 (Build 3159) Developer edition) setup with dynamic port selection. A default instance was also running on the server prior to the named instance setup.
SQL Server Browser service is running. Remote connections are configured on the named instance. But still remote clients can only connect when the port number is specified after the instance name (servernameinstancename,9999). Without the port number, "error 26 - Error locating Server/instance specified" is thrown.
Doesn't the SQL Server Browser service eliminate the need for clients to specify the port number? What am I missing?
Thanks.
View 1 Replies
View Related
Oct 29, 2007
Hello,
We have an SSIS job that runs once a day and sends emails.
For security reasons, IT switched the send-mail porton the smtp server from 25 to a different number (let's say 1234).
So, I changed the SSIS SMTP Connection Manager's smtpServer string to smptserver:1234
However, this does not seem to be working. I keep getting 'Send Mail Failure' error.
Any ideas how to set the port number for sending emails using SSIS?
thanks much,
Muhammad
Cobalt Group
View 3 Replies
View Related
Aug 14, 2007
I hope someone can help as I have searched for a solution but been unable to find one as yet.
My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.
Sorry if this is a dumb question but it is giving me a headache at the moment.
All answers gratefully received,
Andy
View 3 Replies
View Related
Oct 8, 2006
in my sql, i want to change a decimal number to percent format number, just so it is convenient for users. for example there is a decimal number 0.98, i want to change it to 98%, how can i complete it?
thks
View 4 Replies
View Related
Apr 3, 2015
Basically the question is, which number should I pick?
View 4 Replies
View Related
Jan 8, 2008
hi need help
i have table employee
i need to change to the employee Once a month the number from 1 to 2 (once a month)
in the first day of the month evry month
and loop back to 1 . 2 .3 .4
evry month next number from 1 to 4
empid val_Number date
-----------------------------------------------------------
11111 1 17/01/2008
2222 4 19/12/2007
3333 3 19/12/2007
i need to see it like next month (in the first day of next the month)
empid val_Number date new_val
--------------------------------------------------------------------------------
11111 1 17/01/2008 2
2222 4 19/12/2007 1
3333 3 19/12/2007 4
TNX
View 7 Replies
View Related
Oct 22, 1999
Does anyone know how to change the number of conccurent connections on SQL Server 7. We have purchased 10 additional licenses and I need to change the concurrent users from 10 to 20. Any help would be appreciated. Thanks
Phil
View 2 Replies
View Related
