MSSQLWIKI

Karthick P.K on SQL Server

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

16 Responses to “Behavior of SQL Server default instance on a NON-Default port”

  1. 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

  2. Good post! We are linking to this great content on our
    site. Keep up the good writing.

  3. 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 ??

  4. 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!

  5. […] Behavior of SQL Server default instance on a NON-Default port […]

  6. 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.

  7. Flawless Youth

    Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI

  8. Alpha Fuel X Reviews

    Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI

  9. 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!

  10. 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.

  11. 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!

  12. 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.

  13. 100 Day Loans Reviews

    Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI

  14. Procellix Reviews

    Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI

  15. glycemate Reviews

    Behavior of SQL Server default instance on a NON-Default port « MSSQLWIKI

  16. This blog was… how do you say it? Relevant!!
    Finally I have found something that helped
    me. Thank you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: