I would change both port numbers to something other than 1433. This will
help solve your issue and provide you with something additional security.
Jaime E. Maccou
mailto:Jaime E. Maccou
"Our lives begin to end the day we become silent about things that matter."
- Dr. Martin Luther King, Jr.
"The mind does not take its complexion from the skin..."
- Frederick Douglass
There is always a way to do it better . . . find it!" Thomas A. Edison
DBA Ethical Rules
1. Don’t Lie
2. Don’t Cheat
3. Don’t Steal
4. Treat everyone fairly
5. Treat everyone equally"
-----Original Message-----
From: nishit [mailto:mssqldba-ezmlmshield-x26501341.[Email address protected]
Sent: Monday, March 31, 2008 5:27 AM
To: LazyDBA Discussion
Subject: Port Number Conflict
Hi all,
I am having a tricky situation which I want to resolve as soon as possible.
SQL Server 2005 was installed on the Windows 2000 box as a default instance.
Then, SQL Server 2000 was installed on the same box as a named instance,
with default port number i.e. 1433
Now, whenever I try to connect to SQL Server 2000, it gets connected to 2005
only as it is also running on the same port number. Changing port number on
2000 doesn't seem to be helping me out.
Now what I can do to get out of this situation?
Thank you. Your help will be greatly appreciated.
Thanks & Regards,
Nishit Shah
WIPRO INFOTECH (MUMBAI)
Contact No.:- +91-9820067873
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page