Behavior of SQL Server default instance on a NON-Default port
Posted by Karthick P.K on January 15, 2009
Unable to connect to SQLServer listening on Non-Default Port?
If you connect to SQLServer using the “hostname” it connects to the instance which is listening on 1433.
If you make named instance listen on 1433 and connect using “hostname” it connects to named instance which is listening on 1433.
if you connect to SQLServer using hostname or ip-address (without “\instance name”) it connects to instance which is listening on 1433, it can be named instance as well.(We have a belief that it connects to default instance because default port of default instance is 1433).
When you are connecting to SQLServer using hostname (without “\instance name”) client will not communicate with SQL Browser.
SQLClient would communicate with SQLBrowser only if there is “\instancename” followed by host name.
Dynamic port detection is only available for named instances of SQL Server 2000.
The behavior of SQL Server 2000 for a default instance is exactly the same as in earlier versions of SQL Server. The network libraries assume either 1433 or the
global default port established with the Client Configuration Utility.
If a default instance is listening on a port other than the standard 1433 port, you can provide an alias or change the global default port. You can also connect to the
instance of SQL Server by using its server name, its FQDN, or its IP address followed by a comma and the port number.
The mdac rules :
If you connect to a Named Instance, then you need to either specify the Server\Instance or Server,Port.
If you change the default port number for the default instance, then you need to specify Port number as well.
Regards
Karthick P.K
MSSQLWIKI 
Joanne said
Hello just wanted to give you a quick heads up. The words in
your post seem to be running off the screen in Firefox. I’m not sure if this is a format issue or something to do with browser compatibility but I thought I’d post to let you know.
The design and style look great though! Hope you get the problem solved soon.
Many thanks
baby Shower wording For invitations said
Good post! We are linking to this great content on our
site. Keep up the good writing.
GS Sohal said
Hi Karthick P.K,
Great post and very helpful,
by Global client “global default port established with the Client Configuration Utility”
you mean to mention –> SQL server configuration manager-> SQL native client configuration –> TCP/IP -> default port ??
photo wedding shower invitations said
My programmer is trying to convince me to move to .
net from PHP. I have always disliked the idea because of the costs.
But he’s tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year and
am anxious about switching to another platform. I have heard good things about blogengine.
net. Is there a way I can transfer all my wordpress content into it?
Any help would be greatly appreciated!
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] Behavior of SQL Server default instance on a NON-Default port […]
my.autaq.com said
Plan a budget for your wedding dress ahead of time, being sure to include a budget for alterations, pressing, and storage until your wedding
day. Use these helpful tips to find the style that suits you now.
If you are renting a facility such as a hall for the wedding, how much
space do you need to get.
Flawless Youth said
Flawless Youth
Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI
Alpha Fuel X Reviews said
Alpha Fuel X Reviews
Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI
ดูดไขมันหน้าท้อง said
First off I want to say superb blog! I had a quick question in which I’d like to
ask if you do not mind. I was interested to know how you center yourself and clear your
mind before writing. I’ve had difficulty clearing my mind in getting my
ideas out there. I do take pleasure in writing however it just seems like the
first 10 to 15 minutes are usually lost simply just
trying to figure out how to begin. Any recommendations or hints?
Thank you!
Royal Crown said
Good day I am so thrilled I found your site,
I really found you by accident, while I was browsing on Askjeeve for something else, Anyhow I am here now
and would just like to say many thanks for a tremendous post and a all round interesting blog (I also love
the theme/design), I don’t have time to read through it all at the minute but
I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read more, Please do keep
up the superb work.
no2 maximus said
I’m really enjoying the design and layout of your blog.
It’s a very easy on the eyes which makes it much more enjoyable
for me to come here and visit more often. Did you hire out a developer
to create your theme? Excellent work!
Keesha said
Hi i am kavin, its my first occasion to commenting anywhere, whenn i read this piece of writing i thought i could also make comment due
to this good paragraph.
100 Day Loans Reviews said
100 Day Loans Reviews
Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI
Procellix Reviews said
Procellix Reviews
Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI
glycemate Reviews said
glycemate Reviews
Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI
god of war game gratuit said
This blog was… how do you say it? Relevant!!
Finally I have found something that helped
me. Thank you!