connect to named instances

From: Hassan (fatima_ja_at_hotmail.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 16:29:17 -0700

How can I connect to a named instance from a client. I believe the problem
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.

Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..

Relevant Pages

  • Re: Correct Firewall Settings
    ... You can use the client network utility and create an alias ... and specify the port. ... >I needed to change the TCP/IP port from 1433 to 1499 for my ... >Tell me how to properly open ports on Windows XP SP2 Firewall. ...
    (microsoft.public.sqlserver.setup)
  • Re: Problem registering sql server
    ... You can use the Client Network Utility to specify ports - ... The named instance would normally go through the ... resolution service to determine what port it is listening ... Client Network Utility and specify the ports when setting up ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing default listening port
    ... You can create an alias on the client using "Client Network Utility" and there specify the port ... you can specify the port number in the server name/connection string. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • RE: registering sql server problem
    ... > Using the Client Network utility does make the server ... > show up in the list but it will not register. ... Client Network utility, and is the firewall open to that port? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Connectivity Problem
    ... no firewalls or port blocking in place. ... Sounds like the port SQL Server is listening on is being ... > Also kb on firewall port/access for SQL Server ... >> If I switch the protocol up to IP in Client Network Utility I get the ...
    (microsoft.public.sqlserver.odbc)
Loading