Mark Rider
mark at markkaren.com
Tue Aug 17 23:51:36 CDT 2004
That helps, but one more question: Is that as simple as myserver:port? Or do I need to specify a port="portnumber"; in the string? Mark -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Tuesday, August 17, 2004 2:46 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Changing the default Port Settings On Tue, 17 Aug 2004 12:43:37 -0500, Mark Rider <mark at markkaren.com> wrote: > I have a database that is getting hit with a lot of connection > attempts, according to the log files. It is listening on 1433, which > I assume is where the login attempts are coming from. > > I can change the Firewall to allow a different port for the server, > and I know how to change the port setting in the Network Configuration > for the server. What do I need to do for the clients to connect to > the database server once the port is changed? I tried changing a test > database's port and could not figure out how to get to it from a > client. I changed it back and all was fine. > > What am I missing? On the connection string for your client, make sure you are including the same port you are changing on the server.... -- -Francisco _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com